How to Calculate MPG in Excel

Updated February 21, 2017

Tracking your miles per gallon is a great way to monitor your fuel efficiency. With a good tracking system, you can see if you're getting what the manufacturer says you should. You can also compare it against things like maintenance records or tire pressure checks to see if they impact, positively or adversely, the MPG of your vehicle. A good way to track the MPG is to put a log in the car and employ the trip odometer. A little notebook to note your gallons purchased at each fill-up and the miles traversed since the last fill-up is all you need. You must fill the tank each time, though, to do this. From there, Excel provides a simple spreadsheet solution for the calculation.

Open Excel on your computer. A new file will appear.

Type "Date" in cell A1.

Type "Mileage" in cell B1

Type "Fuel" in cell C1.

Type "MPG" in cell D1.

Type "Notes" in cell E1.

Type "=B2/C2" in cell D2.

Place the cursor on cell D2.

Choose "Edit," then "Copy" from the menu bar. The menu bar is at the top of the screen.

Click and drag from cell D3 to cell D50. Choose "Edit," then "Paste" from the menu bar. This gives you about 50 entries for your data. You can easily add more later employing the same cut and paste technique.

Enter your data; use a row for each enter. Place the date in column A. Place the mileage in column B. Place the fuel amount in column C. The MPG will calculate automatically in column D. Use column E for any notes.

bibliography-icon icon for annotation tool Cite this Article

About the Author

Bill Brown has been a freelance writer for more than 14 years. Focusing on trade journals covering construction and home topics, his work appears in online and print publications. Brown holds a Master of Arts in liberal arts from St. John's University and is currently based in Houston.