Printable Gas Mileage Log Spreadsheet — Track Fuel Costs & Efficiency in Excel

Vehicle Fuel Mileage Tracker (Excel) — Simple Gas Log Spreadsheet

Keeping a simple, accurate record of fuel usage helps you save money, monitor vehicle efficiency, and spot maintenance issues early. This guide gives a no-frills Excel gas log you can set up in minutes, how to use it, and quick tips to get useful insights from the data.

What the spreadsheet does

• Records fill-ups and odometer readings.
• Calculates trip miles, gallons used, and miles per gallon (MPG).
• Tracks fuel cost per gallon and total cost per fill-up.
• Summarizes vehicle performance over time with averages and trends.

Spreadsheet layout (columns)

Use one row per fill-up. Create these columns:

1. Date — fill-up date
2. Vehicle — name or license (for multiple vehicles)
3. Odometer — current odometer reading (miles or km)
4. Trip Miles — miles since last fill-up (calculated)
5. Gallons — fuel added (or liters)
6. Price/Gallon — cost per gallon (or per liter)
7. Total Cost — cost for this fill-up (calculated)
8. MPG — miles per gallon for the trip (calculated)
9. Notes — optional (route, fuel grade, maintenance)

Key formulas

Assume columns are A–I and row 2 is the first data row.

• Trip Miles (D2): =IF(B2=“”,“”,A2 formula depends on layout)
  Use this actual formula (if Odometer in C):
  =IF(ROW()=2,“”,C2 – C1)

• Total Cost (G2):
  =IF(OR(E2=“”,F2=“”),“”,E2F2)

• MPG (H2):
  =IF(OR(D2<=0,E2=0),“”,D2 / E2)

Drag formulas down for new rows. Use data validation to ensure numbers are positive.

Summary section

Create a small summary area (top or side) with these formulas:

• Average MPG: =AVERAGEIF(H:H,“>0”)
• Total Fuel Cost (period): =SUM(G:G)
• Total Miles Driven: =MAX(C:C)-MIN(C:C)
• Average Price/Gallon: =AVERAGEIF(F:F,“>0”)

Add a pivot table or FILTER+SUMIFS if tracking multiple vehicles.

Simple chart ideas

• MPG over time (line chart)
• Price/Gallon over time (line chart)
• Monthly fuel cost (column chart using SUMIFS by month)

Tips for accurate results

• Always fill odometer at every refuel.
• Use “fill to full” method: only record when you fully top off the tank to get correct MPG.
• Keep units consistent (miles vs km, gallons vs liters).
• Include fuel type in Notes if you switch between gas and diesel or grades.

Quick automation ideas

• Freeze header row and use Excel Tables (Insert → Table) so formulas auto-fill.
• Use conditional formatting to highlight MPG drops (e.g., >15% below average).
• Add a simple macro or Power Query to aggregate monthly reports if you track many vehicles.

Downloadable starter template (structure)

• Header row with columns: Date, Vehicle, Odometer, Trip Miles, Gallons, Price/Gallon, Total Cost, MPG, Notes
• Pre-filled formulas for Trip Miles, Total Cost, and MPG
• Summary block with Average MPG, Total Cost, Total Miles, Average Price

This lightweight Excel gas log gives immediate, actionable insight into fuel efficiency and costs with minimal upkeep. Set it up once and update at each fill-up to start finding savings and spotting problems fast.