Getting data from Google Maps to Excel

Mapping visualization layers from Excel

The Google Maps API is a wonderful thing, allowing you to convert an unstructured and incomplete address and get back a whole bunch of structured and mapping data.
Google is clear that it is only to be used for addresses to be placed on a map (not to be used to ‘clean’ a list of addresses for example), and in fact there is quota on your use to make sure that you do not use it for this purpose.
However this new project is about mapping summary and transaction data on google maps, so I need to use the Maps API to summarize at country, state and other levels.
Downloadable example
The first phase in this can be seen here, with a downloadable example showing how to interact and decode the response from the Google Maps API.

Author: brucemcp

Leave a Reply

Your email address will not be published. Required fields are marked *