Google Maps In Excel - Excel Training & Excel Tutorial

Latest

Excel Training, Excel Tutorial that could you become Excel Expert

BANNER 728X90

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