Travel Formulas for Google Sheets™
Driving distance and time,
right in your spreadsheet.
Build mileage logs, plan visits and create Google Maps™ route links with simple formulas. Use the addresses already in your sheet and skip the repeated manual lookups.
No credit card required. $45/year after the trial.
“Your tool lets me to wrap up my IRS mileage calculations in a few days rather a couple weeks each year.”
— David F.
“Fantastic Add on which will save so much time flicking between Maps and Sheets. I love that it is a formula based function so you can incorporate it within other strings.”
— Christian F.
Put travel data to work in your sheet
Mileage reports: calculate trip distances, then multiply by your own reimbursement rate using a spreadsheet formula.
Visit planning: keep estimated drive times beside each origin and destination. Compare future departure times when you need traffic-aware driving estimates.
Route links: create a Google Maps™ link for each trip, ready to open or share.
Travel Formulas works with origin–destination pairs inside your own spreadsheet. For automatically ordering multiple stops, see RouteTally. If your drives are appointments in Google Calendar, Calendar Mapper builds the mileage log from your calendar instead.
Start with two location cells
Put an origin in A2 and a destination in B2. Enter =TRAVELDISTANCE(A2,B2) for driving distance in miles, or =TRAVELTIME(A2,B2) for drive time. Fill the formula down your list. Daily quotas and execution limits apply.
Custom Formulas
Use the standard formulas for distance, time, route links and directions. Toll estimates use the separately metered TRAVELTOLLS_API formula.
TRAVELTIME – Returns the trip duration between two locations
TRAVELDISTANCE – Finds the trip distance between two locations
TRAVELROUTEURL – Returns a link to your route in Google Maps™
TRAVELDIRECTIONS – Provides turn-by-turn directions
TRAVELTOLLS_API – Estimates the toll cost for a driving route using purchased route credits
Need more route capacity or toll estimates? Paid API formulas use separately purchased route credits. These credits are not included in the annual subscription.
TRAVELTIME Formula
Returns the trip duration between two locations.
=TRAVELTIME(origin, destination, mode, departure_time)
origin – The starting location
destination – The ending location
mode – The mode of travel (“driving”, “walking”, “bicycling”, “transit”) [optional, defaults to driving]
departure_time – A datetime in the FUTURE for transit/driving in traffic. Best to use a cell reference formatted as a datetime [optional].
avoid – [Available only in the paid TRAVELTIME_API formula.] Features to avoid: 0-None, 1–Tolls, 2–Highways, 3–Ferries, 4–Indoors [optional, defaults to 0]
Compare departure times: put future date/time values in cells and reference them with =TRAVELTIME(A2,B2,"driving",D2). Compare the returned durations to help choose when to leave. See the departure-time walkthrough.
TRAVELDISTANCE Formula
Returns the driving distance between two addresses, or the walking, bicycling or transit distance in another mode. For a walkthrough, see how to find the driving distance between two addresses in Google Sheets.
=TRAVELDISTANCE(origin, destination, mode, unit)
origin – The starting location
destination – The ending location
mode – The mode of travel (“driving”, “walking”, “bicycling”, “transit”) [optional, defaults to driving]
unit – The unit of distance (“mi”, “km”) [optional, defaults to miles]
avoid – [Available only in the paid TRAVELDISTANCE_API formula.] Features to avoid: 0-None, 1–Tolls, 2–Highways, 3–Ferries, 4–Indoors [optional, defaults to 0]
TRAVELROUTEURL Formula
Returns the link to the route in Google Maps™.
=TRAVELROUTEURL(origin, destination, mode)
origin – The starting location
destination – The ending location
mode – The mode of travel (“driving”, “walking”, “bicycling”, “transit”) [optional, defaults to driving]
TRAVELDIRECTIONS Formula
Returns turn-by-turn directions.
=TRAVELDIRECTIONS(origin, destination, unit, mode, departure_time)
origin – The starting location
destination – The ending location
unit – The unit of distance (“mi”, “km”) [optional, defaults to miles]
mode – The mode of travel (“driving”, “walking”, “bicycling”, “transit”) [optional, defaults to driving]
departure_time – A datetime in the future for transit/driving in traffic. It is best to use a cell reference formatted to a datetime [optional, defaults to present time]
TRAVELTOLLS_API Formula
Returns the estimated toll cost for a driving route.
=TRAVELTOLLS_API(origin, destination)
origin – The starting location
destination – The ending location
Returns the toll estimate with its currency, for example USD 3.40, or NO_TOLLS when the route has none. This is a paid formula and uses one of your purchased routes per calculation.
Location Formats
If Google MapsTM can interpret the locations, they will work in this add-on. Accepted location identifiers include:
- Latitude / Longitude
- Will snap to the nearest road
- Street address
- Plus Code
- City / Country / Other political boundary
- Point of interest
- Airport
- Park
Which Mapping Tool Should You Choose?
| Feature | Route Matrix | TripTally | RouteTally | Travel Formulas |
|---|---|---|---|---|
| Primary Goal | Batch Comparison | List Processing | Multi-Stop Optimization | Custom Functions |
| Best For… | Hub/Warehouse Selection | Mileage Logs & A-to-B Trips | Delivery & Field Sales Routes | Dashboards & Power Users |
| The “Magic” | Compares every Start to every End | Calculates 1,000+ pairs instantly | Sequences stops for shortest path | Direct cell-level integration |
| Visual Output | 2D Grid (Matrix) | Parallel Data Columns | Sequenced Itinerary | Single Cell Values |
| Action | View | View | View | View |
Video Tutorials
Pricing
Start Your Free 7-Day Trial. After the free trial, Travel Formulas is $45 per year. No credit card is required for the trial. Paid API route credits, including toll calculations, are purchased separately. Use the email address of the Google account you use with the add-on.
Multiple User Pricing
We offer the following discounts for multiple users in the same organization. Contact us before you checkout.
| Quantity | Annual price per user |
|---|---|
| 2 – 10 | $28 |
| 11 – 50 | $14 |
| 51 – 200 | $7 |
| 201 + | $4 |
Just need a finished list? Travel Formulas is built for live formulas in your own sheet — they recalculate as you work, which is what you want in a working spreadsheet and a nuisance for a one-off batch. When you have a few thousand addresses sitting in a CSV or Excel file, or a list to paste, TripTally Plus is our web app that works through the lot in one pass and hands back a finished table. No subscription, and the first 100 routes are free.
FAQ
What are the usage limits?
Travel Formulas operates within Google’s daily quotas on all add-ons and apps. These quotas limit the app to 1,000 or 10,000 direction requests per day (depending on the type of Google account) and an overall daily run time. You can purchase additional daily direction requests if you are a high-volume add-on user which allow you to use the formulas that exceed Google quotas.
The standard mapping quotas are the same during the trial and the annual subscription. If you use TripTally, both add-ons count toward the same quota.
You can reduce automatic recalculations by going to the File menu, then Settings, choosing the Calculation tab, and ensuring it is set to “On change.” Also, copy the results of the formulas and paste them as values. This ensures they won’t recalculate.
Need to process thousands of addresses at once? TripTallyPlus is a standalone web app designed for high-volume distance calculations without Google Sheets add-on limitations.
Does Travel Formulas work with Place Chips?
Yes, any address that Google Maps™ recognizes will work in the add-on. The chip’s formatting does not impact the validity of an address.
How do I convert the time output to a number?
TRAVELTIME returns HH:MM text. Use =VALUE(TRAVELTIME(A2,B2)) to convert it to a spreadsheet time value (a fraction of a day). Multiply that value by 24 for hours or 1440 for minutes. Learn more about VALUE.
How do I prevent the #NAME? Error and “Loading….”?
Cause #1 – Google Sheets does not recognize your custom travel formula. Open the Extensions menu, choose Travel Formulas, then Activate / Refresh License. You only need to do this once per Google account — activation covers every sheet you own, not just the one you are in. Since the August 2026 update it also happens automatically when you install the add-on.
Cause # 2 – You are using a spreadsheet created with Travel Formulas by another user, but you don’t have the add-on installed.
Solution # 1: Copy and paste the output from your Travel Formulas as values. This will prevent any future recalculation.
Solution # 2: Use TripTally for one-time calculations instead of live formulas.
The formulas keep asking me to activate the add-on
Travel Formulas re‑checks your licence about once a week. If a formula asks you to activate, open Extensions → Travel Formulas → Activate / Refresh License, then force the formula to recalculate by editing the cell and undoing the edit.
If it still asks after that, it usually means the add‑on cannot tell which Google account you are: you are signed in to more than one Google account (sign out of the others and restart your browser), or you are not the owner of the sheet. Travel Formulas performs best when you own the sheet — try it in a new sheet you create yourself.
How do I solve the Permission Denied error code?
The error message “We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED.” occurs when a user is logged into multiple Google accounts. Log out of all other Google accounts, restart your browser, and start the add-on again.
How do I cancel my subscription?
Open Extensions → Travel Formulas → Manage Subscription / Cancel in any Google Sheet, or go straight to the subscriber portal. Sign in with the same email address you subscribed with — Stripe sends you a one‑time sign‑in link, there is no password.
From the portal you can update your card, download invoices, or cancel. Cancelling stops future charges; the add‑on keeps working until the end of the period you have already paid for.
Does Travel Formulas Work in Excel?
Travel Formulas does not work in Excel. For Excel routing, try our partner app, RouteMetrics.
Subscriber Portal | Terms of Service | Privacy Policy | Contact