Combine maps and spreadsheets with Google's new mashup tool
Have you ever wanted to create your own Google map? Maybe a top 10 list, or some of your favorite eateries. There are ways to do this with Ning and Yelp, but what if you really wanted to make changes later down the road and have those updates pushed out to anyone viewing your map immediately? Google has put together an experimental wizard for creating your own Google Maps mashup using data from Google Spreadsheets. The tool uses APIs from both Google Maps and Google Spreadsheets, but you won't have to know a lick of code, or anything super technical to use it.
Making your own test map with the tool is easy. Just start a new Google Spreadsheet, enter names, addresses, and descriptions. The only tough part is grabbing the latitude and longitude, which you can grab just by clicking the "link to this page" button on the top right of a mapped location in Google Maps. In your browser's address bar you'll see a ton of letters and numbers; you just want the two numbers that come after the ZIP code. Paste each one into the longitude and latitude cells on your spreadsheet and you're done with the hard part. From there, just follow the instructions on the wizard, grabbing the spreadsheet ID and picking how big you want your map to be. When you're done, you'll have a custom Google map that will update whenever you make changes and republish your Google Spreadsheet. Neat.
Our test mashup, which took about 10 minutes to create.
(Credit: CNET Networks)For now the wizard is limited to using a predetermined spreadsheet format setup for restaurants, but, man, is it cool to pull in data from your spreadsheet instead of filling out a form. This also opens up things from a group-collaboration perspective, allowing several people to work on map entries at once.
There are a few other tools that let you create your own Google Map. Google Map Builder is a paid-for software solution aimed at real estate agents that also lets you publish from spreadsheets. Mapbuilder.net is a free service that lets you to create your own maps using forms and a user interface. We're still waiting for a "map this" button in Google Spreadsheets to tie this all together.
[Found on Google Maps API blog.]
Josh Lowensohn writes for Webware.com, CNET's blog about Web applications and services. E-mail Josh, or follow him on Twitter at http://www.twitter.com/Josh. 
I wanted to let you know that embedding it in your blog as you've done will cause errors in IE, due to the javascript inclusion within a DIV.
There are several workarounds for this, but as they add a bit more code, I didn't put them in the code generated by the wizard.
In the case of your blog post, I would change:
cm_load();
to -
setTimeout('cm_load()', 500);
I believe that should make it work for your page.
- Pamela
So you can regenerate the code now, if you'd like.
Google's new MyMaps feature should be a much better fit. I found it really easy to use, hopefully you will too. That's not a plug, just a good alternative that surfaced after we tried this out.
- by Salesman_Gil April 28, 2009 3:30 PM PDT
- I agree this has been a great tool for me. Has anyone figure out having the direction links on the pop up bubbles from the markers?
- Like this Reply to this comment
-
(7 Comments)