Batch Distance Calculation for Spreadsheets

• Upload data

  Batch Distance Computations based on Latitude/Longitude

  Hint

  Uploaded spreadsheet must be readable, not empty and be encoded using UTF-8, if you expect to get clear distance calculation.

  If you need to calculate distance between addresses - you should convert them to latitudes and longitudes before that. You can do it with our Batch geocoding tool here

  Browse or drop your spreadsheet here

  or

  or

  Paste coordinates here

  We accept only .xls, .xlsx, .csv, and .tsv files.

  ×

  Max file size per upload: 1gb.

  ×

  We accept .xls, .xlsx, .csv, and .tsv files. Max file size per upload: 1gb.

  Coordinates File name

  Enter file name and paste data above.

  ×

  Back

  Continue

  Data is retrieving. Please wait.
• Setup data

  Select data grouping, define column names and select additional settings

  Individual latitudes & longitudes

  Grouped Latitudes & Longitudes

  First row is header

  Hint

  Select the columns that contain latitude and longitude. Each Latitude & Longitude of Origin and Destination is in an individual cell (must be two separate cells).

  Origin Latitude

  Origin Longitude

  Destination Latitude

  Destination Longitude

  Hint

  Select the columns that contain origin latitude & longitude and destination latitude & longitude. Origin/Destination (Latitude and Longitude are separated by space in a cell).

  Origin

  Destination

  Order

  Latitude Longitude Longitude Latitude

  Priority

  Fastest route Shortest route

  Movement type

  Automobile Truck Walking Direct line

  Units of distance

  Miles Kilometers

  Avoid ferries

  If you need some additional settings - contact us

  Few rows of data for preview results

  Back

  Continue

  Please select valid data for distance calculation, select data grouping and if first row is header.

  ×
• Preview

  It's a sample of how your distances are calculated

  Origin	Destination	Distance ()	Time (min)

  Back

  Continue
• Finalize
  Log in

  Sign up

  Continue with Google

  Your email address

  Password

  Remember me

  Submit

  Your email address

  Password

  Repeat password

  I have read and agree to the terms and conditions

  Submit

  Back