Excel Drive Time Calculator
Bulk driving time in Excel — powered by the Google Maps API. Paste addresses, click Calculate, get accurate drive-time numbers for up to 40,000 lookups per month at Google's free tier.
How it works
One click. Real drive times. Google Maps behind the scenes.
You paste your list of Origin and Destination addresses into columns A and B of Excel Drive Time Calculator. You click the Calculate button. The tool sends the addresses to the Google Maps API, receives back the drive time in minutes for every pair, and fills the results into your spreadsheet. No macros to write, no add-ins to install, no formulas to configure. Your data stays in your file. Your Google API key stays in your Google account.
See it in action
Three steps. Under a minute. Real screen recordings from the tool.
Paste your data into Excel
Drop your Origin and Destination addresses into columns A and B. That's it — no formulas, no macros to configure.
Click the “Calculate” button
One click sends every address pair to the Google Maps API. Your data stays in your file. Your API key stays in your Google account.
Watch drive times fill in — live
Real drive time in minutes for every pair, filled into your spreadsheet automatically. Powered by real Google Maps routing — the same numbers your drivers see in the app.
Who it's for
Built for teams that already run their day out of a spreadsheet — and just need Excel to know how long the drive actually takes.
Dispatchers & schedulers
Optimize a full day's stops in seconds. Get drive time, distance, and Google Maps view per leg — right in the spreadsheet you already use.
Field service teams
Bulk driving time lookups for hundreds of addresses. Pull it into Excel, share the result, done.
Ops & business analysts
Automate what used to be one Google Maps tab at a time. Batch process 40,000 free calculations per month.
What's inside
Everything you need to calculate real drive times at scale — nothing you'll never use.
What you get
- The Route Optimizer in Excel workbook (.xlsm)
- Written setup guide (PDF)
- Video walkthrough of a full run
- Free 1-on-1 Zoom call to set up your Google API key
- Email support from the builder
- Every future update to Route Optimizer in Excel
Requirements
- Microsoft Excel 365 (Windows or Mac)
- A free Google Cloud account with Maps APIs enabled
- A Google Maps API key (we walk you through it)
- Basic Excel comfort — paste, click, save
- No coding, no VBA, no add-ins required
Ready to stop tabbing between Google Maps and Excel?
One-time · Instant download · Free setup call included
Frequently asked questions
Real answers to the questions people ask before they buy.
Do I need a Google Maps API key?
Yes — but setup takes 5 minutes and we walk you through it on the free Zoom call. Google gives you 40,000 free calculations per month, which covers most users forever.
How many addresses can I calculate at once?
There's no hard limit on the tool itself — the constraint is your Google Maps API quota. Most users on Google's free tier process 40,000 calculations per month with no charge.
Does it work on Mac?
Yes — the tool works on Excel for Windows and Excel for Mac (2016 and newer). You just need macros enabled.
What if I get stuck setting it up?
Every order includes a free 30-minute Zoom setup call. We share your screen and get you calculating within the first 10 minutes. Available Mon–Fri.
Is this a subscription?
No. One-time purchase. You own the file. No monthly fees, no renewals, no seat charges.
Can I use it for multiple users in my team?
Buy the Multi-User license ($187) — everyone in your team can install and use it. Single-User ($97) is for one workstation.
What customers say
Real customers using this tool in the field. Read more on our Google Business profile.
158+ Google reviews for ExcelDistanceCalculators.com — from customers across trucking, courier, real estate, construction, and public safety.
“I came across Vinnie's YouTube video and option to purchase his workbook. Vinnie reached out directly via Zoom to assist me with the API setup in order to begin calculating over 15,000 distances. Impressed with his work and, more so, his level of service during a time-sensitive project. Would highly recommend and will keep Vinnie's contact on hand for future projects.”
“We needed a quick and easy way to calculate distances for our construction crews from their home to their jobsites — 100+ people on a weekly basis. It was important to find something cost effective that wouldn't take hours each week. This tool has been amazing. Setup was super simple, our weekly reporting takes only a few minutes, and we have all the information we need.”
“Vinnie went above and beyond to help me set up the Google API for an Excel program so that I could get out a Mileage Report for the Center Hill Fire Protection District firefighters for their annual reports. Will gladly recommend his service to anyone that asks.”
You might also like
Other Excel tools our customers reach for.
