Skip to the content.

Free Google Sheets Mileage Log

For anyone who drives between jobs and wants a clean mileage record for reimbursement or tax time, with odometer checks.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Dashboard Totals and views built from Trips, no typing needed.
Monthly Log Totals and views built from Trips, no typing needed.
Trips Columns Trip ID, Date, Driver, Vehicle, Start location, End location, Purpose, Customer or job, Start odometer and 7 more.
Settings Your own dropdown lists (drivers, vehicles and business or personal), so the choices match how you work.

How to fill it in

  1. Add drivers and vehicles on Settings.
  2. Log each trip on Trips with start and end location, purpose and odometer readings.
  3. Mark business or personal and round trips.
  4. Read Monthly Log and Dashboard for business miles and reimbursement owed.

A tip from the field

Odometer gaps get flagged, so a trip missing between two readings shows up while you still remember it.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle plans each technician’s route for the day with drive times between stops. See how it works on smarfle.com.

All free templates