This article describes the formatting requirements for each field within the ForeFlight Logbook Template.
NOTE: To download the logbook template:
- Sign in to ForeFlight on the Web.
- Select Logbook from the left menu.
- Select Import from the logbook view tabs.
- Select Download ForeFlight Template.
IMPORTANT: Don't remove columns and fields in the ForeFlight Logbook Template to ensure importation without errors. For instructions on how to add custom fields, refer to the following article: How can custom logbook fields be created in a logbook spreadsheet template?
AIRCRAFT TABLE FORMATTING
| FIELD | FORMATTING NOTES |
| AircraftID |
The aircraft’s registration, or 'tail number.' Example: N201TH |
| EquipmentType |
The type of equipment (aircraft or simulator) used for flight. Use one of the following:
If this field is left blank, 'aircraft' will be used. |
| TypeCode |
This is the aircraft's ATC flight plan code. It is usually four characters. Example: Piper Archer = P28A. Find aircraft codes using the ICAO Aircraft Type Designators website. |
| Year |
Four-digit year (YYYY) format. Example: 1997 |
| Make |
The manufacturer of the aircraft. Example: Cessna |
| Model |
The aircraft’s model name. Example: 172 |
| GearType |
The gear type of the aircraft. Use one of the following:
|
| EngineType |
The engine type of the aircraft. Use one of the following:
|
| Category |
The category of the aircraft. Use one of the following:
The aircraft’s 'Class' field must correlate to this field. |
| Class |
The class of the aircraft. Use one of the following codes:
|
| Complex |
This is a true or false field. If the aircraft is complex, mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
| HighPerformance | This is a true or false field. If the aircraft is high-performance, mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
| Pressurized | This is a true or false field. If the aircraft is pressurized, mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
| TAA |
This is a true or false field. If the aircraft is technically advanced (TAA), mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
FLIGHT TABLE FORMATTING
| FIELD | FORMATTING NOTES |
|---|---|
| Date |
The date of the flight in YYYY-MM-DD format. Example: 2002-01-02 |
| AircraftID |
The aircraft’s registration or 'tail number.' Example: N201TH |
| From |
The code for the departure airport. Example: KBVU |
| To |
The code for the destination airport. Example: KVGT |
| Route |
The points between departure and destination, separated by a space. Example: KCDC 67L |
| TimeOut |
Time the aircraft starts moving from the gate or ramp. Hours and minutes in 24-hour format. Example: 1823 |
| TimeOff |
Time the aircraft takes off. Hours and minutes in 24-hour format. Example: 1830 |
| TimeOn |
Time the aircraft lands. Hours and minutes in 24-hour format. Example: 2137 |
| TimeIn |
Time the aircraft stops at the gate or ramp. Hours and minutes in 24-hour format. Example: 2145 |
| OnDuty |
Hours and minutes in 24-hour format. Example: 1700 |
| OffDuty |
Hours and minutes in 24-hour format. Example: 2200 |
| TotalTime |
Duration of flight in decimal format. Example: 3.6 |
| PIC |
Pilot in Command duration in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
| SIC |
Second in Command duration in decimal format or in hours and minutes (HH:MM) format. Example: 0.0 (Decimal format) or 00:00 (HH:MM format) |
| Night |
Night duration in decimal format or in hours and minutes (HH:MM) format. Example: 1.2 (Decimal format) or 01:12 (HH:MM format) |
| Solo |
Solo duration in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
| CrossCountry |
Cross Country duration in decimal format or in hours and minutes (HH:MM) format. Example: 5.4 (Decimal format) or 05:24 (HH:MM format) |
| PICUS |
Pilot in Command Under Supervision duration in decimal format or in hours and minutes (HH:MM) format. Example: 1.2 (Decimal format) or 01:12 (HH:MM format) |
| MultiPilot |
Duration in decimal format or in hours and minutes (HH:MM) format. Example: 1.2 (Decimal format) or 01:12 (HH:MM format) |
| IFR |
Flight under Instrument Flight Rules duration in decimal format or in hours and minutes (HH:MM) format. Example: 1.2 (Decimal format) or 01:12 (HH:MM format) |
| Examiner |
Duration in decimal format or in hours and minutes (HH:MM) format. Example: 1.2 (Decimal format) or 01:12 (HH:MM format) |
| NVG |
Flight under Night Vision Goggles duration in decimal format. Example: 1.1 |
| NVGOps |
A whole number. Example: 3 |
| Distance |
Nautical miles in decimal format: Example: 135.0. This field can be used to track either the total route distance or the distance to the furthest landing for training purposes. Whichever option is selected, ensure consistency across all entries. |
| DayTakeoffs |
Takeoffs performed in the day in whole number format. Example: 2 |
| DayLandingsFullStop |
Landings performed to a stop during the day in a whole number format. Example: 2 |
| NightTakeoffs |
Takeoffs performed at night in a whole number format. Example: 1 |
| NightLandingsFullStop |
Night landing performed to a full stop in a whole number format. Example: 1 |
| AllLandings |
The total number of landings performed in a whole number format. Example: 3 |
| ActualInstrument |
Duration in actual IMC in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
| SimulatedInstrument |
Duration with a view limiting device, or "hood" in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
| HobbsStart |
Aircraft Hobbs reading at the beginning of flight: Example: 250.4 |
| HobbsEnd |
Aircraft Hobbs reading at end of flight: Example: 255.2 |
| TachStart |
Aircraft tachometer reading at the beginning of flight: Example: 200.15 |
| TachEnd |
Aircraft tachometer reading at the end of flight: Example: 204.42 |
| Holds |
The number of holds performed in a whole number format. Example: 1 |
| Approach1,2,... |
The approach(es) flown, with details separated by semicolons. Choose from the following approach types:
Format #;type;runway;airport;comments;circle. Example: 1;ILS;12L;KVGT;Broke out at 350 AGL. Example without a comment: 2;ILS OR LOC RWY 18L;18L;KAUS;;Circle. Circle will only show if Circle To Land is selected for the approach. |
| DualGiven |
Flight instruction provided in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
| DualReceived |
Flight instructions received in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
| SimulatedFlight |
Simulator time in decimal format or in hours and minutes (HH:MM) format. Example: 3.3 (Decimal format) or 03:18 (HH:MM format) |
| GroundTraining |
Ground training received in decimal format or in hours and minutes (HH:MM) format. Example: 0.8 (Decimal format) or 00:48 (HH:MM format) |
| InstructorName |
The instructor's first and last name. Example: Mark Wallace |
| InstructorComments |
The instructor’s notes on the event: Example: “BAI, Unusual Attitudes, IFR lost comm procedures.” These may also be placed in the “PilotComments” field. |
| Person1,2,... |
Other people on board the aircraft with their role for that flight. Choose from the following roles:
Format: Name;Role;Email. Example: Robert Hale;Student;Bob@example.com |
| PilotComments |
This is a standard text field to place the contents of “Comments,” “Remarks,” or other similar fields from a logbook. Example “Instrument checkride - PASSED!” |
| FlightReview | This is a true or false field. We suggest a simple ‘x’ if a flight review was conducted. The words 'true' or 'false' can also be used. |
| IPC |
This is a true or false field. If an instrument proficiency check was conducted, mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
| CheckRide |
This is a true or false field. If a successful checkride occurred, mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
| FAA61.58 |
This is a true or false field. If the flight qualifies under FAA's FAR 61.58, mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
| NVGProficiency |
This is a true or false field. If a Night Vision Goggles (NVG) proficiency check was conducted, mark it with an 'x' or use the word 'true.' Otherwise, leave the field blank or use the word 'false.' |
| CustomFields |
Custom Fields: Use this field to carry over any custom fields. Change the name and type of that field as appropriate. Choose from the following field types:
Format: [FieldType]CustomFieldName Example: [Hours]JumpPilot. |
Last Updated: