Map Spreadsheet Locations To Google Maps

Batchgeo is a free online service that maps spreadsheet locations to Google Maps. This can be useful for several purposes including creating a store locater, creating a map, calculating distances, house or apartment buying, finding the best route to visit several locations and more.

All that needs to be done to map the locations is to paste the spreadsheet information into the form on the Batchgeo website. The online service will automatically use the first row as identifiers which means that users need to make sure that it contains those. Identifiers such as zip, address or city need to be linked to the right columns in case the automatic detection does not do that correctly.

Batchgeo creates a Google Maps map with the location of the spreadsheet displayed on the map. It is then possible to save, print and share the map that has been created, download Google Earth KML data, or download the geocoding results again. All Google Maps view modes are available (map, satellite, hybrid and terrain).

There does not seem to be an option to directly embed the mapped information on a website, only to create a static url on the batchgeo website. The blog mentioned a button to create the embed code but the button is nowhere to be found on the site.

Batchgeo can be a handy program, especially for users who need to create a map from location information stored in a spreadsheet.

Update: The core service is still freely available on the Internet. The developers have added a professional option to their website some time ago, that is offering faster geociding, password protection, street view integration and pdf support among other features.

The service is ideal for brokers, and people who are looking to buy an apartment or house.

Related Articles:

Author: Martin Brinkmann, Friday April 30, 2010 -
Tags:google maps, spreadsheet

Responses so far:

1. DanTe says:

   May 1, 2010 at 2:09 am

   Thanks. Some folks in marketing would like this.

   Reply