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/documentation/geocoding/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?

 

[RedBeard]

This: https://github.com/tdowd/excel-geocoder

 

[angomera]

This: https://github.com/tdowd/excel-geocoder

Hello Redbeard,


Thanks for your help. Before you suggested that link I did try that solution,but I found two problems:


1. I have not been able to insert the code they provide in geocoder.bas into the Visual Basic Editor. Well I have, but then the macro does not show in the list of macros.
2. In the "Usage" section they say:


"Takes in a latitude, longitude pair and returns the first formatted address from the geocoder."


That means just the address and as I stated before I need all the address components.

 

[John_w]

See the G_ADDRESS UDF at Google Maps and Excel download | oCoCarbon.

 

[angomera]

See the G_ADDRESS UDF at Google Maps and Excel download | oCoCarbon.

Hello John, thanks a lot for your suggestion. I tried it and it works for finding the address, which I allready have in my database. This solution is missing what all others and I havent been able to find. Two pieces of data:


neighborhood and sublocality_level_1

Ej: https://maps.googleapis.com/maps/ap...8&key=AIzaSyD-5j4cX3TKgfJAeQSlETDadjoQHsXBF6Y


neighborhood = La Porciúncula
sublocality_level_1 = Chapinero

 

[Trebor76]

For reference this has been cross-posted here:

Reverse Geocoding in Excel, not just for the address
Looking everywhere for VBA to do reverse geocoding, not just for address
http://stackoverflow.com/questions/4...or-the-address