Import Your Uber CSV as a Mileage Log — No GPS Tracker Needed
Every completed trip in your Uber driver CSV includes the actual route distance Uber recorded. Upload it to ExpenseBot and each trip row becomes a mileage log entry — date, pickup, dropoff, miles, Google Maps link, and IRS rate × miles as your deduction. Batch-import a full year at once.
60-day free trial · Works with Uber, UberEats, DoorDash, Instacart · No credit card
What's in Your Uber Driver CSV (Column-by-Column)
Uber's driver CSV contains up to 16 columns confirmed from real driver data. The column set varies by week — if no tips were earned, the tip column is omitted; if no surge, surge is absent. Here's what each column contains and how it maps to your mileage log:
| Column | Contains | Used for |
|---|---|---|
ride_start | Trip start timestamp (date + time) | Date field in mileage log |
ride_end | Trip end timestamp | Duration calculation |
distance | Actual route miles (Uber's number) | Miles in mileage log ✓ |
pickup_address | Full pickup street address | From field + map link |
dropoff_address | Full dropoff street address | To field + map link |
earnings | Total driver payout for trip | Income row amount |
base_pay | Base fare component | Reference only |
tip | Customer tip (income, not a fee) | Included in earnings |
surge | Surge pricing bonus (income) | Included in earnings |
id | Uber's unique trip identifier | Dedup key ✓ |
ride_type | UberX, Comfort, Black, etc. | Description label |
status | COMPLETED, CANCELLED, etc. | Only COMPLETED rows imported |
Key: the distance column is Uber's own recorded route miles — more accurate than GPS approximation. The id column is used as a unique dedup key.
How to Download Your Uber CSV
What the Import Creates — Income + Mileage in One Pass
One CSV upload creates records in two places simultaneously. No second upload, no manual step:
The Mileage Log Output Format — IRS-Compliant
The IRS requires a mileage log to contain four pieces of information per trip: date, destination, business purpose, and distance. Your Uber CSV import produces all four automatically, plus extras that make audits straightforward:
| Field | Value | IRS Requirement |
|---|---|---|
| Date | ride_start (exact timestamp) | ✓ Required |
| From | pickup_address | Context only |
| To | dropoff_address | ✓ Required (destination) |
| Miles | distance column (actual route) | ✓ Required |
| Purpose | Business — Rideshare (Uber) | ✓ Required |
| Rate | $0.725/mile (IRS 2026) | For calculation |
| Total $ | Miles × rate | Deduction amount |
| Trip ID | Uber's unique ID | Audit cross-reference |
| Map link | Google Maps HYPERLINK | Route verification |
| Recorded At | Import timestamp | Audit trail |
Dedup — What Happens If You Re-Import the Same File
Uber's id column is a unique identifier for every trip. ExpenseBot uses it to build a record ID for each mileage entry:
Why This Is More Accurate Than a GPS Mileage App
GPS mileage tracker apps approximate your route by sampling your phone's GPS position at intervals. Uber's CSV records the route distance Uber's own dispatch system assigned — the number Uber uses to calculate the fare. These are not the same:
In an IRS audit, Uber's own trip records are more defensible than a third-party GPS approximation. The CSV is the source of truth.
Other Platforms — DoorDash, Instacart, UberEats
The same workflow works for other gig platform CSVs. Upload the file, and our parser classifies the platform automatically:
Frequently Asked Questions
Where do I download my Uber driver CSV?▾
Log in to drivers.uber.com, go to Earnings, select a date range, and click Export CSV. Uber allows up to 12 months per export — download by quarter (Jan–Mar, Apr–Jun, Jul–Sep, Oct–Dec) to capture a full year. The CSV downloads immediately with no email required.
Does the CSV import create a mileage log automatically?▾
Yes. Each completed trip row in your Uber CSV becomes one entry in your Mileage Log — date, pickup address, dropoff address, actual route miles, and total dollar deduction at the current IRS or CRA rate. No separate mileage app needed, no manual entry, no categorization required.
What if my Uber CSV is missing columns?▾
The Uber CSV column set varies by week. If there were no tips for a period, the tip column is omitted. If there were no surges, the surge column is absent. Our Gemini-powered parser handles variable column shapes — it classifies the file as Uber and maps columns by header name, not position. Missing columns are treated as zero.
Can I import CSVs from multiple months without getting duplicates?▾
Yes. Each mileage entry gets a record ID in the format mileage_uber_[trip_id], using Uber's unique trip ID column. Re-importing the same file, or uploading overlapping date ranges (e.g., Jan–Jun and Apr–Sep), detects existing trips by their ID and skips them. No duplicate rows.
Does this work for UberEats delivery trips?▾
Yes — UberEats driver CSVs have the same column structure as Uber rideshare CSVs. Upload the file and the parser classifies it as UberEats automatically. Both rideshare and delivery trips land in the same mileage log, with source labelled accordingly.
What's the difference between importing for mileage vs income?▾
One upload does both simultaneously. Income entries (earnings per trip) go to your Income tab. Mileage entries (miles per trip × IRS rate) go to your Mileage Log. Both are created from the same CSV in one pass — no second upload needed.
Why is the CSV distance more accurate than a GPS tracker?▾
GPS tracker apps calculate your route in real time using your phone's GPS chip, producing an approximation. Uber's CSV records the route distance that Uber's dispatch algorithm assigned — the same figure Uber uses to calculate your fare. In an IRS audit, Uber's own trip records are more defensible than a third-party GPS approximation.
What does the mileage log output look like?▾
Each row in your Mileage Log contains: Date, From (pickup address), To (dropoff address), Miles (actual route distance), Purpose (auto-set: Business — Rideshare), Rate (IRS 2026: $0.725/mile), Total $ deduction, Trip ID (Uber's ID for audit trail), and a Google Maps HYPERLINK from pickup to dropoff for route verification.
Your Uber CSV Has a Year of Mileage Data. Import It Now.
No GPS tracker. No manual entry. Upload the CSV Uber already gave you and your mileage log is done.
Start Free — Import My Uber CSV60-day free trial · No credit card · UberEats, DoorDash, Instacart also supported