« Serious Storage | Main | Notes on OverDrive: The Next Generation »

Guest Post: Using BatchGeo to Make Google Maps

Kerri's test map
Kerri's test data above, resulting map below.
What is BatchGeo? It's an easy way to convert spreadsheet data into a Google Map.

Guest post by Andy Barnett, Assistant Director at McMillan Memorial Library in Wisconsin Rapids.

  1. First, start with some an excel spreadsheet that includes address information, such as a list of patrons. McMillan used a list of patrons residing in a township.
  2. Decide what you want to display on the map. Address, city, state, zip are essential to creating the map. Depending upon your data, this might include a number of things. We included patron barcode, but not anything else. This allowed us to identify and check any questionable addresses.
  3. Copy the relevant data. If you copy entire columns, the first row will serve as headers and will not be mapped. If you copy a selection, the first row will be treated as headers and will not be mapped. We copied a selection and the row above, which gave us confusing headers, but accurate mapping.
  4. Go to http://batchgeo.com/. Paste the data where it says Copy and then paste your location data below.
  5. Click on Validate & Set Options. Match address, city and zip to your fields.
  6. Finally, choose Map Now. A link to the map will be emailed to you. Maps can be public or private.

There is a limit of 2,000 items per map in the free version and the fee version creates maps faster.

Some addresses do not map correctly. CTY TRK doesn’t work, but CO RD does. Some state highways also confuse the mapping, especially when they use South or North in the address. BatchGeo is not as smart or forgiving as the USPS.

The resulting maps are zoomable and can be shared. When zoomed out, patron are aggregated and shown as numbers. City/village edges are easy to see, but county and township boundaries are not displayed. They can be used to check PSTATs, show where patrons live, or just for funsies.


Feed You can follow this conversation by subscribing to the comment feed for this post.

After all the data is mapped, can you use those points to create data on distances and directions?

Just yesterday, I was wanting a tool that does just this very thing. And then, voila!, I read your post.

Thank you!

Post a comment