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.
Stop switching between Google Sheets™ and Google Maps™. Process hundreds or thousands of addresses instantly with custom formulas that calculate drive times, distances, routes, and turn-by-turn directions automatically.

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 Sheets

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:
=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
	•	$57 lifetime license – One-time payment, use forever (save $111+ vs. 3 years of monthly)

Volume Discounts Available:
	•	2-10 users: $3/month or $37 lifetime
	•	11-50 users: $2/month or $22 lifetime
	•	51-200 users: $0.50/month or $12 lifetime
	•	201+ users: $0.25/month or $7 lifetime
               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.