Map a List of Locations from a Google Spreadsheet

« The Mathematics of Success | Home | Ferrari on Sea Cliff Bridge »

Map a List of Locations from a Google Spreadsheet

By Martin English | April 3, 2007

Pamela Fox wrote a post on Google Maps Blog that details how to create a map from a Google Spreadsheet that contains geographical information.

First you need to build a spreadsheet that has a header and a list of locations described by title, latitude, longitude. I’ve previously used this batch coder to produce map coordinates - because it uses the google map API, it isn’t US centric like so many others).

Once you have the spreadsheet, you need to create the connection with Google Maps. There are three ways to do that:

The simple way. This page requires to modify the URL and add the key parameter from the spreadsheet. That’s all: no customization, the spreadsheet must have fixed column names, no embedding option.

Almost as simple. This wizard lets you customize the map and embed it in your site.

The hard way. Use Google Maps API and Google Spreadsheets API to build your own application.

Because Google Spreadsheets has an API, you can use the spreadsheet as an easy-to-update structured file always available on the web, as an input for any web applications (not just google maps) .

Here is one I made myself