Create a map from a published Google Spreadsheet

Embed a dynamic map of a publicGoogleSpreadsheet on your webpage.After loading in your spreadsheet data and customizing the map,you can copy the generated code into your webpage. An examplespreadsheet‘s data and map of great Seattle restaurants has beenpre-loaded. You can view theoriginal spreadsheet inHTML orXML.
This wizard uses theGoogle Maps APIandGoogle Spreadsheets API.
Load worksheet data
To find the spreadsheet and worksheet ID for your Google spreadsheet:
Save and publish the spreadsheet (Warning! Don‘t publish private data!)
Click on "More Publishing Options," change file format to ATOM & generate URL
The URL should look something like ‘http://spreadsheets.google.com/feeds/list/[spreadsheet key]/[worksheet id]/public/values.‘
Find the parts of the URL that match the example below and paste them in.
Click "Load Worksheet Data" button when done. If your worksheet loadedsuccessfully & you‘re using Firefox, you‘ll see a snapshot of thecolumn data below. Note that the first row is treated as the headerrow - so it‘s best to put descriptive column titles there (e.g."year", "revenue").
Spreadsheet Key:
Worksheet ID:
Load Worksheet Data
rank title bestdish address latitude longitude description
1 2 Pan Africa Market Chicken, Apricots & Dates 1521 1st Ave, Seattle, WA 47.608941 -122.340145 You must try the Chicken, Apricots & Dates

1521 1st Ave, Seattle, WA
2 8 Buddha Thai & Bar Chocolate cake shot 2222 2nd Ave, Seattle, WA 47.613591 -122.344394 You must try the Chocolate cake shot

2222 2nd Ave, Seattle, WA
3 4 The Melting Pot Yin Yang drink 14 Mercer St, Seattle, WA 47.624562 -122.356442 You must try the Yin Yang drink

14 Mercer St, Seattle, WA
... ... ... ... ... ... ... ...
9 5 Piroshky Piroshky Salmon piroshky 1908 Pike pl, Seattle, WA 47.610127 -122.342838 You must try the Salmon piroshky

1908 Pike pl, Seattle, WA
Customize Map Output
Choose the column names that will help us create your map.
Note that latitude and longitude are required-- if your spreadsheetdoes not have latitude/longitude information, please geocode it first.
Title -none selected- rank title bestdish address latitude longitude description
Latitude -none selected- rank title bestdish address latitude longitude description
Longitude -none selected- rank title bestdish address latitude longitude description
Description -none selected- rank title bestdish address latitude longitude description
Rank -none selected- rank title bestdish address latitude longitude description
Width:
Height:
Include sidebar?
Marker color: red orange green pink blue
Highlighted marker color: red orange green pink blue
Generate Code
The Maps API requires a free API key that‘s associated with your Google Account and the URL of your web site.You can sign up for onehere, and substitute itas the value of the "&key=" parameter in the script tag below.
Check this box if you‘d like an HTML header/footer generated: