Batch distance calculation
Calculate distances and travel times in bulk
Driving, truck, walking or straight-line distance and travel time for every row of an Excel or CSV file, from addresses or coordinates, in miles or kilometers. The first 100 rows every day are free.
- 1Upload
- 2Choose columns
- 3Preview on map
- 4Calculate
Each row is one trip
| From | To |
|---|---|
| 63 Flushing Ave, Brooklyn, NY 11205 | 200 Central Park West, New York, NY 10024 |
| 63 Flushing Ave, Brooklyn, NY 11205 | 350 5th Ave, New York, NY 10118 |
Addresses can also be split into street, city, state and zip columns. Coordinates work too: four latitude and longitude columns, or one column each like 40.7447 -73.9485. Other columns, like names or order numbers, come back unchanged.
No file at hand? Try 20 New York deliveries from addresses or from coordinates
A sample of your file, calculated
| Trip | From | To | Distance | Time |
|---|
Your file gets two new columns, Distance and Time. Change a setting and these five trips are calculated again.
Create a free account to calculate these distances
Your upload and your settings stay here while you sign up.
Calculate these distances
You are logged in as . The file goes to your dashboard, where you pay for it or use your plan's rows.
Sending your file
Keep this tab open until it reaches 100%. Your dashboard opens by itself.
The first trips are checked with Google reCAPTCHA; the Google Privacy Policy and Terms of Service apply.
What you get back
Distance and travel time for every row
Your file comes back as you sent it, with two columns added: the distance and the travel time of each trip. Trips from addresses also get each end’s latitude, longitude and matched address. These are three deliveries from a depot in Long Island City, by car on the fastest route.
| Store | From lat | From lon | To lat | To lon | Distance (km) | Time (min) |
|---|---|---|---|---|---|---|
| Upper West Side | 40.74470 | -73.94850 | 40.78132 | -73.97400 | 7.242 | 26.04 |
| Midtown | 40.74470 | -73.94850 | 40.74838 | -73.98485 | 3.832 | 11.73 |
| Lower Manhattan | 40.74470 | -73.94850 | 40.71297 | -74.00412 | 10.966 | 35.81 |
- Download it as Excel or CSV. Free files come as CSV.
- Other columns, like order numbers or names, come back unchanged.
- Thousands of trips in one file, calculated in the background.
Starting from addresses? One upload is enough
Leave the addresses as they are, in one column for each end or split into street, city, state and zip. Geloky finds both ends of every trip, measures the route between them and adds each end’s latitude, longitude and matched address, so you can see what was found.
A trip from addresses counts as 3 rows, two addresses and a route: $3 per 1,000 trips, with one $5 minimum per file.
Try a sample with addresses →Car, truck, on foot or a straight line
- Car: driving distance and time, by the fastest or the shortest route.
- Truck: routes and times worked out for trucks rather than cars.
- Walking: distance and time on foot.
- Straight line: the distance as the crow flies, without travel time.
In miles or kilometers, with ferries avoided when a route must stay on land.
How it works
From a list of trips to distances in four steps
Upload
Drop an Excel (.xlsx, .xls), CSV or TSV file of up to 1 GB with one trip per row, or paste rows from Excel or Google Sheets.
Choose columns
Origin and destination as addresses, whole or split into street, city, state and zip, or as latitude and longitude. Geloky matches the columns by their names.
Preview on map
The first trips are calculated and drawn on a map. Pick how to travel and the units; the preview updates as you go.
Calculate
Pay for the file or use your plan’s rows. It runs in the background, and the file comes back with Distance and Time added.
Pricing
What a file costs
Free
- 100 rows every day
- Results as CSV, kept for 24 hours
Pay as you go
- $5 minimum per file
- Paid once for that file, no subscription
Monthly
- 75,000 to 6,000,000 rows a month
- 20% back to your API wallet
A file of 3,000 trips costs $5, the minimum; one of 20,000 trips costs $20. A trip from addresses counts as 3 rows, so 20,000 of them cost $60. The tool shows the exact price before you pay. Compare all plans →
Distances from code or an AI assistant
The REST API gives the distance and time between two points or two addresses, at $0.001 per request plus $0.001 per address, or a route through up to 25 stops at $0.001 per leg. The MCP server lets Claude, ChatGPT or Cursor do the same for you, paid from the same API wallet.
FAQ
Distance calculation questions
Something else? Write to hello@geloky.com — a person answers within a day.
Upload a file with an origin address and a destination address on each row. Geloky finds both addresses, measures the trip between them and adds the distance, the travel time and each end’s coordinates, with no separate geocoding step.
Yes, without formulas or an API key. Upload the Excel file, choose the columns, and download it again with Distance and Time added. Excel files work as they are.
One file can be up to 1 GB. Big files run in the background: close the tab, and we email you when the file is ready to download. Monthly plans cover up to 6,000,000 rows a month, or unlimited rows.
The first 100 rows every day are free, with no card needed: 100 trips from coordinates, or 33 from addresses. Above that, a file costs $1 per 1,000 rows with a $5 minimum, paid once for that file, or you take the rows from a monthly plan from $20 a month.
Each trip takes three lookups: the origin address, the destination address and the route between them. That is what geocoding both ends and then measuring the trip would cost, but in one file with one $5 minimum: $3 per 1,000 trips.
Car, truck, walking or a straight line. Road trips take the fastest or the shortest route, in miles or kilometers, and can avoid ferries.
A straight line ignores roads, so it has a distance but no time to travel it. Choose car, truck or walking to get travel times.
In a file, each row is one trip from an origin to a destination, so list every pair you need as its own row. For a few places, the free distance matrix gives the straight-line distance between every pair, and the route API measures a route through up to 25 stops in order.
Files on the free plan are deleted after 24 hours; paid files stay on your dashboard until you delete them. The details are in the privacy policy.
Guides
More about distances in spreadsheets
How to Calculate the Distance Between Addresses in Excel
The haversine formula for coordinates, and driving distances between addresses for a whole spreadsheet in one upload.
Read the guideCleaning and Geocoding Delivery Addresses for Logistics
A workflow for delivery and field-service teams: standardize the address list, geocode it in batch, then compute distances to depots or between stops.
Read the guideDistance matrix calculator
Paste up to 25 places and get the straight-line distance between every pair, in miles or kilometers. Free, no sign-up.
Open the free toolJust one trip?
Popular city-to-city distances
Distance, driving time and both cities on a map, no spreadsheet needed.