Subscribe Us

Enter your email address:

Loading

Google Maps In Excel

Labels: , ,

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 >>

'



0 comments:

Post a Comment

Post a Comment