Batch Map Latitude and Longitude Coordinates

Our tool makes it easy to visualize your GPS data on Google Maps. It will only take a few seconds to map your data using our service. We support many different data formats, so you don't need to convert the values yourself before plotting. In fact, if you only have addresses or other location descriptions, we take that data, too.

Get Started
 

Three really simple steps

In most cases, your data is ready to go, just select (Ctrl+A or Cmd+A) the data in your spreadsheet and copy (Ctrl+C or Cmd+C) it to your clipboard.

Then follow these steps:

  1. Go to our Map Coordinates Tool
  2. Paste (Ctrl+V or Cmd+V) your data into the box
  3. Click "Map Now"

We told you it was simple, right? Each section below references the different formats we support. You may need to tweak your spreadsheet slightly, but we map all of these data formats and more.

 

Map coordinate data as decimal degrees

This is the most common type of latitude and longitude data. If your data is in decimal degrees format, you can paste it directly into our tool. Just make sure your data contains separate latitude and longitude columns and it will map instantly.

Decimals degree look something like this: 44.4604788, -110.8281375

The coordinate pairs may be positive or negative, depending on the hemisphere of the coordinates. Typically latitude is listed first and longitude second.

 

Map coordinates in degrees minutes seconds and other formats

If your latitude and longitude coordinates do not look like the decimal degrees in the previous section, our tool can likely still accept them. Put the coordinates in a single column named location and BatchGeo will take care of the rest.

The coordinate pairs may be positive or negative, depending on the hemisphere of the coordinates. Typically latitude is listed first and longitude second.

Some example data formats:

  • Degrees Minutes Seconds: 44°27'37.7237", -110°49'41.2950"
  • Degrees Minutes: 44°27.62873', -110°49.68825'
  • Directional Degrees Minutes: 44°27.62873'N 110°49.68825'W

You may have other data formats, but the solution is the same: use a single column (rather than two) and let BatchGeo worry about the converting and mapping.

 

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.

 

Explore More Features

Map Excel Data Geocode Addresses Data Analysis Embed Maps Store Locator Sales Mapping