Bring the power of Google Maps™ into your spreadsheets with the Travel Formulas Google Sheets™ add-on. You can access four exclusive formulas to calculate distances, times, and routes.
 
Pricing: Travel Formulas is free for seven days, then $4 per month or $57 for a lifetime license.


Four Custom Formulas

Calculate trip information without leaving your spreadsheet with these four custom formulas.

TRAVELTIME – Returns the trip duration between two locations

TRAVELDISTANCE – Finds the distance between two locations

TRAVELROUTEURL – Returns the link to your route in Google Maps™

TRAVELDIRECTIONS – Provides turn-by-turn directions


FAQ

How many addresses can TripTally process?

Travel Formulas functions per the daily quotas Google imposes on all add-ons and apps. This limits the app’s run time to 30 seconds per request, 1,000 or 10,000 direction requests per day (depending on the type of Google account), and an overall daily run-time. The limits are the same in Travel Formulas’ free and paid versions.

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.

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