Add a route
Type where the journey starts and where it ends. The arrow gets written for you.
Both boxes need something in them.
Free Bulk Distance Calculator
Get real driving distances and travel times for up to 25 routes at once. Type them in, paste them, or upload a CSV or Excel file. No sign-up.
Working out the routes
A few seconds for a longer list.
| # | Origin | Destination | Distance | Travel time |
|---|
Got more than 25 routes?
The Excel Distance Calculator does the same job inside your workbook, with no row limit and no copying between windows. It uses your own Google key, so the only ceiling is your quota.
Get the Excel tool$49 once. Lifetime updates.
- Free, no sign-up
- Up to 25 routes at once
- Real road distances from Google
- Drive, walk, cycle or transit
How it works
Three steps, and the first one is usually a paste.
Enter your routes
One per line, with an arrow between origin and destination. Or import a CSV or Excel file with up to 25 rows.
Pick the settings
Drive, walk, cycle or transit. Kilometres or miles. Hours, minutes or both. Switch on live traffic if you want current conditions.
Read or download
Distances and times appear in a table straight away, and the whole set downloads as a CSV your spreadsheet will open.
Four ways to travel
Set one mode for the whole list, or a different mode per row in an imported file.
Driving
Road distance and drive time by car, following highways, one-way streets and turn limits.
Walking
Pedestrian routes along pavements and footpaths, with a walking time to match.
Cycling
Bike-friendly roads and cycle paths, avoiding the roads a bicycle should not be on.
Transit
Buses, trains and subways where the local operator publishes its timetable to Google.
How accurate are the results?
Every route is calculated with the Google Routes API, the engine behind Google Maps. Real road distances, not straight lines.
Real road distances
The distance follows actual roads, so it accounts for turns, one-way streets and restrictions rather than measuring a straight line between two points.
Travel time estimates
Times are based on speed limits, road types and historical traffic. Switch on live traffic for an estimate that reflects the road right now.
Flexible input formats
Full addresses, landmarks, postcodes or latitude and longitude all work, and you can mix them in one list.
Worldwide coverage
Any location Google Maps knows. Route availability varies by region and mode, especially transit and cycling where local data can be thin.
Online tool or Excel workbook?
Use this page for a quick batch. Use the Excel tool when the list is long or the routes are part of a spreadsheet you already keep.
| This page, free | Excel Distance Calculator | |
|---|---|---|
| Routes at once | 25 | No row limit |
| Runs a day | 3 | As many as your Google quota allows |
| Where it runs | This page | Inside your own workbook |
| Getting routes in | Type, paste, or import a file | They are already in the sheet |
| Travel modes | Drive, walk, cycle, transit | The same four |
| Google key | Not needed | Your own, 10,000 free lookups a month |
| Price | Free, no sign-up | $49 once |
$49 once. Lifetime updates.
Frequently asked questions
The questions that come up most often.
Yes. No account, no sign-up, no card. You get 3 calculations a day, each covering up to 25 routes.
Up to 25 origin and destination pairs in one run. For more than that, the Excel Distance Calculator handles thousands using your own Google key.
CSV and XLSX. The file needs an origin column and a destination column. You can add a mode column to set the travel mode per row: drive, walk, bicycle or transit. The Blank template button gives you a file already in the right shape.
The Google Routes API, the same routing data behind Google Maps. That is why the distances follow real roads instead of measuring in a straight line.
Yes. Pick the mode before you calculate. Driving is the default, and walking, cycling and transit are one click away. In an imported file you can set a different mode for every row.
Yes. Write them as 52.5200, 13.4050 and they work like any other location. You can mix coordinates and addresses in the same list.
It swaps the typical travel time for one based on what the roads are doing right now. Useful when the answer matters today, less so when you are planning ahead. It applies to driving only.
Not on its own. You would need a custom Apps Script and your own Google API key. This page does 25 routes at a time with no scripting. For a spreadsheet workflow, the Excel Distance Calculator does it inside the workbook.
Excel has no built-in function for driving distances. The Excel Distance Calculator is a ready-made workbook that connects Excel to Google's routing data, so thousands of address pairs can be calculated in the sheet. This page is the quicker option for a small batch.
The Excel Distance Calculator uses your own Google key, so there is no row limit. Google gives 10,000 lookups a month free, and charges beyond that.
Calculate routes in bulk, inside Excel
$49 once, lifetime updates, and no row limit.
Get the Excel toolUses your own Google Maps key, 10,000 free lookups a month.
Google, Google Maps and Excel are trademarks of Google LLC and Microsoft Corporation. This site and its tools are not affiliated with or endorsed by either.
