Use the Map Gadget to add interactive maps to your spreadsheets. Just follow these steps:
- In a column of your spreadsheet, enter the addresses you want to map. If you want display a tooltip when you click a location in the map, add the tooltip text to an adjacent column.
- Highlight the cells where you entered data in step 1.
- Go to Insert > Gadget.
- In the Add a Gadget window, scroll to Map and click the Add to your spreadsheet button.
- The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
- In the 'Title' field, create a title for your map.
- Click Apply.
The map appears in your spreadsheet.
If you change any of the data relevant to your map in your spreadsheet, the map will update automatically. You don't need to repeat the steps above to edit the map.
Interested in creating a Gadget of your own? Check out the Google Gadgets API and the Google Visualization API. For help using these APIs check out the Google Visualization API forum and the Google Gadgets API forum.