Vehicle Fuel Mileage Tracker: Excel Spreadsheet for Gas Log & MPGs

Vehicle Fuel Mileage Tracker: Excel Spreadsheet for Gas Log & MPGs

A Vehicle Fuel Mileage Tracker spreadsheet helps you log fill-ups, calculate fuel economy, and monitor vehicle operating costs over time. Below is a concise overview of features, setup, key columns/formulas, and tips for use.

Key features

• Fill-up log (date, odometer, gallons, price, total cost)
• Automatic MPG (or L/100 km) calculations
• Cost-per-mile (or cost-per-km) and rolling averages
• Filters by vehicle (multi-vehicle support)
• Summary dashboard: monthly and yearly averages, total fuel spent, distance driven
• Conditional formatting to flag unusually low efficiency
• Charts: MPG over time, monthly cost, fuel usage by vehicle

Essential columns

• Date
• Vehicle (optional for multiple vehicles)
• Odometer reading
• Trip distance (optional; can be calculated)
• Fuel added (gallons or liters)
• Price per unit
• Total cost (price × fuel)
• Fuel type (optional)
• MPG (or L/100 km)
• Cost per mile/km

Core formulas (Excel)

• Trip distance (if not entered): =Odometer – PreviousOdometer
• MPG (US, using gallons): =TripDistance / FuelAdded
• L/100 km (metric): = (FuelLiters / TripDistanceKm)100
• Total cost: =FuelAdded * PricePerUnit
• Cost per mile: =TotalCost / TripDistance
• Rolling average MPG (last N fill-ups): =AVERAGE( range_of_last_N_MPGs )

Use structured references or Excel Tables to make formulas auto-fill as you add rows.

Setup tips

• Record odometer at every fill-up for accurate distance-based MPG (avoid partial fills unless using “gallons added” method consistently).
• Use full-tank fill-ups for best MPG consistency.
• Create a named Table and a separate pivot-table dashboard for summaries and charts.
• Normalize units (gallons vs liters, miles vs km) and convert consistently.
• Protect formula columns and keep raw-entry columns unlocked.

Useful charts to add

• Line chart of MPG over time
• Column chart of monthly fuel cost
• Stacked area of fuel consumption by vehicle

Quick start template (recommended columns order)

Date | Vehicle | Odometer | Trip Distance | Fuel Added | Price/Unit | Total Cost | MPG | Cost/ mile

If you want, I can create a ready-to-download Excel template (with formulas, table, and dashboard).