Bring flights in from ForeFlight, LogTen, a spreadsheet, or any other logbook. One row per flight, first row is the header. Nothing is replaced — imports are appended.
Ready to import?
Open the logbook and click "Import CSV" in the top-right.
Column reference
Only date and aircraft are required. Numeric fields default to 0 when missing. Use either the Hobbs pair or total — whichever is present.
| Column | Required | Description | Example |
|---|---|---|---|
| date | Required | Flight date in YYYY-MM-DD. | 2026-04-12 |
| aircraft | Required | Tail number (uppercased on save). | N12345 |
| aircraftType | Optional | Make & model — free text. | C172 |
| from | Optional | Departure ICAO/identifier. | KATL |
| to | Optional | Final arrival ICAO/identifier. | KCHA |
| route | Optional | Every stop in order, space- or dash-separated. Multi-stop flights keep each stop; separate Stop 1 / Stop 2 / Via columns work too. | KATL KRMG KCHA |
| hobbsStart | Optional | Hobbs at start. Optional if total is given. | 120.2 |
| hobbsEnd | Optional | Hobbs at end. | 121.6 |
| total | Optional | Total time. Used if hobbs columns are empty. | 1.4 |
| pic | Optional | Pilot-in-command time. | 1.4 |
| sic | Optional | Second-in-command time. | 0 |
| dual | Optional | Dual-received time. | 0 |
| instructor | Optional | Instructor's name. A column of hours with this name is read as dual given instead. | |
| night | Optional | Night time. | 0 |
| imc | Optional | Actual instrument time. | 0 |
| xc | Optional | Cross-country time. | 0.9 |
| dayLandings | Optional | Day landings (integer). | 2 |
| nightLandings | Optional | Night landings (integer). | 0 |
| approaches | Optional | Instrument approaches (integer). | 0 |
| holds | Optional | Holding procedures (integer). | 0 |
| remarks | Optional | Free-text notes. Wrap in quotes if it contains commas. | "Short XC" |
Example CSV
Save as logbook.csv and upload:
date,aircraft,aircraftType,from,to,route,hobbsStart,hobbsEnd,total,pic,sic,dual,instructor,night,imc,xc,dayLandings,nightLandings,approaches,holds,remarks 2026-04-12,N12345,C172,KATL,KCHA,KATL KRMG KCHA,120.2,121.6,1.4,1.4,0,0,,0,0,0.9,2,0,0,0,"Short XC" 2026-04-13,N54321,PA28,KCHA,KATL,KCHA KRMG KATL,,,1.3,0,0,1.3,"Jane Smith",0.3,0,1.3,2,0,0,0,"Return leg via Rome, dual XC"
Importing from another logbook
AeroLog auto-detects column names from the most common pilot logbooks — you should be able to drop the export in as-is.
ForeFlight
Logbook → ⋯ → Export. AeroLog skips ForeFlight's metadata header rows automatically.
LogTen Pro
Flights → File → Export → CSV. The flight_ column prefix is stripped on import.
MyFlightbook
Logbook → Download → CSV. Tail, model, IMC, and full-stop landing columns map automatically.
Other sources (Garmin Pilot, Jeppesen FliteDeck, spreadsheets) usually work too — AeroLog matches headers case-insensitively and ignores spaces, hyphens, and underscores, so Cross-Country, cross country, andcross_country all map to the same field.
Tips
- Wrap any value containing a comma in double-quotes:
"Night XC, 2 stops". - Multi-stop flights: put every stop in the route column (
KATL KRMG KCHA), or use separate Stop 1, Stop 2… columns — each stop is kept, in order. - Tab-separated files (LogTen) and semicolon-separated spreadsheets import too.
- Dates can be
YYYY-MM-DDorMM/DD/YYYY— both work. - Export your current logbook from /logbook to see the exact column names — round-tripping is the safest way to migrate.
- Imports always append; nothing in your existing logbook is overwritten.
- AeroLog preserves the values you enter; it doesn't overwrite night/XC from your source.
Troubleshooting
Nothing imported
Most common cause: the header row is missing or misspelled. The first line must be the column names separated by commas.
All totals came in as 0
Either the total column is empty, or the Hobbs columns are empty. Populate one or the other.
Hit the free-plan cap
Free accounts are limited on total flights. Upgrade on Pricing before importing a large history.