Just posted an update that adds support for the Country tag (which lets our Canadian friends play) and fixes a bug that prevented some folks, particularly Excel 2000 users, from using the template.
Here’s a map of Dundee, a historic district of Omaha, that was plotted using the tool. Looks like the Dundee folks jettisoned their blog, too bad.
Related posts:
Jeffrey, This is a great tool for those of us lacking technical savvy or programming skills to create maps of our particular data. I’ve passed your url along to some folks who were desperately seeking a simple way to take their Excel documents and create a map. This is a nice start for us. BTW – since you mentioned the bug fix for Canada, does this mean that your tool is geared only toward the US and Canada addresses? Just wondering. Thanks!
Jeffrey, this is great! I was out tonight looking for some over the counter software that would do just this very thing, no luck. One question, When using this template does it prevent printing? It seems as though printing has been disabled? Thanks.
Thanks Mike, glad you like it. Printing isn’t an option using the template unless you save off the XML data it generates and post it to a Web site, similar to what you see here: http://api.maps.yahoo.com/Maps/V1/annotatedMaps?appid=jeffreymcmanus&xmlsrc=http://mcmanus.typepad.com/sandiegotrolley.xml
Jeffrey, I’m having trouble with this. When I click on the button saying “Send to Yahoo! Maps” I get an error message at the YMaps page saying “We need a city, state; city, state, zip; or a zip to generate a map.”
I’m using Excel 2003 and Firefox 1.0.7
Thanks! (I’ve been looking for a tool like this forever.)
Same problem with IE6 – and just when I needed it for a project.
Hope you get it fixed soon
Sorry about that guys, they changed something on the server side and I needed to futz with the template to accomodate it.
I just posted a new version that fixes the problem, get it from http://www.well.com/user/jeffreyp/mapmaker/
Cool, thanks! Any plans on making it capable of plotting more than 100 data points? That would be rad.
The 100-point limit is a limitation of the maps back-end, not the spreadsheet, unfortunately.
I have Excel 2007 which does not have a Menu bar that has Tools on it for this template. Do you have any suggestions? Work around?
Sorry, Victoria, I haven’t upgraded to Excel 2007 yet so I haven’t had a chance to test this tool with it. It should work though, it’s probably just a matter of finding the appropriate command in Excel 2007’s confounded new menu structure.
Jeffrey,
What a fantastic app! Has anyone figured out how to use this in excel 2007? I can think of a dozen ways to use this!
Thanks,
Nick
For Excel 2007 click on the Add-Ins tab and select “Display on Yahoo!Map