CSV Template
Download the template below and follow the field instructions to ensure a successful import.
Download TemplateField Reference
Flight Details
Field Name
Format
Example
Required
Description
Field:
flight_date Format: Consistent date format
Example:
2025-03-15 or 15/03/2025 Required:
Yes
Description: Date of the flight (use the same format for all rows)
Field:
departure_airport Format: ICAO or IATA
Example:
KJFK or JFK Required:
Yes
Description: ICAO (4-letter) or IATA (3-letter) airport code
Field:
departure_time_utc Format: HH:MM
Example:
14:30 Required:
Yes
Description: Departure time in UTC (24-hour format)
Field:
arrival_airport Format: ICAO or IATA
Example:
KLAX or LAX Required:
Yes
Description: ICAO (4-letter) or IATA (3-letter) airport code
Field:
arrival_time_utc Format: HH:MM
Example:
17:45 Required:
Yes
Description: Arrival time in UTC (24-hour format)
Field:
stop_airports Format: ICAO or IATA
Example:
KORD,KDEN or ORD,DEN Required: No
Description: Comma-separated list of intermediate stops
Field:
flight_number Format: Text
Example:
UA123 Required: No
Description: Flight number
Field:
operator_name Format: Text
Example:
United Airlines Required: No
Description: Operator/airline name
Aircraft
Field Name
Format
Example
Required
Description
Field:
aircraft_registration Format: Text
Example:
N12345 Required:
Yes
Description: Aircraft registration/tail number
Field:
aircraft_make Format: Text
Example:
Cessna Required:
Yes
Description: Aircraft manufacturer
Field:
aircraft_model Format: Text
Example:
172 Required:
Yes
Description: Aircraft model
Field:
aircraft_variant Format: Text
Example:
S Required: No
Description: Aircraft variant/series
Simulator
Field Name
Format
Example
Required
Description
Field:
simulator_time Format: Duration
Example:
2.5 or 2:30 or 2,5 Required: No
Description: Time in simulator (decimal hours, H:MM, or EU comma format)
Field:
simulator_make Format: Text
Example:
CAE Required: No
Description: Simulator manufacturer
Field:
simulator_model Format: Text
Example:
7000XR Required: No
Description: Simulator model
Flight Times
Field Name
Format
Example
Required
Description
Field:
total_flight_time Format: Duration
Example:
3.2 or 3:12 or 3,2 Required:
Yes
Description: Total flight time (decimal hours, H:MM, or EU comma format)
Field:
pic_time Format: Duration
Example:
3.2 or 3:12 Required: No
Description: Pilot in Command time
Field:
sic_time Format: Duration
Example:
1.5 or 1:30 Required: No
Description: Second in Command time
Field:
dual_time Format: Duration
Example:
1.5 or 1:30 Required: No
Description: Dual instruction received
Field:
instructor_time Format: Duration
Example:
1.5 or 1:30 Required: No
Description: Flight instruction given
Field:
night_time Format: Duration
Example:
1.0 or 1:00 Required: No
Description: Night flight time
Field:
ifr_time Format: Duration
Example:
2.0 or 2:00 Required: No
Description: IFR flight time
Field:
actual_instrument_time Format: Duration
Example:
1.5 or 1:30 Required: No
Description: Actual instrument conditions
Field:
simulated_instrument_time Format: Duration
Example:
0.5 or 0:30 Required: No
Description: Simulated instrument (hood/foggles)
Field:
cross_country_time Format: Duration
Example:
3.2 or 3:12 Required: No
Description: Cross-country flight time
Crew Names
Field Name
Format
Example
Required
Description
Field:
name_pic Format: Text
Example:
John Smith Required: No
Description: Name of PIC
Field:
name_sic Format: Text
Example:
Jane Doe Required: No
Description: Name of SIC
Field:
name_dual Format: Text
Example:
John Smith Required: No
Description: Name of student (if dual)
Field:
name_instructor Format: Text
Example:
Captain Jones Required: No
Description: Name of instructor
Landings & Takeoffs
Field Name
Format
Example
Required
Description
Field:
landings_day Format: Number
Example:
2 Required: No
Description: Total day landings
Field:
landings_full_stop_day Format: Number
Example:
1 Required: No
Description: Day full-stop landings
Field:
landings_night Format: Number
Example:
1 Required: No
Description: Total night landings
Field:
landings_full_stop_night Format: Number
Example:
1 Required: No
Description: Night full-stop landings
Field:
takeoffs_day Format: Number
Example:
2 Required: No
Description: Day takeoffs
Field:
takeoffs_night Format: Number
Example:
1 Required: No
Description: Night takeoffs
Approaches & Procedures
Field Name
Format
Example
Required
Description
Field:
approaches Format: Text
Example:
2 ILS, 1 VOR or ILS x2 Required: No
Description: Approach types and counts (e.g., ILS, VOR, NDB, RNAV, LPV, Visual)
Field:
holding_procedures Format: Number
Example:
2 Required: No
Description: Number of holding procedures
Flight Flags
Field Name
Format
Example
Required
Description
Field:
is_multi_pilot Format: Boolean
Example:
true or yes Required: No
Description: Multi-pilot operation
Field:
was_picus Format: Boolean
Example:
true or yes Required: No
Description: PIC Under Supervision
Field:
was_spic Format: Boolean
Example:
true or yes Required: No
Description: Student PIC
Field:
was_safety_pilot Format: Boolean
Example:
true or yes Required: No
Description: Acting as safety pilot
Field:
was_examiner Format: Boolean
Example:
true or yes Required: No
Description: Acting as examiner
Field:
was_checkride Format: Boolean
Example:
true or yes Required: No
Description: Checkride/practical test
Field:
was_ipc Format: Boolean
Example:
true or yes Required: No
Description: Instrument Proficiency Check
Field:
was_solo Format: Boolean
Example:
true or yes Required: No
Description: Solo flight
Remarks
Field Name
Format
Example
Required
Description
Field:
remarks_endorsements Format: Text
Example:
First solo XC Required: No
Description: Remarks and endorsements