Logbook CSV Import
The version 4 CSV template has changed slightly from the version 3 template. Route, Distance, and Remarks are now default logbook fields (but are not required).
You Have Options
If filling out a template sounds like a lot of work, remember that you have other options that will take a lot less time:
- Total Summary — Add a small number of entries that contain the totals from your previous logbook (divided, perhaps, by aircraft category), and don't bother entering individual entries. In many cases, just having the totals is sufficient.
- Yearly Summary — Enter a single logbook entry for each year you have flown and use the total for that year as the duration for the entry.
- Copy and Paste — Generate a CSV export with your previous logbook and copy and paste the relevant columns into our template.
Step 1: Download the Template
Get our CSV template that you can open in either Excel or Numbers.
- Columns Are Picky — Only the custom field columns indicated in the CSV template can be changed (reordered, added, deleted, renamed, etc.). Everything else must stay where it is.
- European Languages — If you use a computer with something other than English set as the language, it's possible that Excel will export your logbook with semi-colons as the separator instead of a comma. If you're on a Mac, you can check this in System Preferences > Language & Region > Advanced.... The number separator must be set to comma or else our CSV importer won't be able to read your file.
Step 2: Aircraft
When entering your aircraft, please keep a couple things in mind:
- Category/Class — The possible aircraft categories are listed on a separate tab in the Excel/Numbers template. You can only use the ones listed in the template. Here they are for your reference: Airplane Single-Engine Land, Airplane Single-Engine Sea, Airplane Multi-Engine Land, Airplane Multi-Engine Sea, Helicopter, Multi-Engine Helicopter, Gyroplane, Airship, Balloon, Simulator, Flight Training Device, Glider, Powered Lift, Powered Parachute, Weight-Shift Control, Other
- Custom Fields — You can have either yes/no or text custom fields with aircraft. Most of the time, you'll use the yes/no variety since they typically attributes of an aircraft (like tailwheel, complex, high performance, etc.).
Step 3: Logbook Entries
By the time you have gotten this far in the template, hopefully you are getting the hang of how it works. There are just a few formatting tips for this section:
- Flight Date — Always use the MM/DD/YYYY format. For example, January 5, 2018 would be: 01/05/2018
- Aircraft Registration — This must match the "N number" of an aircraft up in your aircraft list. Otherwise, your logbook will show "No Aircraft" for that logbook entry.
- Airports — You can use either the IATA or the ICAO airport code in Departure, Destination, and Route, but we recommend using ICAO (e.g. KLAX instead of LAX).
- Duration — This can either be #.# or HH:MM format. Example: 3.5 or 3:30
- Distance — This can only be in nautical miles (or just leave it blank)
- Custom Fields — You can have, yes/no, flight time, or text custom fields with logbook entries. Most of the time, you'll use the flight time variety (like PIC, Cross Country, Instrument, etc.). Flight time values can be either #.# or HH:MM.
If you can't get your CSV file to import, please email us your CSV file and we'll do our best to get things on track.
Otherwise, head over to our CSV import tool and get started.