CSV Import Guide

Log61 can import your existing logbook from ForeFlight, MyFlightbook, or any CSV file. This page explains how each format is detected and what columns are expected.

Supported formats

Auto-detected

ForeFlight

Export directly from ForeFlight (Logbook → Export → CSV). Log61 detects the ForeFlight format automatically. No changes needed.

Auto-detected

MyFlightbook

Export from MyFlightbook as CSV. No changes needed.

Auto-detected

Generic / Custom CSV

Any CSV with the column names listed below. Column names are case-insensitive. You can include only the columns you have, all fields except Date are optional.

Generic CSV columns

Use these exact column header names. Column order does not matter. All columns except Date are optional.

Required

Column Header	Format	Example
`Date`	YYYY-MM-DD, MM/DD/YYYY, MM-DD-YYYY, or MM/DD/YY	`2024-03-15`

Aircraft

Column Header	Format	Example
`Aircraft Make/Model`	Text	`Cessna 172`
`Tail Number`	Text	`N12345`
`Category/Class`	Text	`ASEL`
`Turbine`	yes/no or true/false	`no`
`Complex`	yes/no or true/false	`no`
`High Performance`	yes/no or true/false	`no`
`Tailwheel`	yes/no or true/false	`no`

Route

Column Header	Format	Example
`From`	Airport identifier	`KTTF`
`To`	Airport identifier	`KMCD`
`Via`	Intermediate stops, space-separated	`KARB KGLR`

Flight time (decimal hours)

Column Header	Example
`Total Time`	`1.4`
`PIC`	`1.4`
`SIC`	`0`
`Dual Received`	`0`
`Dual Given`	`0`
`Solo`	`0`
`Cross Country`	`1.4`
`Night`	`0`
`Actual Instrument`	`0`
`Simulated Instrument`	`0`
`Single Engine`	`1.4`
`Multi Engine`	`0`
`Simulator`	`0`

Landings & approaches (whole numbers)

Column Header	Example
`Day Landings`	`1`
`Night Landings`	`0`
`Instrument Approaches`	`0`

Other

Column Header	Format	Example
`Remarks`	Free text	`First trip to Mackinac Island`

Example

A minimal valid CSV looks like this:

Date,Aircraft Make/Model,Tail Number,From,To,Total Time,PIC,Cross Country,Day Landings,Remarks
2024-03-15,Cessna 172,N12345,KTTF,KMCD,KARB KGLR,1.4,1.4,1.4,1,First trip to Mackinac Island
2024-03-20,Cessna 172,N12345,KTTF,KTTF,,0.8,0.8,0,3,Pattern work

Save your spreadsheet as CSV UTF-8 (not Excel .xlsx). In Excel: File → Save As → CSV UTF-8 (Comma delimited). In Google Sheets: File → Download → Comma-separated values.

After import

Log61 will show you a preview of all detected flights before saving anything. You can deselect any rows you do not want to import. Cross-country and over-50nm XC are recalculated automatically from your airport route after import.