Calculate drive time, distance, and mileage between addresses right inside Google Sheets™ — with formulas like TRAVELDISTANCE and TRAVELTIME.
Listing updated:August 27, 2026
Works with:
15K+
Overview
Stop switching between Google Sheets™ and Google Maps™. Process hundreds or thousands of addresses instantly with custom formulas that calculate drive times, distances, routes, tolls, and turn-by-turn directions automatically.

Start Your Free 7-Day Trial – No credit card required.

Calculate mileage reimbursements, plan delivery routes, and track travel expenses directly in Google Sheets™. Travel Formulas eliminates manual distance lookups by bringing Google Maps™ data into your spreadsheet—saving hours of work on address-based calculations.

Save Time & Eliminate Manual Work
✓ Process 1,000+ addresses in minutes instead of hours of manual lookups
✓ Calculate mileage reimbursements instantly for expense reports
✓ Optimize delivery routes and service call scheduling automatically
✓ No more copying and pasting between Google Maps™ and Google Sheets™

Join 1,000s of users who save hours every month.

Five Powerful Custom Formulas

TRAVELTIME – Calculate drive times between locations instantly. Perfect for scheduling meetings, planning service calls, or estimating delivery times across multiple stops.

TRAVELDISTANCE – Find distances between any two addresses in miles or kilometers. Essential for mileage reimbursement calculations, delivery route planning, and travel expense tracking.

TRAVELROUTEURL – Generate direct Google Maps™ links for any route. Share navigation links with your team, customers, or drivers with a single formula.

TRAVELDIRECTIONS – Get complete turn-by-turn directions in your spreadsheet. Create printable route sheets, delivery instructions, or navigation guides without leaving Google Sheets™.

TRAVELTOLLS – Estimate toll costs for a driving route. Budget delivery runs, quote jobs accurately, or compare toll and toll-free options before you commit.

Perfect For
✓ Accountants & Finance Teams – Process monthly mileage reports and employee reimbursements in minutes
✓ Logistics & Delivery – Plan multi-stop routes, calculate delivery times, and optimize driver schedules
✓ Sales Teams – Track quarterly travel expenses and plan efficient territory coverage
✓ Property Managers – Calculate service call distances and optimize maintenance routes
✓ Field Service – Schedule technician visits and estimate travel times between appointments
✓ Real Estate Professionals – Calculate distances to amenities, schools, and points of interest for property listings

How It Works
Simply use the custom formulas like any other Google Sheets™ function. Travel Formulas integrates seamlessly with your existing spreadsheets:

Example formulas:
=TRAVELDISTANCE("123 Main St, Boston MA", "456 Oak Ave, Cambridge MA")
=TRAVELTIME("New York, NY", "Philadelphia, PA", "driving", "1/1/2027 3:00PM")
=TRAVELROUTEURL(A2, B2)
=TRAVELDIRECTIONS(A2, B2)

All formulas support multiple location formats:
• Street addresses
• Latitude/Longitude coordinates
• City/State/Country
• Points of interest
• Airports
• Plus Codes
• Place Chips

Advanced Features
Use paid API formulas to:
• Exceed the standard daily Google Maps™ quotas
• Avoid tolls, highways, ferries, or indoor routing
• Calculate toll costs for a route with TRAVELTOLLS_API
• Process thousands of additional addresses daily

Pricing & Trial
Start Your Free 7-Day Trial – No credit card required. After your trial, choose the plan that works best:
• $4/month – Pay as you go with monthly billing
• $44/year – Annual plan, saving $4 a year

Volume Discounts Available:
• 2-10 users: $3/month or $28/year
• 11-50 users: $2/month or $14/year
• 51-200 users: $0.50/month or $7/year
• 201+ users: $0.25/month or $4/year
Contact us before checkout to apply volume pricing.

FAQ

What are the usage limits?
Travel Formulas operates within Google's daily quotas for all add-ons and apps. These quotas allow 1,000-10,000 direction requests per day (depending on your Google account type) and standard run-time limits. The limits are the same for free trial and paid versions. High-volume users can purchase additional daily direction requests to access our paid API formulas that exceed Google's standard quotas. You can minimize recalculations by setting your spreadsheet to "On change" calculation mode (File > Settings > Calculation tab) and pasting formula results as values when final.

Does Travel Formulas work with Place Chips?
Yes! Any address that Google Maps™ recognizes works in Travel Formulas, including Place Chips. The chip's formatting does not impact address validity.

What location formats are supported?
If Google Maps™ can interpret the location, it works in Travel Formulas:
• Street addresses
• Latitude/Longitude coordinates (will snap to nearest road)
• Plus Codes
• City/Country/Political boundaries
• Points of interest (restaurants, hotels, landmarks)
• Airports
• Parks and public spaces

How do I convert time output to a number for calculations?
TRAVELTIME returns text-formatted output. To use the result in other formulas, wrap it with the VALUE() function: =VALUE(TRAVELTIME(A2, B2))

What if I get a #NAME? error?
Cause 1: Google Sheets™ doesn't recognize the custom formula. Go to Extensions > Travel Formulas > Activate / Refresh License. You only need to do this once per Google account — it covers every sheet you own, not just the one you are in — and since the August 2026 update it happens automatically when you install.
Cause 2: You're using a spreadsheet created by another user who has Travel Formulas, but you haven't installed it yourself. Install the add-on or have the owner paste formula results as values.

Can I share spreadsheets with Travel Formulas?
Yes! Spreadsheets work best when you're the owner. If sharing with others who don't have Travel Formulas installed, paste formula results as values before sharing, or have them install the add-on themselves.

How do I cancel my subscription?
Open Extensions > Travel Formulas > Manage Subscription / Cancel in any Google Sheet™, or go straight to the subscriber portal below. Sign in with the same email address you subscribed with — Stripe sends a one-time sign-in link, there is no password. From the portal you can update your card, switch between monthly and annual, download invoices, or cancel. Cancelling stops future charges; the add-on keeps working until the end of the period you've already paid for.

Support & Resources
• Video tutorials and documentation at sheetshelp.com/travel-formulas
• Email support: contact via adam@sheetshelp.com
• Subscriber portal for license management https://billing.stripe.com/p/login/eVa8xEf1t4OHbYY288

Try Travel Formulas free for 7 days and see how much time you can save on distance calculations.
Start Your Free 7-Day Trial – No credit card required.

Calculate mileage reimbursements, plan delivery routes, and track travel expenses directly in Google Sheets™. Travel Formulas eliminates manual distance lookups by bringing Google Maps™ data into your spreadsheet—saving hours of work on address-based calculations.

Save Time & Eliminate Manual Work
✓ Process 1,000+ addresses in minutes instead of hours of manual lookups
✓ Calculate mileage reimbursements instantly for expense reports
✓ Optimize delivery routes and service call scheduling automatically
✓ No more copying and pasting between Google Maps™ and Google Sheets™

Join 1,000s of users who save hours every month.

Four Powerful Custom Formulas
TRAVELTIME – Calculate drive times between locations instantly. Perfect for scheduling meetings, planning service calls, or estimating delivery times across multiple stops.
TRAVELDISTANCE – Find distances between any two addresses in miles or kilometers. Essential for mileage reimbursement calculations, delivery route planning, and travel expense tracking.
TRAVELROUTEURL – Generate direct Google Maps™ links for any route. Share navigation links with your team, customers, or drivers with a single formula.
TRAVELDIRECTIONS – Get complete turn-by-turn directions in your spreadsheet. Create printable route sheets, delivery instructions, or navigation guides without leaving Sheets.

Perfect For
✓ Accountants & Finance Teams – Process monthly mileage reports and employee reimbursements in minutes

✓ Logistics & Delivery – Plan multi-stop routes, calculate delivery times, and optimize driver schedules

✓ Sales Teams – Track quarterly travel expenses and plan efficient territory coverage

✓ Property Managers – Calculate service call distances and optimize maintenance routes

✓ Field Service – Schedule technician visits and estimate travel times between appointments

✓ Real Estate Professionals – Calculate distances to amenities, schools, and points of interest for property listings

How It Works
Simply use the custom formulas like any other Google Sheets™ function. Travel Formulas integrates seamlessly with your existing spreadsheets:
Example formulas:
=TRAVELDISTANCE("123 Main St, Boston MA", "456 Oak Ave, Cambridge MA")
=TRAVELTIME("New York, NY", "Philadelphia, PA", "driving”, ”3 PM”)
=TRAVELROUTEURL(A2, B2)
=TRAVELDIRECTIONS(A2, B2)

All formulas support multiple location formats:
	•	Street addresses
	•	Latitude/Longitude coordinates
	•	City/State/Country
	•	Points of interest
	•	Airports
	•	Plus Codes
	•	Place Chips
		
Advanced Features
Use paid API formulas to:
	•	Exceed Google's standard daily quotas for high-volume users
	•	Avoid tolls, highways, ferries, or indoor routing
	•	Calculate routes with custom constraints
	•	Process thousands of additional addresses daily

Pricing & Trial
Start Your Free 7-Day Trial – No credit card required.
After your trial, choose the plan that works best:
	•	$4/month – Pay as you go with monthly billing
	•	$44/year – Annual plan (save $12 vs. three years of monthly)

Volume Discounts Available:
	•	2-10 users: $3/month or $28/year
	•	11-50 users: $2/month or $14/year
	•	51-200 users: $0.50/month or $12/year
	•	201+ users: $0.25/month or $7/year
               Contact us before checkout to apply volume pricing.

FAQ

What are the usage limits?
Travel Formulas operates within Google's daily quotas for all add-ons and apps. These quotas allow 1,000-10,000 direction requests per day (depending on your Google account type) and standard run-time limits.
The limits are the same for free trial and paid versions. High-volume users can purchase additional daily direction requests to access our paid API formulas that exceed Google's standard quotas.
You can minimize recalculations by setting your spreadsheet to "On change" calculation mode (File > Settings > Calculation tab) and pasting formula results as values when final.

Does Travel Formulas work with Place Chips?
Yes! Any address that Google Maps™ recognizes works in Travel Formulas, including Place Chips. The chip's formatting does not impact address validity.

What location formats are supported?
If Google Maps™ can interpret the location, it works in Travel Formulas:
	•	Street addresses
	•	Latitude/Longitude coordinates (will snap to nearest road)
	•	Plus Codes
	•	City/Country/Political boundaries
	•	Points of interest (restaurants, hotels, landmarks)
	•	Airports
	•	Parks and public spaces

How do I convert time output to a number for calculations?
TRAVELTIME returns text-formatted output. To use the result in other formulas, wrap it with the VALUE() function: =VALUE(TRAVELTIME(A2, B2))

What if I get a #NAME? error?
Cause 1: Google Sheets™ doesn't recognize the custom formula. Go to Extensions > Travel Formulas > Enable in workbook.
Cause 2: You're using a spreadsheet created by another user who has Travel Formulas, but you haven't installed it yourself. Install the add-on or have the owner paste formula results as values.

Can I share spreadsheets with Travel Formulas?
Yes! Spreadsheets work best when you're the owner. If sharing with others who don't have Travel Formulas installed, paste formula results as values before sharing, or have them install the add-on themselves.

Support & Resources
	•	Video tutorials and documentation at sheetshelp.com/travel-formulas
	•	Email support: contact via adam@sheetshelp.com
	•	Subscriber portal for license management     
                https://billing.stripe.com/p/login/eVa8xEf1t4OHbYY288

Try Travel Formulas free for 7 days and see how much time you can save on distance calculations.
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
Travel Formulas will ask for the permissions shown below. Learn more
Travel Formulas will need access to your Google account
This will allow Travel Formulas to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Gerard Fennessy
August 22, 2026
This is an excellent extension, and well worth the subscription. We (wife and 3 kids) are doing a 3 month driving trip around Europe and this has enabled us to plan our journeys between cities to make sure the distances and more importantly the driving times are doable. Using conditional formatting it highlights journeys that are under 2 hours, between 2-3 hours and >4 hours - and this enables us easily to see which cities are driveable in a day, (so we can be prepared for longer journeys if needed) or whether we are too ambitious and need to change one of our destinations or leave a bit more time between trips. We can make changes on the fly and the spreadsheet updates the distance and times automatically. The best thing is that it uses real routes and so you know the distances are accurate. I also mistakenly purchased an option (extra searches instead of a subscription) and the author was responsive and immediately refunded my error and sorted me out the subscription instead. Thanks Adam! I'd be surprised if MS didn't offer you a job with XL.
Is this review helpful?
Yes
No
Profile Picture
Alyssa Vo
August 28, 2026
This is a really cool extension. It's really amazing to see everything calculated. I was making a travel sheet for my friends and family and to see the distance between all of us so we could easily find something that is either closer or of equal distance to us is amazing.
Is this review helpful?
Yes
No
Profile Picture
Geoff Nesnow
May 15, 2026
Adam helped me use his tool for a large use case in my business. He was fantastic. Once he explained what I was doing wrong, the tool worked extremely well. I'm very impressed, especially for a very inexpensive tool like this.
Is this review helpful?
Yes
No
Profile Picture
Liz Butler
February 13, 2026
Saves me so much time from manually calculating mileage! Fairly user friendly, especially if you understand spreasheets/formulas/extensions.
Is this review helpful?
Yes
No
Profile Picture
Yvonne Fronczak
January 23, 2026
I found exactly what I needed with this add-on! No other add-on, extension or app gave me the miles flown without providing more precise addresses, so it was refreshing that this could do what I asked! I'm sure there is even more this add-on can do, but this is all I needed for now. Can't wait to explore more!
Is this review helpful?
Yes
No
Profile Picture
Lance Sloan
October 14, 2025
This add on is great for quickly calculating distance and time between locations. I use it in a rate calculator I built to see if a route is profitable and I love it. Great job Adam!
Is this review helpful?
Yes
No
Profile Picture
Adam Tucker
February 20, 2025
I was hesitant, but now am super glad I purchased the lifetime paid license. I am using this as part of an integration that otherwise would have cost much in time and other resources to automate some tasks involved with having my office staff call clients and schedule installations. Super valuable. And great support as well. I sent an email asking to change my license to a differnent email address than what I used to purchase the license and it was done within the hour. Great Company!
Is this review helpful?
Yes
No
Profile Picture
Lauren Bainbridge
August 28, 2025
I use this add-on to calculate my mileage, and it's far cheaper than any app I've found. It's also way more convenient than doing it myself! I haven't used it for too long, but I haven't had any issues so far!
Is this review helpful?
Yes
No
Profile Picture
geoff nesnow
May 15, 2026
Excellent product. Great support. I’m using it help with pricing and routing for a logistics business.
Is this review helpful?
Yes
No
Profile Picture
Jersey Connor
January 17, 2026
We're preparing to move, and using this to calculate the potential commuting times has been extremely useful! This is an extremely easy extension to use, and makes work even easier!
Is this review helpful?
Yes
No
1-10 of 23
Search
Clear search
Close search
Google apps
Main menu