Map Your Excel Location Data with BatchGeo


Many people and organizations use Excel documents to store location data in the form of addresses, zip codes, cities, and states. BatchGeo lets you easily create a map from your Excel (XLS) spreadsheet data.

Whether you’re mapping your company’s prospects or family’s holiday card list, you can quickly visualize the places on a map, then share it with others. Once your data is on a map, you can even explore it by clicking the markers, which will show any additional information about the place. Optionally, you can group by certain columns in your spreadsheet, so viewers can choose to display only a subset of your spreadsheet.

map excel data

Share Your Map

There are a handful of ways to share the map you’ve just created. For starters, you can simply copy the URL from the location bar in your web browser. Highlight and copy (Ctrl+C or Cmd+C) the address, which will start with You can then paste (Ctrl+V or Cmd+V) the URL into an email, an instant message, a tweet, or anywhere else you want to share it.

copy map url in browser

You can also embed the map into a web page, such as a blog post. BatchGeo supports both full interactive map embeds, as well as a simple badge, which provides a quick preview of your map and a link to the full map. You can retrieve the code for each of these embedded maps when you edit a map or in the email you receive when you provide an email address as you save your map.

Lastly, you can view in Google Earth using the KML file version of your map. Anyone using Google Earth can load this file to see your map’s locations in the 3D browser.