Reverse Geocoding in Excel, not just for the address

[angomera]

I have been looking everywhere for an addin or a code for excel that can help me do reverse geocoding: https://developers.google.com/maps/d...eocoding/intro

Reverse Geocoding basically consists of getting the address of a place after providing latitude and longitude.

Google maps appi provides much more than the address. It also throws results of all the address components: Ej

address_component
Name
neighborhood
political
sublocality
sublocality_level_1
locality
political
address_component


You can see a better example here:

What I need is an addin or preferebly a code for excel that gets all this components for every latitude and longitude I provide.

Can someone help me with this?

[Trebor76]

For reference this has been cross-posted here:

http://www.ozgrid.com/forum/showthread.php?t=202704
https://www.mrexcel.com/forum/excel-...t-address.html
http://stackoverflow.com/questions/4...or-the-address

[krovy]

@angomera have you find any solution, looking for the same thing.
If you can share your script it would be great.

[gdaniels]

Hi, although I did not use Excel, I did create a website that does reverse geocoding. If any of that is of use to you let me know and I'll share whatever code you may find helpful. The website is at: http://www.askdata.net/revgeo/revgeoin.php.

[luuminhvuong93]

Hi, although I did not use Excel, I did create a website that does reverse geocoding. If any of that is of use to you let me know and I'll share whatever code you may find helpful. The website is at: http://www.askdata.net/revgeo/revgeoin.php.

It only work with American geocode?
I live in Asia and would like to perform the same task

[Logit]

.
http://www.ozgrid.com/forum/forum/he...dress?t=202704

https://www.ozgrid.com/forum/forum/h...dress?t=202704

POST # 14

[gdaniels]

It only work with American geocode?
I live in Asia and would like to perform the same task

I am not sure if it only works in America as I have not tried any locations outside the United States. I used GoogleMaps to to send the request and receive the data so it would depend if GoogleMaps only has geocode data for the United States or other countries.