How To Format a Spreadsheet for Import

Follow

Pilot flight time information is often available in a spreadsheet file (.xls, .numbers, .csv etcetera) from an employer's crew scheduling software, other electronic logbook applications, or from home-made logbook files using spreadsheet applications.

Transcribing entries from a paper logbook into a simple spreadsheet can be very efficient. You can then send this file to Coradine Support for import into LogTen Pro, or import the file yourself. A simple template for transcription is available to download here.

LogTen Pro's method of importing data is extremely flexible, so basically any spreadsheet format can be imported without much trouble. Here are some tips to end up with the best possible import:

Use a Separate Column for Each Data Point

LogTen Pro has data fields for nearly everything, and you can use custom fields for anything else. If you enter data in your Remarks (approaches, holds, etc.), transfer this data into its own column.

Consistent Date Format 

It is difficult to verify date formats after they're entered, so it is important to use the same date format throughout the whole document for the best import. Any standard date format is acceptable though, e.g. dd/MM/yy, yyyy-MM-dd, MM/dd/yy). Remove any empty dates as they will be imported as blank flights.

Consistent Time Format

Times must be in the same format, whether decimal (0.0), two decimal (0.00), hh:mm (00:00), or hh+mm(00+00).  

Separate Route Column

Some logbook formats include the Route information in the Remarks/Notes column, but it'll be much easier to import if the Route info is entered as its own column.

Consistent Route Format

Entering each airport separated by a dash. Individual From/To columns are fine as well. ICAO airport codes should be in a full four-character format (i.e. continental US airports start with a "K"). ICAO codes import more accurately than IATA.

Use a Single Tab in a Single File

Do not separate months or years of entries by tabs or worksheets. Multiple files can be combined, but it will save time if all the information is in one spreadsheet file.

Aircraft Category/Class and Engine Type Columns are Not Necessary 

LogTen Pro calculates times such as multi-engine land and turbo-prop by using information from the Aircraft Type. You do not need a separate column for this information. Please see Overview of Types Tab for iPhone + iPad or Overview of Types Tab for Mac for more information. Consider using ICAO Aircraft Type Designators. This will enable LogTen Pro to utilize it's built-in database to auto-complete information for the Aircraft Type.

Additional assistance with this or any other LogTen Pro issue is available here or by contacting support in the app by going to More > Help > Contact Support.

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.