NEW Geloky now works inside Claude, ChatGPT and Cursor. See how Geloky inside Claude & ChatGPT →
  1. Help
  2. Batch distances guide

How to calculate distances for a spreadsheet

Distances and travel times for every row of a file, in six steps. Each row is one trip, from an origin to a destination, as addresses or as coordinates.

1

Upload your file

Each row needs an origin and a destination: two addresses, or their latitude and longitude. Drop the file on the upload box or paste the rows.

  • An address can sit in one column, or be split into street, city, state and zip columns.
  • Other columns, like order numbers, come back unchanged.
Drop your spreadsheet hereBrowse filesExcel, CSV or TSV
2

Choose your columns

Tell Geloky what the file holds, addresses or coordinates, and check the matched columns.

  • Addresses: one column for each end, plus city, state, zip or country columns when the address is split.
  • Four columns: origin latitude, origin longitude, destination latitude, destination longitude.
  • Two columns: origin and destination in one cell each, like 40.7447 -73.9485.
  • Points landing in the sea? Latitude and longitude are probably swapped.
BFromOrigin address
CTo streetDestination address
DTo cityDestination city
ETo ZIPDestination zip
Columns are found automatically; change any that are wrong.
3

Preview and choose how to measure

The first trips are calculated and drawn on a map. Pick car, truck, walking or a straight line, the fastest or the shortest route, and miles or kilometers; the preview updates as you go.

  • A straight line gives the distance only, without travel time.
  • From addresses, the preview shows what was found for each end. Check the matched addresses before you pay.
  • Avoid ferries if a route must stay on land.
Travel by
CarTruckWalkingStraight line
Units
MilesKilometers
The first trips on the map, calculated again when you change a setting.
4

Create an account or log in

Sign up with Google or your email to calculate the whole file. Your upload and your settings stay where they are.

Continue with Google
or with email
you@company.com
Create account and continue
5

Pay, or use your plan

Pay for this file, or use rows from your monthly plan. The first 100 rows every day are free. A trip from addresses counts as 3 rows: two addresses and a route.

Price$5.00
Pay $5Use plan rows
Payment confirms within a minute.
6

Download the results

Your file comes back with two new columns, Distance and Time, as CSV or Excel from your dashboard. Trips from addresses also get each end’s latitude, longitude and matched address.

nyc-deliveries.xlsx
Distances · Ready
CSVXLSX

FAQ

Common questions

Still stuck? Write to hello@geloky.com — a person answers within a day.

No road route was found between the two points, for example across water without a ferry or bridge, or one of the points was not a valid coordinate, or an address was not found.

Your first 100 rows are free. Every day.

No credit card · See your results on a map before you pay