Pilot Logbook

Import flights (iOS)

Flights can be easily imported from a CSV file that you have created or downloaded. Alternatively, flights can be added and modified manually.

The CSV file

Your CSV file must contain a number of compulsory columns, and can optionally contain extra columns for Pilot Logbook to interpret. Column titles can be set to any value, but must match the values set in your Import Preferences. Data must be in the formats as specified.

Compulsory columns:

  • Date. Must be in a recognisable date format. A blank or incorrectly formatted cell will result in the row being overlooked.Examples of acceptable date formats:
    DD/MM/YYYY or MM/DD/YYYY depending on your location.
    DD.MM.YYYY or MM.DD.YYYY depending on your location.
    DD/MM/YY or MM/DD/YY depending on your location.
    DD.MM.YY or MM.DD.YY depending on your location.
    DD Month YYYY or Month DD YYYY
    DD Month YY or Month DD YY
  • Departure time. Must be in format hh:mm or hhmm UTC. A blank cell will default to 00:00.
  • Arrival time. Must be in format hh:mm or hhmm UTC. A blank cell will default to Departure time.
  • Departure airport. Should be an ICAO or IATA code. A blank cell will require manual input later.
  • Arrival airport. Should be an ICAO or IATA code. A blank cell will require manual input later.
  • Aircraft registration. Any text. A blank cell will require manual input later.
  • Pilot 1 (in command) Should be either a First and Last name or a Last and First name separated by a space. A blank cell will require manual input later.

Optional columns:

  • Flight number. Any text. A blank cell will be overlooked.
  • Aircraft type. Type code. A blank cell will be overlooked.
  • Pilot 2. Should be either a First and Last name or a Last and First name separated by a space. A blank cell will be overlooked.
  • Pilot flying. Must be true or false. A blank cell will be overlooked. An error will occur if any other value is present.
  • Additional time columns (Total, PIC, PICUS, SIC, Dual, Instructor, Solo, IFR, Night, Instrument, Cross-country, Simulator) Must be hh:mm or hhmm (PIC, SIC, Dual and Simulator also support true/false). A blank cell will be overlooked. An error will occur if any other value is present.
  • Take-off/landing day/night Columns. Any whole number. Any other value will be ignored.

Import settings

Before importing flights you must choose your import settings so that Pilot Logbook can read and interpret your CSV file. If import settings do not match correctly your import will result in an error.

  1. In the Pilot Logbook app on your iPhone or iPad, select Import Settings from the Settings tab in the bottom bar or from the navigation sidebar.
  2. Modify your Data Options settings:
    • Airport Format: Select whether airports in your CSV file are listed by ICAO or IATA code.
    • Name Format: Select whether pilot names in your CSV file are listed in order First to Last or Last to First.
    • Night Time: Select whether you want to use Pilot Logbook to automatically calculate night time from the imported flight details. Alternatively you can provide a column for night time in your CSV file, or default night time to zero.
  3. Modify your Compulsory Columns titles:
    • Write the titles of the compulsory columns exactly as they appear in your CSV file.
  4. Modify your Optional Columns:
    • Click the Add a Column… button to add extra optional columns that you want Pilot Logbook to include from your CSV file.
      Your CSV file can have extra columns that Pilot Logbook will ignore, you don’t have to choose to include them all here.
    • To delete an optional column swipe and click the Delete button.
    • For the added optional columns write the titles exactly as they appear in your CSV file.
    • If you have selected Flight Number you can optionally include a prefix. Whatever text you enter here will be saved in front of every flight number value in your CSV file.
    • Some time columns (PIC, SIC, Dual and Simulator) allow you to specify time or bool. If your data is in time format select Time, if your data is true/false select Bool.

Import the CSV file

Make sure you have read the guidance on the required structure of your CSV file and have set your import preferences before importing.

  1. In the Pilot Logbook app on your iPhone or iPad, select Flights in the bottom bar or from the navigation sidebar.
  2. Click the Import button in the top toolbar. 
  3. Select your file and click the Open button.
    • A list will load that displays the imported flights. The import button will change appearance to a spinning wheel while the file is processed. This may take some time if the CSV file has a large amount of data.
      If an error message is displayed check your import preferences and your CSV file.
    • Only flights that have not been previously added will be imported.

Modify and save imported flights

The imported flights from your file will be displayed. You can add missing information and make changes before saving the flights to your logbook. Imported flights that have required and missing information are presented at the top of the table and are highlighted blue.

  1. You may choose not to import certain flights by selecting them and clicking the Delete button. These flights will not be saved to your logbook.
  2. Each flight to be saved must have entered a Date value, entered times in the Departure(UTC) and Arrival(UTC) fields, an Aircraft and a pilot as Pilot 1 selected.
    Follow the guidance on adding flight details.
  3. When you are happy with the import, and no flights that you want to save remain highlighted blue, click the Save button. The imported flights will be saved to your logbook as well as any added aircraft, pilots and airports.

See also