Fuel Mileage Tracker in Excel: km per Litre and Cost per km for Your Bike or Car

By Ravindra Bagale · Last updated: 17 October 2026

Download the template: fuel-mileage-tracker-template.xlsx: example data with real formulas. Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and everything recalculates.

Made-up data: every name, amount, shop and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The example

Raja fills his bike's tank full each time (made-up readings and prices). Eight fills from 2 August to 16 October 2026:

From the first to the last reading he rode 2,840 km on 61.8 litres, so his average is 46.0 km per litre and ₹2.28 per km. At 900 km a month that is about ₹2,054 of fuel. The 9 October fill (41.0) is the one to look at: tyre pressure, a heavy load or fast highway riding.

How the full-tank method works. When the tank is full, the litres you put in now are exactly the fuel you burned since the last full tank. So km per litre = km since the last fill ÷ litres filled now.

2. Build it step by step

Step 1. Set up the log

1. In A4:I4 type Date, Odometer, Litres, Price per litre, Amount, Pump, km since last fill, km per litre, Cost per km.
2. Type every fill from A5 down (yellow). The first row is only the starting odometer.
3. Select F5:F200 > Data > Data Validation > List: Near home,Highway,Office side (drop-down lists).

Step 2. Amount and distance

1. In E5 type =C5*D5 and copy down: litres × price.
2. In G6 type =B6-B5: 442 km since the last fill.

Step 3. Mileage and cost per km

1. In H6 type =G6/C6: 48.6 km per litre.
2. In I6 type =E6/G6: ₹2.15 per km.
3. Copy G6:I6 down to the last fill.

Step 4. Summary the right way

1. In L5 type =B12-B5: 2,840 km.
2. In L6 type =SUM(C6:C12): 61.8 litres. Leave out the first fill; that fuel was burned before the log started.
3. In L7 type =L5/L6: 46.0 km per litre.
4. In L8 type =SUM(E6:E12) and in L9 =L8/L5: ₹2.28 per km.
5. In L10 type =MAX(H6:H12): 48.6, the best fill.

Step 5. Monthly fuel estimate

1. Type the km you ride in a month in L11 (900).
2. In L12 type =L11*L9: about ₹2,054.

Step 6. Alerts and chart

1. Select H6:H200 > Conditional Formatting > New Rule > Use a formula: =AND(H6<>"",H6<$L$7*0.95), red. This marks fills more than 5% below the average (formula rules).
2. Add a second rule =AND(H6<>"",H6>=$L$7*1.05) with green.
3. Select H6:H12 > Insert > Line (line charts).

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in the file.

4. Common mistakes

1. Not filling the tank full. With a half fill, the litres do not match the km. Fill full every time, or skip mileage for that row.
2. Averaging the km per litre column. =AVERAGE(H6:H12) gives every fill equal weight. Total km ÷ total litres is the true average.
3. Counting the first fill's litres. The first fill's fuel was used before the log started. Start the litres SUM from the second fill.
4. Skipping a fill-up. A missed entry adds two tanks of km to one tank of litres and shows impossible mileage.
5. Typing trip km instead of the odometer. Always type the full odometer reading. The sheet works out the distance.

5. More real examples

Example 1: Car with CNG and petrol. Add a Fuel drop-down (Petrol, CNG) and use AVERAGEIF or SUMIFS to get mileage for each fuel.

Example 2: Two vehicles at home. Make one sheet per vehicle and a summary sheet that pulls each L7 and L9.

Example 3: City vs highway. Use the Pump column, or add a Trip type column, then compare average km per litre with SUMIFS on km and litres.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I calculate mileage in Excel?

Fill the tank full, note the odometer, and use km per litre = (this odometer − last odometer) ÷ litres filled now.

How do I calculate cost per km?

Amount paid ÷ km since the last fill. For the overall figure use total fuel cost ÷ total km.

Why is my average different from AVERAGE of the mileage column?

AVERAGE treats short and long fills the same. Total km ÷ total litres weights each fill by its fuel.

Can I use it for a car?

Yes. Nothing in the formulas is bike-specific.

How do I spot a drop in mileage?

The red rule marks any fill more than 5% below your average, and the line chart shows the dip.

7. Quick quiz

Ten questions on this page. Sign in to save your score.