Contents
Automate Mileage & Distance in Google Sheets™
Stop manual address lookups. Calculate 1,000+ travel distances, times, and routes instantly using the power of Google Maps™ directly inside your spreadsheet. This Google Sheets distance calculator pulls distances directly from Google Maps — no copying, no pasting.
“Great add-on! TripTally saved me what would become over time, thousands of hours of work.”
– Andrew R., Logistics Coordinator
This tool is amazing and so cheap. Perfect for the tax season. Staff is very quick to respond and helpful! Highly recommended!
-Subarno R., Contractor
Why Choose TripTally?
IRS-Ready Logs
Generate accurate mileage logs for tax deductions or employer reimbursements in seconds.
Bulk Processing
Handle lists of 1,000+ address pairs at once. Perfect for fleet management and delivery routes.
Predictive Traffic
Specify future departure dates to get estimated travel times based on historical traffic loads.
From Addresses to Mileage in 3 Steps
- Input Locations: Enter your start and end addresses (or Lat/Long) in two columns.
- Choose Your Mode: Select Driving, Walking, Bicycling, or Transit.
- Click Run: TripTally populates your sheet with distance, time, and Map links.
No credit card required. Install in seconds.
Custom Travel Route Options
- Calculate distances in miles or kilometers.
- Use different transportation modes.
- Driving, biking, transit, etc.
- Provide a link to the directions in Google MapsTM.
- Specify a departure day and time.
- Create mileage logs for IRS deductions or employer reimbursement.
TripTally fetches starting and ending locations from your Google Sheet, and you tell it what to return – mileage, time, or a link to the directions on Google MapsTM. Our app sends the locations confidentially to Google MapsTM and returns the calculated data to your spreadsheet. Use a custom departure date and time to predict travel time based on expected traffic loads.
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
Try TripTally FREE for 7 days. Then choose the plan that fits your needs.
Be sure to use your Google account’s email address during checkout to ensure your license activates correctly.
High Volume? Processing thousands of addresses? Check out TripTallyPlus.
Team Discounts: We offer volume pricing for 2+ users. Contact us for a quote.
Please use your Google account’s email address during checkout to ensure your license activates correctly.
FAQ
How many routes can TripTally process?
TripTally 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 free route requests per day (depending on the type of Google account), and an overall daily run time.
You can purchase more daily route requests to increase the daily limit.
The limits are the same in the free and paid versions of TripTally. If you use Travel Formulas or Route Matrix, these add-ons share the same Google Maps quota.
Need to process thousands of addresses? TripTallyPlus is a standalone web app designed for high-volume distance calculations. It bypasses Google Sheets add-on limitations, handling large datasets that would exceed the daily quotas of traditional add-ons.
Does TripTally work with Place Chips?
Yes, any locations that Google Maps recognizes will work in the TripTally. The chip’s formatting does not impact the validity of a location.
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 use the add-on with my iPad?
Open your Google Sheet in the Safari web browser instead of Chrome or the Sheets mobile app. If you still do not see the full version of Google Sheets, go to Settings, then Safari, and select Request desktop website. Toggle this setting to on.
Can TripTally calculate multi-stop routes?
No, TripTally works with address pairs. Use our RouteTally add-on for more than two stops per route.
Can I use TripTally for mileage tracking and tax deductions?
Yes. TripTally is commonly used to create mileage logs for IRS deductions and employer reimbursement. Simply list your trips with starting and ending addresses, run TripTally to calculate the mileage, and you’ll have a documented log in your spreadsheet.
Subscriber Portal | Terms of Service | Privacy Policy | Contact