Getting data from Google Maps to Excel

August 16, 2011 Integrating Excel with Maps and Earth, Visualization Comments Off on 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.
About brucemcp 225 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.
Twitter