# Importing Your Previous Logbooks

{% hint style="info" icon="star" %}
This a PRO feature. Subscribe [here](https://logbook.waderaviation.com/import).
{% endhint %}

Wader PRO users can bring their complete flight history from another app or airline system in a few clicks. 

This page lists which formats are currently supported and how to get your file ready.

## How the import works

1. **Check supported formats** below — find your logbook app or airline system
2. **Follow the instructions** for your format to export the correct file
3. **Subscribe to PRO** to have access to the Import Logbook feature within the app or to be able to use the auto-upload by email.
4. **Submit your file** through your preferred method.
   1. **Via mobile app:** go to **More → Import Logbook**, select the file source and upload the file.
   2. **Via web app:** go to **Import** in the lateral menu, select the file source and upload the file.
   3. **Via email:** forward the file to **\[airline]@wader.pro** using your email associated with your Wader account.
      1. You may use IATA, ICAO or airline name, and the system will properly identify it). Example: <ad@wader.pro>, <azu@wader.pro> or <azul@wader.pro>.&#x20;
      2. If you are unable to find yours, hit us via the in-app Support Hub and our team will help you.
5. Your file is processed **automatically\*** and you are notified by email once it is completed.

**\****Some formats may still be handled manually by our team, while automation is not completely implemented, but are processed within 2 business days*

{% hint style="warning" icon="circle-exclamation" %}
Imports are processed **as-is** based on the data you provide. Please review your file carefully before submitting — errors or missing information will need to be corrected manually in the app after import.
{% endhint %}

***

## Supported Formats

### Electronic Logbooks

<details>

<summary>LogTen Pro</summary>

Before exporting, make sure your settings are correct: go to **Account → Settings → Display Options**, set **Time Format** to **Hours:Minutes**, and confirm that **Use Zulu (UTC) Time** is enabled.

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FGkPrYPaWmC89PwfPB9JI%2FIMG_9A75C565AF05-1.jpeg?alt=media&#x26;token=7e64c17e-f1d6-45e0-9579-62999e888585" alt="" data-size="original">

Then go to the **Reports tab** of your LogTen application (available in both mobile and desktop), select **Exporters**, and generate the **Export Flights (Tab)** report. Make sure to select this report — not the Dynamic Export Flights.

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FdD3j9DU4mDN3xzY66Wqr%2Flogten_1.jpeg?alt=media&#x26;token=8e6c289c-effb-4b17-809c-1e42e2c182d1" alt="" data-size="original"> <img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FP2se7pGMjZwj5uBvYvgw%2Flogten_2.jpeg?alt=media&#x26;token=5ac7f5d0-2e75-45f0-966b-a13f5eaa34b1" alt="" data-size="original"> <img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FYHRyDVTffqCjPDNFEwVt%2Flogten_3.jpeg?alt=media&#x26;token=ea6e09fe-094c-497f-b1f0-70d83599dec1" alt="" data-size="original">

</details>

<details>

<summary>mcc / crewLounge PILOTLOG</summary>

**myCrewLounge portal:** Go to your profile and select the option to export your database records from PILOTLOG as **CSV** and **JSON** files.

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2F4R5XL8OKfeZxrJ137mJ4%2FcrewLounge.png?alt=media&#x26;token=e4513a00-e0b4-4a7a-b637-1bf7bfe37ac0" alt="" data-size="original">

**Old mccPILOTLOG desktop app:** Go to the Query tab, define a date range (or leave it blank), and click Search. Select the option to Export Data and save the report as CSV (or Excel if CSV is not available).

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2Fg9Eog07IULGPsOukJkS1%2Fmcc-screen-1.png?alt=media&#x26;token=cc78cd3c-c279-454e-9dad-ec533985a72b" alt="" data-size="original"> <img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FgHHkFBhAhoB7ePOvbPXY%2Fmcc-screen-2.png?alt=media&#x26;token=4c40755c-ca01-459f-95a0-01f3020ca2a3" alt="" data-size="original"> <img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FdRITjdbbbhh2uaOlRp4R%2Fmcc-screen-3.png?alt=media&#x26;token=7e60375c-93bc-4ccd-bec5-ca97146bada0" alt="" data-size="original">

</details>

<details>

<summary>RB Logbook</summary>

Go to the **More tab** in RB Logbook, select **Import & Export Data**, and look for **Export to CSV**. Define the period you want to import and generate all available report types: **Flights, Aircraft, and People**. We need all three files.

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FBe0ziXGBYHw1UT115cUJ%2FRB%20import_1.jpeg?alt=media&#x26;token=977eff5e-cb80-4008-bbb5-294c5be706d6" alt="" data-size="original"> <img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FGnDlXuQKOygWSJa91qer%2FRB%20import_2.jpeg?alt=media&#x26;token=1daedc74-6ffe-4119-b447-f1d54d84f069" alt="" data-size="original"> <img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FGIjLfCblKFBoo9uDZLk4%2FRB%20import_3.jpeg?alt=media&#x26;token=a7658c09-59ac-4ec2-9b9c-4c0ba270be4b" alt="" data-size="original">

</details>

<details>

<summary>Others</summary>

If you have your hours in a digital logbook not listed above, you can transpose your records to our [standard spreadsheet template](#standard-spreadsheet) or contact our PRO support team via the app, so we can evaluate including it.

</details>

***

### Airline Systems

<details>

<summary>🌐 AIMS / eCrew</summary>

**AIMS eCrew (Legacy)**

1. Log in to AIMS eCrew in your browser
2. On the *Pilot LogBook* report page, select your dates and click **Export as CSV**
   * If that button is not available, right-click the report and use *Save Target As* to save as an HTM file

**AIMS-v2 eCrew**

1. Log in to AIMS eCrew in your browser
2. Go to **Reports → My Logbook**, select your dates, and click **Go**
3. From the *File Export* menu, select **CSV**

</details>

<details>

<summary>🇧🇷 ANAC (SACI)</summary>

1. Log in to the ANAC system at [sistemas.anac.gov.br/SACI](https://sistemas.anac.gov.br/SACI/)
2. In the left menu, select **CIV → Declaração de Experiência de Voo**
3. At the bottom of the page, find the export option

This generates an .xlt file that can be opened with any spreadsheet application (Excel, Google Sheets, etc.).&#x20;

{% hint style="warning" %}
Make sure to upload the original (unaltered) file.
{% endhint %}

</details>

<details>

<summary>🇷🇺 Aviabit</summary>

Export your logbook from Aviabit in **CSV** format.

{% hint style="warning" %}
Make sure the exported file includes **Block ON and Block OFF times** — these are essential for a proper import. If your file is missing this data or contains inconsistencies (such as Instrument Time exceeding total Duty Time), consider transferring your data to our [standard spreadsheet template](#standard-spreadsheet) to fill in any gaps before submitting.
{% endhint %}

</details>

<details>

<summary>🇪🇸 Air Europa</summary>

Go to your **Casillero Digital** app and tap **Logbook**:

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2F6xGWCQZGf3MhTSjp3Al4%2Faireuropa1.jpeg?alt=media&#x26;token=adbb8b1c-74d2-4589-85b8-395fc3c93523" alt="" data-size="original">

Set the date range and select export format **"Recommended for Logten Pro X"**:

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FJrL4daMvdNR8fTWBTv36%2Faireuropa2.jpeg?alt=media&#x26;token=9bc1a01d-b758-472c-8bd8-b4e915ae30e6" alt="" data-size="original">

You will receive the file in your corporate email.

{% hint style="warning" %}
If you opt to use the auto-upload via email, note that forwarding from **Apple Mail**, the CSV file may be embedded in the email body instead of attached and the import will not work. Use **Gmail** or **Outlook** instead to forward it to ensure the attachment is preserved.
{% endhint %}

</details>

<details>

<summary>🇦🇪 Air Arabia</summary>

Log in to the Air Arabia **Cesar web portal** and generate the **Electronic Log Book** file in Excel (.xls) format.

{% hint style="info" %}
Air Arabia's system sometimes links the wrong aircraft type to a tail number. Our import process automatically corrects this using the aircraft registration. If you spot any remaining issues after import, let us know.
{% endhint %}

</details>

<details>

<summary>🇧🇷 Azul Linhas Aéreas</summary>

Request your logbook by opening a **Service Now** request with Azul. Once you receive it, submit the **CSV** **(preferred)** or the **PDF** file.

{% hint style="info" %}
Azul Conecta uses a different format that is currently not supported. In that case, the [standard spreadsheet](#standard-spreadsheet) is the best option.
{% endhint %}

</details>

<details>

<summary>🇦🇪 Emirates</summary>

1. Log in to the EK portal
2. Go to **All Apps → Flight Time Report**
3. Load the period you want to import
4. Click the **Download Spreadsheet** button (top-right corner of the table)

Submit the downloaded Excel file.

</details>

<details>

<summary>🇧🇷 GOL Linhas Aéreas</summary>

Get your monthly reports from **CrewLink**: go to the portal, select **FT Record** in the side menu, select the desired month, and click **Generate Report**. Download each monthly report and submit them all.

<img src="https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FmwZBCx9R7vpUDHxfq5rj%2FCaptura%20de%20tela%202024-02-24%20224155.jpg?alt=media&#x26;token=09b3b667-38c1-4a2a-90de-b22a1100ff17" alt="" data-size="original">

{% hint style="warning" %}
The consolidated file from the roster ("ESCALA") **cannot** be used — it does not include mandatory logbook information such as aircraft registration.
{% endhint %}

</details>

<details>

<summary>🇧🇷 LATAM Airlines Brasil</summary>

LATAM may provide you with a PDF logbook directly. Just make sure it is the original file, and not a regenerated printed PDF (which may not be readable).

{% hint style="info" %}
LATAM Cargo uses a different format that is currently not supported. In that case, the [standard spreadsheet](#standard-spreadsheet) is the best option.
{% endhint %}

</details>

<details>

<summary>🇲🇻 Trans Maldivian Airways</summary>

Go to the **RAMIS system** and export your flights in Excel format.&#x20;

{% hint style="warning" %}
Make sure to upload the original (unaltered) file.
{% endhint %}

</details>

<details>

<summary>Others</summary>

If your airline system provides you with all required logbook information in a different format, submit a request via the in-app Support Hub and the team will evaluate whether it can be imported.

</details>

***

## Standard Spreadsheet

If your format is not listed above, you can transpose your records into our template:

{% file src="<https://3440297477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Famix6flPIe1pzcyRPQy5%2Fuploads%2FY0Q1vKQUIbyWLx9rqzOa%2Fwader-import-template.csv?alt=media&token=599bbaf8-0d72-4d56-9900-12084a2b2507>" %}
Download spreadsheet template
{% endfile %}

**Follow the field specifications below exactly — incomplete or incorrectly formatted files cannot be imported.**

| Field                     | Status                                           | Description                                                                                                                                                 |
| ------------------------- | ------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `flightDate`              | <mark style="color:red;">(required)</mark>       | Date of the flight in `YYYY-MM-DD` format (e.g. `2023-06-15`)                                                                                               |
| `aircraftIata`            | <mark style="color:orange;">(recommended)</mark> | IATA aircraft type code (e.g. `738` for Boeing 737-800)                                                                                                     |
| `aircraftIcao`            | <mark style="color:orange;">(recommended)</mark> | ICAO aircraft type code (e.g. `B738`). At least one of `aircraftIata` or `aircraftIcao` should be provided                                                  |
| `flightNumber`            | <mark style="color:yellow;">(optional)</mark>    | Flight number (e.g. `LA1234`). Do not include the airline prefix if it is already in the field                                                              |
| `aircraftTailnumber`      | <mark style="color:orange;">(recommended)</mark> | Aircraft registration / tail number (e.g. `PT-MSY`). Used to identify the specific aircraft                                                                 |
| `depAirport`              | <mark style="color:red;">(required)</mark>       | ICAO or IATA code of the departure airport (e.g. `SBGR` or `GRU`)                                                                                           |
| `arrAirport`              | <mark style="color:red;">(required)</mark>       | ICAO or IATA code of the arrival airport (e.g. `SBSP` or `CGH`)                                                                                             |
| `timeReference`           | <mark style="color:red;">(required)</mark>       | Timezone reference for all time fields. Use `UTC` for Zulu time, or a UTC offset such as `UTC-3` or `UTC+1`                                                 |
| `baseAirport`             | <mark style="color:yellow;">(optional)</mark>    | ICAO or IATA code of your home base airport. Used to calculate cross-country time if not provided separately                                                |
| `startTime`               | <mark style="color:orange;">(recommended)</mark> | Block-off time (chocks removed / pushback) in `HH:MM` format                                                                                                |
| `takeoffTime`             | <mark style="color:orange;">(recommended)</mark> | Wheels-off time in `HH:MM` format                                                                                                                           |
| `landingTime`             | <mark style="color:orange;">(recommended)</mark> | Wheels-on time in `HH:MM` format                                                                                                                            |
| `parkingTime`             | <mark style="color:orange;">(recommended)</mark> | Block-on time (chocks in / engines off) in `HH:MM` format                                                                                                   |
| `totalTime`               | <mark style="color:red;">(required)</mark>       | Total flight time (block-to-block) in decimal hours (e.g. `1.5`) or `HH:MM` format (e.g. `1:30`)                                                            |
| `stickTime`               | <mark style="color:yellow;">(optional)</mark>    | Time at the controls (airborne time) in decimal hours or `HH:MM`                                                                                            |
| `nightTime`               | <mark style="color:yellow;">(optional)</mark>    | Night flying time in decimal hours or `HH:MM`                                                                                                               |
| `actualInstrumentTime`    | <mark style="color:yellow;">(optional)</mark>    | Actual IMC time in decimal hours or `HH:MM`                                                                                                                 |
| `simulatedInstrumentTime` | <mark style="color:yellow;">(optional)</mark>    | Simulated instrument time (hood / foggles) in decimal hours or `HH:MM`                                                                                      |
| `crossCountryTime`        | <mark style="color:yellow;">(optional)</mark>    | Cross-country time in decimal hours or `HH:MM`. If omitted, Wader will calculate it automatically based on `baseAirport`                                    |
| `takeoffs`                | <mark style="color:yellow;">(optional)</mark>    | Total number of takeoffs (day + night). If omitted, defaults to `1`                                                                                         |
| `landings`                | <mark style="color:yellow;">(optional)</mark>    | Total number of landings (day + night). If omitted, defaults to `1`                                                                                         |
| `dayTakeoffs`             | <mark style="color:yellow;">(optional)</mark>    | Number of daytime takeoffs                                                                                                                                  |
| `nightTakeoffs`           | <mark style="color:yellow;">(optional)</mark>    | Number of night takeoffs                                                                                                                                    |
| `dayLandings`             | <mark style="color:yellow;">(optional)</mark>    | Number of daytime landings                                                                                                                                  |
| `nightLandings`           | <mark style="color:yellow;">(optional)</mark>    | Number of night landings                                                                                                                                    |
| `approachType`            | <mark style="color:yellow;">(optional)</mark>    | Type of instrument approach flown (e.g. `ILS`, `RNAV`, `VOR`, `NDB`). Use one value per flight; if multiple approaches were flown, use the most significant |
| `function`                | <mark style="color:red;">(required)</mark>       | Pilot function / role. Accepted values: `PIC`, `SIC`, `FO`, `Relief`, `Instructor`, `Student`, `Examiner`, `Deadhead`, `Observer`                           |
| `ifrTime`                 | <mark style="color:yellow;">(optional)</mark>    | Total IFR time in decimal hours or `HH:MM`                                                                                                                  |
| `multiPilot`              | <mark style="color:yellow;">(optional)</mark>    | Multi-crew / multi-pilot time in decimal hours or `HH:MM`                                                                                                   |
| `pilotName1`              | <mark style="color:orange;">(recommended)</mark> | Full name of the other crew member in the primary crew position (e.g. Captain if you are FO). Used for logbook crew records                                 |
| `pilotName2`              | <mark style="color:yellow;">(optional)</mark>    | Full name of an additional crew member                                                                                                                      |
| `pilotName3`              | <mark style="color:yellow;">(optional)</mark>    | Full name of an additional crew member                                                                                                                      |
| `pilotName4`              | <mark style="color:yellow;">(optional)</mark>    | Full name of an additional crew member                                                                                                                      |
| `remarks`                 | <mark style="color:yellow;">(optional)</mark>    | Free-text remarks or notes for the flight entry                                                                                                             |
| `isSimulator`             | <mark style="color:yellow;">(optional)</mark>    | Set to `true` if this entry is a simulator session rather than an actual flight. Defaults to `false`                                                        |
| `qualificationLevel`      | <mark style="color:yellow;">(optional)</mark>    | Simulator qualification level, if applicable (e.g. `FFS`, `FTD`, `FNPT`). Only relevant when `isSimulator` is `true`                                        |