Guide

CSV import

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.

ColumnRequiredDescriptionExample
dateRequiredFlight date in YYYY-MM-DD.2026-04-12
aircraftRequiredTail number (uppercased on save).N12345
aircraftTypeOptionalMake & model — free text.C172
fromOptionalDeparture ICAO/identifier.KATL
toOptionalArrival ICAO/identifier.KCHA
hobbsStartOptionalHobbs at start. Optional if total is given.120.2
hobbsEndOptionalHobbs at end.121.6
totalOptionalTotal time. Used if hobbs columns are empty.1.4
picOptionalPilot-in-command time.1.4
sicOptionalSecond-in-command time.0
dualOptionalDual-received time.0
nightOptionalNight time.0
imcOptionalActual instrument time.0
xcOptionalCross-country time.0.9
dayLandingsOptionalDay landings (integer).2
nightLandingsOptionalNight landings (integer).0
approachesOptionalInstrument approaches (integer).0
holdsOptionalHolding procedures (integer).0
remarksOptionalFree-text notes. Wrap in quotes if it contains commas."Short XC"

Example CSV

Save as logbook.csv and upload:

date,aircraft,aircraftType,from,to,hobbsStart,hobbsEnd,total,pic,sic,dual,night,imc,xc,dayLandings,nightLandings,approaches,holds,remarks
2026-04-12,N12345,C172,KATL,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,,,,1.1,0,0,0.3,0,0,1,1,0,0,"Return leg, light haze"

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".
  • Dates can be YYYY-MM-DD or MM/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.