Map Excel location data with BatchGeo
Many people and organizations rely on Excel documents to store location data, including addresses, zip codes, cities, and states. BatchGeo makes it easy to Map Excel location data with BatchGeo by converting your Excel (XLS) spreadsheet data into an interactive map. As an excel to map converter and online mapping software, BatchGeo functions as an easy map maker and custom mapping tool online, helping you easily create a map from an Excel spreadsheet in just minutes.
Whether you're mapping your company's prospects, creating Maps from Spreadsheets for internal planning, or visualizing a family holiday card list, BatchGeo helps you quickly turn spreadsheet data into meaningful maps. Upload Excel documents to store location data, explore each location by clicking map markers to reveal additional details, and Map Store Locations or territories with ease.
Get StartedCreate an Excel map
It's easy to put your spreadsheet data on a map with BatchGeo. While Excel is the most common application, the same process also works with Numbers and Google Docs. BatchGeo's online mapping software functions as an easy map maker and custom mapping tool online, allowing you to easily create a map through a simple map from Excel spreadsheet workflow. With BatchGeo, you can group data by spreadsheet columns, giving viewers the ability to filter and display specific subsets, making it a powerful and flexible solution for turning spreadsheets into clear, shareable maps.
Only one column needs to contain location data. For example, you might only have zip codes or city names, or you could have a complete address. The more data you have the better.
To get started, follow these steps:
- Open your spreadsheet
- Select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) all your data
- Open your web browser and go to batchgeo.com
- Click on the location data box with the example data in it, then paste (Ctrl+V or Cmd+V) your own data
- Check to make sure you have the proper location data columns available by clicking "Validate and Set Options"
- Select the proper location column from each drop down
- Click "Make Map" and watch as the geocoder performs its process
Once all of your rows are geocoded, click “Save & Continue” and enter some details about your map. Provide a title and, optionally, a description. To claim the map as your own, which allows you to edit it later, include your email address.
Now click “Save Map” and you'll be directed to your map's unique page.
Watch these short videos
For more information on how to create a map using Excel spreadsheet data, watch our short videos.
5 Ways To Make Your Map Stand Out
Make your BatchGeo maps stand out with these 5 simple tips! In this tutorial, we'll show you how to make your maps more interactive, informative, and visually engaging so your data tells a story that stands out.
Calculate Distances Between Locations
`Need to measure the distance between your map locations? We'll show you how to turn Excel spreadsheet data into a Google Map.`
How to Map Latitude and Longitude
Turn a simple list of coordinates into an interactive map, no coding required! Turn Excel spreadsheet data into a Google Map.
Choropleth Style Boundary Maps
Create stunning choropleth style maps, also known as boundary maps, directly from your spreadsheet data using BatchGeo.
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 batchgeo.com/map/. 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.
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.
Frequently Asked Questions
What is BatchGeo and how does it work?
BatchGeo is a free online mapping tool that turns spreadsheet data into interactive Google Maps. Simply copy your data from Excel, Google Sheets, or any spreadsheet, paste it into BatchGeo, and click "Map Now." We automatically geocode addresses, city names, zip codes, and coordinates to place your data on a map.
Is BatchGeo free to use?
Yes, BatchGeo offers a free tier that lets you create maps with up to 250 rows of data. For larger datasets, advanced features like password protection, and ad-free maps, BatchGeo Pro plans start at $99/month.
What types of location data does BatchGeo accept?
BatchGeo accepts full street addresses, city and state names, zip/postal codes, latitude and longitude coordinates, IP addresses, and even landmark or business names. We support data from over 200 countries worldwide.
Can I embed a BatchGeo map on my website?
Absolutely. After saving your map, you receive embed code that works like embedding a YouTube video. Just paste the HTML snippet into your website, blog, or CMS. The map is hosted on BatchGeo servers and displays seamlessly on your page. Learn more about embedding maps.
How do I share or update a map after creating it?
Every map gets a unique URL you can share via email, social media, or messaging. To update your map, use the edit link sent to your email when you saved the map. You can modify data, change settings, and re-save at any time. See our guide on editing map data.
