Google Maps developer Tip: Using Google Docs & Spreadsheets to create your Google Map
Written by Glenn Letham (GISuser editor)
02 April 2007
An interesting tip comes our way from the Google developer weblog. Using data stored and maintained in a simple spreadsheet, users can use tools like the Google Spreadsheets API to quickly map your data using Google Maps.
The data is read into the wizard, optionally, the map configuration can be altered, the map is viewed online, and then the code is optionally generated and returned to the user... I think even I can handle this one!
Once the map is created the code can be used to quickly embed the map on a website or upload to a Google pages account. Those of you with no google account need not worry as a nifty tool is available from Esa where you can simply pass the ID of your Google Spreadsheet and see the resulting map. An example is here or you can simply substiture your spreadhsst's ID to view your data.
You can easily try this for yourself, provide you have a google account, some sample data, and Lat/Long values for your data - this may require the use of a geocoding routine and there are plenty of them out there, many are free! If you need to locate more mashup developer tools see this section in the GISuser repository (toolbox) - the Batch Geocoder may be a good starting point!
Recall, the Google Spreadsheets data API allows client applications to view and update Spreadsheets content in the form of Google data API ("GData") feeds
HxGN Live - The Hexagon Global Network - Learn about surveying, mapping, laser scanning and geospatial solutions from Leica Geosystems. June 3-6, 2013, Las Vegas, Nevada
Join us at GIS for Government 2013 taking place June 24-26, 2013 in the Washington, DC Metro Area to find out everything you need to know about GIS. Click here for more information
To register for the first GCS Geospatial Big Data webinar, visit the new GCS website at www.YourDataSmarter.com. The one-hour free webinar will be broadcast live at 3 pm EDT Wed, June 12, 2013