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 coordinate formats does BatchGeo support?

BatchGeo supports decimal degrees (e.g., 44.4604, -110.8281), degrees minutes seconds (e.g., 44°27'37.7", -110°49'41.3"), degrees minutes (e.g., 44°27.63', -110°49.69'), and directional formats (e.g., 44°27.63'N 110°49.69'W). Place non-decimal formats in a single column named "location."

Do I need separate columns for latitude and longitude?

For decimal degrees, yes, use separate latitude and longitude columns. For other formats (DMS, degrees-minutes, directional), put both values in a single column named "location" and BatchGeo will parse them automatically.

Can I map GPS coordinates from a handheld device or phone?

Yes. Export your GPS waypoints to a spreadsheet with latitude and longitude columns, then copy and paste into BatchGeo. Most GPS devices and apps can export to CSV or Excel format, which works directly with our tool.

What if I only have addresses instead of coordinates?

That works too! BatchGeo's geocoding service automatically converts street addresses, city names, and zip codes into map coordinates. You don't need to pre-convert anything.

How do I know if my coordinates are in the right format?

Decimal degrees are the most common format and look like two numbers, often with 4-7 decimal places (e.g., 40.7128, -74.0060). Latitude ranges from -90 to 90 and longitude from -180 to 180. If your values have degree symbols or N/S/E/W letters, use a single "location" column.

 

Explore More Features

Geocode Addresses IP Geolocation Map Excel Data Google Earth KML Data Analysis Make Google Maps