Logbook import templates

Simple logbook import

Import your flights with a straightforward CSV template built for standard logbook entries.

Includes columns for:

date, departure, arrival, registration, flight number, block time, off-block, on-block, takeoff, landing, takeoff and landing counts, crew, aircraft type, training, notes, and remarks.

Use this template if you want a clean import format without separate day and night counts.

Instructions

1. Download the template.
2. Open it in Excel, Google Sheets, or Numbers.
3. Replace the example rows with your own flights.
4. Keep the column names exactly as they are.
5. Enter times in a consistent format across the file.
6. Save the file as a UTF-8 CSV.
7. Upload the completed file to Aviato.

Day and night counts import

Import flights with separate day and night takeoff and landing counts for each leg.

Includes the same core fields as the simple template, plus:

day takeoffs, day landings, night takeoffs, and night landings.

Use this template if you track day and night operations separately for currency, recency, or compliance.

Instructions

1. Download the template.
2. Open it in Excel, Google Sheets, or Numbers.
3. Replace the example rows with your own flights.
4. Keep the column names exactly as they are.
5. Fill in day and night counts in the correct columns for each flight.
6. Leave unused optional fields blank rather than deleting columns.
7. Save the file as a UTF-8 CSV.
8. Upload the completed file to Aviato.

AI-assisted import

Use AI to help convert flight records from another format into the Aviato import template.

This works best for exports from other logbooks, airline reports, roster files, spreadsheets, or copied tables that do not already match the Aviato column layout.

What it does

AI helps map your existing columns into the correct Aviato format, clean up headings, and structure the data so it is ready for import.

Use this when

• your file uses different column names
• your data is in the wrong order
• your export includes extra columns
• your file needs light cleanup before import

Instructions

1. Download the Aviato template that matches your needs.
2. Open ChatGPT or another AI tool.
3. Upload your original file and the Aviato template.
4. Paste this prompt:

   Convert my file into the same column structure as the attached Aviato template. Keep one row per flight leg. Preserve all available flight data. Do not rename Aviato columns. Leave blank any fields that cannot be confidently filled. Return the final result as CSV-ready data.

5. Review the output carefully.
6. Check dates, times, airport codes, registrations, and takeoff or landing counts.
7. Save the final file as a UTF-8 CSV.
8. Upload it to Aviato.

Important

AI can help restructure data, but you are still responsible for checking accuracy before import.