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 [email protected] Regards Anand On Sat, 7 Oct 2017 at 10:54 AM, Shijith Kunhitty <[email protected]> wrote: > You can use this excel add-in http://www.calvert.ch/geodesix/ for reverse > geocoding > > According to this page > <http://www.calvert.ch/geodesix/help/functions/geocode-function/> , 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
