Google Maps In Excel - Special Movies and Comedy

Latest

Special Movies and Comedy

Wednesday, March 2, 2011

Google Maps In Excel

An interesting idea. But how, beyond the neato factor, would one use an Excel sheet with an embedded Google map?

Source – Google Maps In Excel

Here’s my first attempt at using Google maps in excel (download below). Currently I can input an address and have a Google map of the address displayed in Excel, with most of the cool google functionality.
....
So how does it work?
Summary:
1. The address is sent to Geocoder.us to be converted to Latitude and Longitude (required to map a location on google maps), and the result is returned to the spreadsheet.
2. Excel sends this geocoded information to the automateexcel.com server, where I have a google map that receives latitude and longitude as variables and displays the respective map via the Google Map API.



Read more at its sources >>

No comments:

Post a Comment