When you need to map out multiple addresses, it can be a bit of a pain, not to mention time consuming. An easy way to get all your addresses mapped into Google or Yahoo maps, is with BatchGeo. Using a spreadsheet of your location information, BatchGeo will do the rest, mapping each of your locations and allowing you to save, print or otherwise use the resulting map.

Let’s take a look at using BatchGeo.

Overview

BatchGeo’s app is quite simple to use but could save massive amounts of time. I’ve long ago lost count of the number of people I’ve met that have tediously mapped out their store locations — one by one. BatchGeo is an incredibly useful app for travelers, house or apartment hunters, etc.

I’ll take a quick look at mapping with Google maps but BatchGeo also offers a Yahoo maps version if that’s what you prefer.

Using BatchGeo

Collect your list of addresses via spreadsheet, using an app like Excel, Numbers or free apps like Google Docs or Open Office Calc. You can start with BatchGeo’s spreadsheet template but creating a new one is just as easy. You’ll also likely not need all the information in their template.

Creating the Spreadsheet

I’ve created a new spreadsheet in Google Docs and added a few basic columns; address, city and state. You can add more information such as the zip code, location name, phone number URL and more. The more information you provide, the more accurate results you’ll get. I didn’t have any issues using only the basics though.

Enter The Data

I’ve collected the addresses of all the Rebel fuel stations in Las Vegas and Henderson, Nevada that offer 100 octane gasoline (racing gas). From here, simply highlight all the spreadsheet data and copy it. Head over to BatchGeo.com and click in the source data field, then paste your data.

Mapping & Options

From here, you can choose to click Validate & Set Options if you want to check your data or set additional options. You can optionally set the default map view, calculate location distance, etc. If you don’t need to validate your data or set additional options, just click Map Now (or Run Geocoder).

Save, Print or Share the Map

Once the app finishes geocoding, your map of locations will be displayed, which you can optionally save, print, share or save a Google Earth KML file for import. Choosing to save the map, a popup overlay will appear with additional saving and sharing options.

You’ll then get a custom BatchGeo URL to view the map and find locations nearest a desired address.

Other Mapping Apps?

BatchGeo is definitely a very useful app for mapping but if you use another mapping app, even if for a different purpose, I’d love to hear about it. Thanks!

Don’t Forget, Subscribe and Follow

Be sure to subscribe to our feed and follow us on Twitter for more great web app reviews, how-tos, roundups and giveaways!