- Help
- 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.
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.
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.
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.
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.
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.
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.
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.
Fastest picks the quickest route, like a navigation app. Shortest picks the fewest miles, even if it is slower.
In a spreadsheet each row is one trip. For a route through up to 25 stops in order, use the multi-stop route API.
Miles or kilometers, as you choose. Times are always in minutes.
Geloky takes the best match for each address, as batch geocoding does. A cell like “TBD”, or an address without its town, can match a place far away. The matched address columns show what was used: fix those cells and send the trips again. When the addresses are in more than one country, add the country.
Your first 100 rows are free. Every day.
No credit card · See your results on a map before you pay