Revese Geocoding in Excel

[Noor Hasan]

can anyone have an idea about the reverse geocoding in excel for using developer mode?.
Reverse geocode means convert lat/long to address of the particular location.

[S Anand]

Shijith, if I’m not mistaken, Noor is looking for the opposite: convert lat-long to an address.

The source for a geocoder is at https://github.com/sanand0/geocode-excel. We can change the API to a reverse geocoding one like https://developers.google.com/maps/documentation/javascript/examples/geocoding-reverse

Noor, happy to help with this if you like. I’m reachable at 9741552552 and s.a...@gramener.com

Regards
Anand

On Sat, 7 Oct 2017 at 10:54 AM, Shijith Kunhitty <shij...@gmail.com> wrote:

You can use this excel add-in http://www.calvert.ch/geodesix/ for reverse geocoding

According to this page , after installing the add-in, you would type in a cell: =Geocode(“formatted_address”, B2). 

B2 is just a cell having the coordinates in a 'lat, lon' format, that is latitude followed by longitude with a comma in between, for eg. 51.5049511,-0.1431289

If there's a better excel solution out there though, please let Noor know

On Friday, 6 October 2017 12:30:58 UTC+5:30, Noor Hasan wrote:

can anyone have an idea about the reverse geocoding in excel for using developer mode?.
Reverse geocode means convert lat/long to address of the particular location.

--
Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Noor Hasan]

Thank you dear Anand for your reply,

I hope this information can help me a lot.

[S Anand]

Great.

In any case, I just added reverse geocoding to the Excel file at https://github.com/sanand0/geocode-excel. FYI.

Regards,

Anand

To unsubscribe from this group and stop receiving emails from it, send an email to datameet+unsubscribe@googlegroups.com.