Track Gas & Fuel Mileage for Vehicles: Excel Spreadsheet Template

Gas & MPG Tracker for Cars: Easy Excel Spreadsheet

Keeping track of fuel usage and mileage helps you save money, spot vehicle issues early, and plan trips more efficiently. This guide shows how to build and use a simple, effective Excel spreadsheet to record fuel purchases, calculate miles per gallon (MPG) or liters per 100 km (L/100km), and analyze trends over time.

What you’ll track

• Date of fill-up
• Odometer reading at fill-up
• Fuel volume purchased (gallons or liters)
• Fuel cost (total)
• Price per unit (optional)
• Full tank? (yes/no) — needed for accurate MPG
• MPG (or L/100km) — calculated
• Cost per mile/km — calculated
• Notes (location, driving conditions)

Spreadsheet layout (columns)

Use these columns in order starting in column A:

1. Date
2. Odometer
3. Fuel Volume (gal or L)
4. Fuel Cost
5. Price per Unit
6. Full Tank (Y/N)
7. Miles Driven (calculated)
8. MPG / L/100km (calculated)
9. Cost per Mile / km (calculated)
10. Notes

Formulas (assume row 2 is first data row)

• Price per Unit (E2): =IF(C2>0, D2/C2, “”)
• Miles Driven (G2): =IF(AND(B2<>“”, B1<>“”), B2 - B1, “”) — when odometer increases
• MPG (H2, gallons): =IF(AND(C2>0, G2>0, F2=“Y”), G2 / C2, “”)
• L/100km (alternate, if using liters and km): =IF(AND(C2>0, G2>0, F2=“Y”), (C2 / G2)100, “”)
• Cost per Mile (I2): =IF(AND(D2>0, G2>0), D2 / G2, “”)

Notes:

• Use the “Full Tank” column set to Y only when you fill the tank completely; calculate MPG only for entries after a full fill-up for accuracy.
• If you record partial fills, leave MPG blank for those rows or mark them and exclude from averages.

Improving accuracy

• Always reset odometer/mileage units consistently (miles vs km).
• Prefer recording only full-tank fill-ups for MPG calculations.
• Enter odometer before and after trips when possible.
• Round to two decimal places for readability.

Analysis and visualization

• Add a running average MPG: in H3 use =AVERAGEIFS(H:H, H:H, “>0”) (adjust range to exclude headers).
• Create a line chart of MPG over time to visualize trends.
• Pivot tables can summarize fuel cost by month or vehicle (for fleets).
• Add conditional formatting to highlight MPG drops or high cost-per-mile.

Template tips

• Create separate sheets per vehicle and a master sheet for fleet totals.
• Protect formula cells to avoid accidental edits.
• Add drop-downs for units and full-tank choices (Data Validation).
• Save a blank template copy to reuse for new vehicles.

Quick start checklist

1. Create columns as listed.
2. Enter first two fill-ups with odometer and fuel info.
3. Mark the first full tank as Y and start using MPG formula on the next full tank row.
4. Copy formulas down the sheet.
5. Add charts and summary rows as needed.

Use this Excel tracker to monitor efficiency improvements, spot maintenance needs (sudden MPG drops), and budget fuel expenses more accurately.