Your calendar already knows where you drove. Let it write your mileage log.
SheetMiles is a Google Sheets add-on that reads the addresses on your Google Calendar events, calculates driving miles between stops, and writes a mileage log with date, destination, business purpose, miles and the IRS standard rate for each trip date.
Coming soon Free mileage log template
14-day free trial, no card needed. Then $39/year or $4.99/month.
How it works
1. Pick a calendar and a date range
Last month, this year, last year or any range. Events with a street address become stops; Zoom, Meet and phone events are skipped.
2. Set your base
Home or office. Choose how days work: base → stops → back to base, a round trip per appointment, or one-way chains.
3. Get the log
Each leg gets driving miles from Google Maps, a category (business, personal, commuting, charity, medical) and the IRS rate in force on that date.
4. Export or auto-email
Download PDF or CSV for your accountant, or get last month's log emailed to you on the 1st.
Built for people whose drives are appointments
Real estate agents, home-service pros, in-home tutors and trainers, consultants, field sales reps, and employees reimbursed per mile. If your work trips are on your calendar, you don't need a GPS app draining your battery.
What's in the log
| Date | Vehicle | Start | Destination | Business purpose | Category | Miles | IRS rate | Amount |
|---|---|---|---|---|---|---|---|---|
| 2026-06-30 | Car | Home | 1 Oak St, Worcester, MA | Client A showing | business | 10.0 | $0.725 | $7.25 |
| 2026-07-01 | Car | Home | 2 Elm St, Worcester, MA | Client B | business | 10.0 | $0.760 | $7.60 |
Example rows. The IRS business rate was 72.5¢/mile for Jan 1 – Jun 30, 2026 and is 76¢/mile from Jul 1, 2026 (IRS). SheetMiles applies the right one by trip date.
Features
Keyword tagging
Business and personal keyword lists, plus #business, #personal, #charity and #medical tags on any event.
Commuting flag
Optionally label home ↔ office legs as commuting so they're kept separate from business miles.
Multiple vehicles
Assign a vehicle by keyword, e.g. put [truck] in the event title.
Monthly & yearly summary
Business miles and amount by month and by vehicle, with space for start- and end-of-year odometer readings.
Edit, then export
Change any category on the sheet. Exports re-price from what you edited.
Private by design
Your calendar is read inside your Google account. Our server only sees your Google email and subscription status. Privacy
Questions
Is this tax advice? No. SheetMiles builds a record. Whether a trip is deductible or reimbursable depends on your situation; ask a tax professional. The IRS explains what a mileage record should contain in Publication 463.
What if an event has no address? It's skipped. Add an address to the event's Location field and rebuild.
Do I need a Google Workspace account? No, a free Gmail account works. Workspace accounts get a higher daily Google Maps quota.
Can I cancel? Yes, any time, from "Manage billing" in the add-on.