Mileage log for Google Sheets
Your calendar already knows where you drove.
Calendar Mapper reads your Google Calendar appointments, measures the driving distance between every stop on Google Maps, and writes the mileage log into Google Sheets. Pick a date range, click Import, done.
Install from Google Workspace Marketplace
7-day free trial. Then $18 per year.
“I used to spend an hour every month reconstructing where I’d driven. Now I just run Calendar Mapper and I’m done in two minutes.” — Sarah M., Independent Consultant
Reconstructing a mileage log is the worst hour of the month
You remember the clients. You don’t remember the order you saw them in, or the miles between them. Most people rebuild the log from the calendar anyway, opening Maps once per stop. Calendar Mapper does that loop for you, for as many days as you pick.
How It Works
📍 1. Say where you start. Enter your home or base address once. Choose whether each day’s first drive starts at home, at the first appointment, or at a custom address, and where the last drive ends.
📅 2. Pick calendars and dates. Choose one or more of your calendars and a date range, from one day to a full year. Appointment addresses come from each event’s Location field.
📄 3. Import. Each stop gets a row with the driving miles from the one before it, a subtotal for every day and a total for the whole period.
What you get in the sheet
- Real road miles. Distances come from Google Maps driving routes, not straight-line estimates. Choose miles or kilometers, and add a travel-time column if you want it.
- The paper trail stays with the number. Each row carries the event title, start and end time, description and location, so the reason for the drive is already written next to it.
- Daily subtotals and a period total. The total is flagged if any trip could not be measured, so a missing stop never hides inside a number that looks complete.
- Appointments without an address stay visible. A video call is listed with no mileage, so the log still matches your calendar and you can see what was left out.
- Commute deduction. Enter your normal commute once and it is subtracted from the first and last drive of each day. Reported as a negative number, so a SUM gives the net.
- A Trips tab for reports. The same data as one flat row per drive, with date, weekday, month, drive type, origin, destination and miles. Build a pivot table by month or client without touching the log.
Set it once and let it update
Turn on Auto-Update and the sheet refreshes every day, or every hour, on a rolling window such as “the last 30 days.” You can also trim the view with a Detail Level: Full, Compact, Minimal, or Drives only.
Guides
- How to make a mileage log from Google Calendar, by hand or with Calendar Mapper
- What a mileage log needs to include, with the 2026 IRS rates
- How to total mileage by month and client with a pivot table
Who It’s For
Anyone who schedules visits in Google Calendar and drives to them: real estate agents, outside sales reps, home health and social workers, field technicians, consultants and attorneys, and anyone who reports mileage to an employer or to the IRS on Schedule C.
Calendar Mapper measures distance and keeps the supporting details in one place. What qualifies as deductible business mileage is up to you and your tax adviser.
How It Compares
| Feature | TripTally | Travel Formulas | Calendar Mapper |
|---|---|---|---|
| Primary Goal | List Processing | Custom Formulas | Mileage Logs from Calendar |
| Best For… | Mileage Logs & A-to-B Trips | Dashboards & Power Users | Appointment-based Drivers |
| Starting Point | Manual address entry | Manual address entry | Your Google Calendar |
| IRS Deduction | Manual calculation | Manual calculation | Commute deduction built in |
| Action | View | View | Install |
Pricing
Start your free 7-day trial. Then pick the plan that fits.
Use your Google account’s email address at checkout so your license activates correctly.
- One person pays. Everyone else is added by email, with nothing for them to buy.
- The price is flat for the whole band, and you count as one of the seats.
- Billed annually.
Video Tutorials
FAQ
Does Calendar Mapper work with more than one calendar?
Yes. Pick one or several calendars for each import, which suits separate calendars for different clients or business lines.
What if an appointment has no address?
It is listed with “No Location” and no mileage, so the log still matches your calendar and you can see what was skipped. Add the address to the calendar event and import again.
Can it leave out my commute?
Yes. Enter your one-way commute distance in the add-on’s User Settings and it is deducted from each day’s first and last drive, shown as negative rows you can see.
How does it decide where each drive starts?
The first drive of the day starts from Home, the first event or a custom address, your choice in Trip Logistics. Every later drive starts from the previous appointment. Two checkboxes send you home between events, or home at the end of each day.
Does it count toward my Google Maps quota?
Yes. Calendar Mapper uses the Google Maps API, which has daily limits that depend on your account type. Most people logging a month of visits stay well inside them. If a day’s limit is reached, the total says how many trips are missing, and running the import again the next day fills them in.
Can I add up my miles by month or client?
Yes, use the Trips tab. It has one row per drive with month, origin and destination in their own columns, so SUMIFS or a pivot table does it. Don’t delete rows from the mileage log itself, because its subtotals and total are written as numbers. The Trips tab is rewritten on every import, so keep your own formulas on a separate tab that points at it.
Does it work for my team?
Yes. One person buys a Small Team (2 to 5 people) or Team (6 to 20 people) plan and adds everyone else by email. Nobody else has to buy anything.
How do I manage or cancel my subscription?
Use the Subscriber Portal to update billing or cancel at any time.
Subscriber Portal | Terms of Service | Privacy Policy | Contact