Skip to main content
April 25, 2011

Create a Google Map from your spreadsheet in less than 30 seconds!

In this post, Bee shows you how to create a Google Map from your spreadsheet in less than 30 seconds…

Bee Thao

Google Map is a great tool to show your visitors where you are located.It is relatively easy to generate a map for your site by simply going to http://maps.google.com and typing in your address.Once the map is generated, all you have to do is click on ‘Link’ and copy the code and embed it to your Web page.

Things get a little more complicated if you want to showcase a couple hundred addresses on a map.So, I’m going to list a few places online that will allow you to easily create a map.All you need is a spreadsheet containing the addresses you want to plot.

There are dozens of sites that offer this sort of mapping service, but I’m going to narrow it down to three of the fastest and simplest ones that I’ve come across.

BatchGeo (http://www.batchgeo.com)

This was the easiest and fastest way for me to create a map using addresses that I had on my spreadsheet.All you have to do is copy the data and paste it into their window.Click ‘Map Now’ and it will generate your map.It is smart enough to read your column and guess which one is the address.I tested it with 100 addresses and was able to get a map in less than two minutes. There are additional features that you might want to incorporate into your map such as grouping addresses by certain attributes or including additional information on your map window.

Fm Atlas (http://www.fmatlas.com)

Fm Atlas has a very simple interface and not a lot of features, but it is quite fast at what it does.After you register for a free account, you log on and upload your spreadsheet and it will generate your map.My list of 100 addresses took less than one minute.The only drawback to Fm Atlas is that it was not able to read my spreadsheet if I separated my addresses into individual columns like address, city, state, zip.Instead it works if you combine your address elements into one column.If you’re looking for a no-frills map generator, try this one out.

Communitywalk (http://www.communitywalk.com)

This was the fastest map generator out of the three.My list of 100 addresses took less than 30 seconds to generate.The interface is busier looking than the other two because they have advertising sponsors on the site, but there are a lot more features available that enable you to change the look and feel of your map.You can also add other elements like photos and comments into the pop-up info window.

 

You don’t need to know the Google API or develop your own custom program to generate a great looking map.There are services out that will help you be more productive.Give one of these great sites a try and let me know if you find any other interesting map generators out there.