Google or Yahoo Mapping with BatchGeo

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.


BatchGeo

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.

Mapped Locations

Mapped Locations

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.

Example Spreadsheet Template

Example Spreadsheet 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.

Locations Spreadsheet

Locations Spreadsheet

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.

Click, Then Paste

Click, Then Paste

Pasted Data

Pasted 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).

Set Options

Set Options

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.

Save, Print or Share

Save, Print or Share

Save Map

Save Map

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

Custom Batch Geo URL

Custom Batch Geo URL

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!


  • http://www.whchurch.org Jim

    This is great! Been looking for a free version of something like this. I just created one from over 1500 locations and it worked great.

  • Keegan

    Tried it out for a travel site I’m working on…very intuitive and renders a very nice presentation. Love it and will use it for the entire site.

  • Larry Bogatz

    I’s like to use basic Batch Geo software to plot a number of addresses (approx 70). Do I need to purchase software or otherwise download Batch Geo?

theatre-aglow
theatre-aglow
theatre-aglow
theatre-aglow