Create a map from a published Google Spreadsheet
Popularity Report
 |
|||
|
|||
|
|||
|
|||
|
|||
|
Rank
URL Tag Cloud
Bookmark History
Saved by 36 people (-9 private), first by anonymouse user on 2007-04-04
- A_d_smith86 on 2009-08-22 - Tags google , googlemaps , mashup , maps , spreadsheet
- Kmorris on 2009-06-03 - Tags map
- Libraraga on 2009-05-21 - Tags googlemaps , google , spreadsheet , maps , googledocs
- Faheyr on 2009-04-24 - Tags googlemap , mashup , googlespreadsheet , googlemaps , api
- Eemann on 2009-04-15 - Tags mapping , spreadsheets_maps , google_spreadsheets , googledocs , googlemaps
Public Sticky notes
Highlighted by herald
Highlighted by davecrosby
Highlighted by herald
Create a map from a published Google Spreadsheet
Embed a dynamic map of a public Google
Spreadsheet on your webpage.
After loading in your spreadsheet data and customizing the map,
you can copy the generated code into your webpage. An example
spreadsheet's data and map of great Seattle restaurants has been
pre-loaded. You can view the
original spreadsheet in
HTML or
XML.
This wizard uses the Google Maps API
and Google 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 loaded successfully & you're using Firefox, you'll see a snapshot of the column data below. Note that the first row is treated as the header row - so it's best to put descriptive column titles there (e.g. "year", "revenue").
Highlighted by fpbarreira
Public Comment
on 2007-04-04 by edventures