Featured gadget: map it in your spreadsheet
June 26th, 2008 | Published in Google Docs
The situation: My good friend Tomashi is visiting New York, and I want to map out a few places for her to visit near my work before we meet for the evening.
What do I do? I use the spreadsheets map gadget, which easily adds a Google map pinpointing all the addresses I've entered.
Here's how:
- I choose some places in the neighborhood that I think Tomashi would like visiting, and add their addresses along the first column of my spreadsheet.
- In the next column, I enter the name of each place, and a short description.
- I highlight all of the cells that contain information I'd like included in the map.
- Along the top of the toolbar, I click, "Insert Gadget." In the menu that appears I select "Maps" from the list on the left, and choose, simply, the "Map" gadget.
- Finally, I give the map a title, check the box next to "Last column as tooltip" and, as is my preference, choose to allow zoom using mouse wheel. When all's done, I click "Apply and close."
And, here's a link to the full spreadsheet, showing the guide that I'll share with Tomashi when she visits.
Of course, this is great for a lot of other things, apart from visiting friends. These include:
- House hunting (enter the addresses in one column, and any corresponding numbers, or information in the next)
- Road trip planning
- Charting restaurants, shops, or other places you'd like to visit
- Anything else where a map could flesh out a list of addresses :)