Fuel Data Importer
Fuel Data Importer. Load mileage and purchase records. Enter your values and view the result.
Fuel Data Importer
Load mileage and purchase records.
Use the calculation engine below to model your exact costs with custom fuel prices, distances, and vehicle efficiencies:
Fuel Data Importer: inputs
Adjust sliders or enter exact figures
Monthly Fuel Budget
Real-Time Visual Breakdown
Comparing your expense against alternative vehicle classes
Price Fluctuation Stress Test
See how unexpected gas price surges would impact your monthly budget
How Fuel Data Importer Works
The Fuel Data Importer works by reading mileage and purchase records from a CSV file, mapping each column to a known field, checking each row, and loading clean data into the budget tools.
- Step 1
Upload a file
Choose a comma-separated values (CSV) file from a fuel app, card statement, or spreadsheet.
- Step 2
Map the columns
Match file columns to date, odometer, volume, price, and cost.
- Step 3
Review the checks
The importer flags missing values, odometer readings that go backward, and cost totals that do not match volume × price.
- Step 4
Load the data
Clean rows load into the tracker, charts, and reports.
Fuel Data Importer Formula
The Fuel Data Importer formulas validate each row and derive missing fields.
Cost Check: |Cost − Volume × Price| ≤ $0.05
Derived Price = Cost ÷ Volume (when price is missing)
Distance = Odometer(n) − Odometer(n − 1), must be > 0
- Volume
- = gallons or liters in the row
- Odometer(n)
- = reading in row n, sorted by date
Worked Example
- Row 14 lists 12.1 gallons, $3.52 per gallon, and a cost of $42.59.
- Cost check: 12.1 × 3.52 = 42.592, within $0.05 of $42.59, so the row passes.
- Row 15 lists 11.5 gallons and $38.99 with no price. Derived price = 38.99 ÷ 11.5 = $3.39.
- Row 16 shows a lower odometer than row 15 and is flagged for review.
Fuel Data Importer Conversion Table
The Fuel Data Importer conversion table lists the supported fields, accepted formats, and whether each field is required.
| Field | Accepted Formats | Example | Required |
|---|---|---|---|
| Date | YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY | 2026-11-15 | Yes |
| Odometer | Miles or kilometers, no commas | 42735 | For MPG only |
| Volume | Gallons or liters, decimal | 12.1 | Yes |
| Price per unit | Decimal, no currency sign | 3.52 | No, derived from cost |
| Cost | Decimal, no currency sign | 42.59 | No, derived from price |
| Full fill | Y/N, true/false, 1/0 | Y | For MPG only |
| Vehicle | Text label | Sedan | No |
What is a Fuel Data Importer?
A Fuel Data Importer is a data tool that loads mileage and fuel purchase records from a file into budgeting, tracking, and reporting tools.
Fuel apps, card statements, and old spreadsheets hold years of useful records. Typing them in again takes hours. The Fuel Data Importer reads the file, maps the columns, and checks every row so errors do not flow into reports.
Validation matters. A single odometer typo creates a fake 400 MPG reading that ruins an average.
What are the uses of a Fuel Data Importer?
There are 4 main uses of the Fuel Data Importer, including app migration, card statement imports, and fleet data loads.
Move from another app
Import an export file from a fuel log app.
Load card statements
Import fuel card or bank CSV statements.
Load fleet data
Import multi-vehicle records with a vehicle column.
Clean old spreadsheets
Validate and fix years of manual records.