Import

The import feature lets you bring flight data from other sources into AirTrail. AirTrail can import flights from MyFlightradar24, App in the Air, JetLog, TripIt (ICS), Flighty, byAir, JetLovers, OpenFlights, Miles & More, and AirTrail JSON files.

First export your data from the source, as described in its section below. Then import the file into AirTrail.

Importing a fileCopy Anchor Link

Open Settings > Import. The page is available to users whose role includes the flight.import.own permission. The import runs in steps:

1. Source: Select the platform the file comes from, then click Next. Each option lists the file type it expects.
2. File: Click the upload area and select the file, then click Next. Supported file types are CSV, TXT, JSON, and ICS, up to 5 MB.
3. Options: Review the options below, then click Import.
4. Users: Shown only for AirTrail files. See AirTrail JSON files.
5. Status: Review the result.

OptionsCopy Anchor Link

Which options appear depends on the source.

• Match airline from flight number: Fills in the airline from the flight number prefix. Shown for App in the Air, JetLog, TripIt, byAir, JetLovers, and OpenFlights. On by default.
• Only import your flights: Skips flights that the file marks as belonging to someone else. Shown for App in the Air and byAir. Off by default.
• Restore flights for all mapped users: Instance restore for AirTrail files. See AirTrail JSON files.
• Deduplicate imported flights: On by default. A flight that matches one you already have, with the same date, route, flight number, registration, and times, is not imported twice. Instead, AirTrail fills in a missing airline, aircraft, or track on the existing flight from the file.

Import statusCopy Anchor Link

The last step shows how many flights were imported or updated, and lists problems:

• Skipped rows could not be parsed. The browser console has the details.
• Validation errors list flights that the server rejected, with the reason.
• Unmatched items are airport, airline, or aircraft codes that AirTrail could not find.

To handle unmatched items, pick the matching airport, airline, or aircraft for each code, then click Import Remaining Flights. Flights with an unmatched airport cannot be imported until the airport is mapped. Unmapped airlines and aircraft are left blank. If your role can manage airports, airlines, or aircraft, you can also create a missing one from here. Search OurAirports opens OurAirports to help find an unknown airport.

Click Leave Remaining Unimported to skip the rest, or Done when nothing is left. Imported flights appear on the map right away.

MyFlightradar24Copy Anchor Link

While logged in to your MyFlightradar24 account:

1. Go to the MyFlightradar24 website.
2. Click the "Settings" button in the top right corner.
3. Open the "Export" tab.
4. Click "Download CSV" to download your flights as a CSV file.

Import the file with the FlightRadar24 source.

App in the AirCopy Anchor Link

1. Open the App in the Air app on your device.
2. Go to the "Profile" tab.
3. Go to "Settings".
4. Under "Other", tap "Export data". You receive your flights by email as a text file.

Import the .txt file with the App in the Air source. Enable Only import your flights to skip flights that App in the Air does not mark as yours.

JetLogCopy Anchor Link

1. Go to your JetLog instance.
2. Open the "Settings" page in the top right corner.
3. Click "Export to CSV" to download your flights as a CSV file.

Import the file with the JetLog source.

TripIt (ICS)Copy Anchor Link

TripIt can export trip details as an ICS calendar file:

1. Open TripIt on the web and navigate to your trip.
2. Use the Export/Calendar option to download the trip as an .ics file.

Import the file with the TripIt (ICS) source.

Notes and limitations:

• All-day trip header events (VALUE=DATE) are ignored. Only flight events are imported.
• Flight events are detected when the SUMMARY looks like "SK2535 CPH to BHX" (airline and flight number, origin IATA code, destination IATA code).
• Times are parsed from DTSTART and DTEND. UTC (Z) and TZID times are supported.

FlightyCopy Anchor Link

1. Open the Flighty app on your device.
2. Go to the "Profile" tab.
3. Tap "Settings" (gear icon).
4. Scroll down to the "Manage" section and tap "Account Data".
5. Choose "Export Your Flights".
6. Share or save the CSV file to your device.

Import the file with the Flighty source.

byAirCopy Anchor Link

1. Open the byAir app.
2. Go to the "Profile" tab.
3. Scroll down to the "Help" section and tap "Export data".
4. Enter your email address and tap "Export". You receive a CSV file by email.

Import the file with the byAir source. Enable Only import your flights to skip flights that byAir does not mark as yours.

JetLoversCopy Anchor Link

1. Open JetLovers.
2. Go to "My flights".
3. Click "CSV Export".

Import the file with the JetLovers source.

OpenFlightsCopy Anchor Link

1. Open OpenFlights.
2. Go to Settings.
3. Click "Backup to CSV" to download the CSV file.

Import the file with the OpenFlights source.

Miles & MoreCopy Anchor Link

Miles & More (Lufthansa Group's frequent-flyer program) doesn't offer a self-service export button, but it exposes your own flight history as JSON through an authenticated API endpoint you can open directly in your browser while logged in.

1. Log in to your account at miles-and-more.com.
2. In the same browser, open https://api.travelid.lufthansa.com/flightstats/v3/me/segmentList?departureDateRange=10000%20months&size=10000&page=0.
3. Save the JSON response shown in your browser as a .json file (for example with "Save Page As" or your browser's developer tools).

Import the file with the Miles & More source.

Notes and limitations:

• Fare and booking class letters (for example F, C, M) are mapped to AirTrail's seat class on a best-effort basis and may not be accurate for every operating carrier. Double-check imported seat classes.
• Aircraft types are matched from Miles & More's IATA type codes against a built-in lookup table. Uncommon types may not be recognized. They are left blank unless you map them in the import status step.
• The PNR and Miles & More loyalty numbers (award and status miles, status, GUP, and HON points) have no equivalent field in AirTrail and are appended to the flight's note instead.

AirTrail JSON filesCopy Anchor Link

Use the AirTrail source for JSON files from the AirTrail export, and AirTrail (pre-v3) for exports made with AirTrail versions before v3.

AirTrail exports list the users on each flight, so the AirTrail source adds a Users step after Options. AirTrail offers two import modes:

• Personal import is available to every user who can import. In the Users step, select the account in the export that belongs to you, then click Continue Import. AirTrail imports only that account's flights and adds other passengers as guests.
• Instance restore requires a role with the flight.import.any and users.directory.read permissions. Enable Restore flights for all mapped users in the Options step. In the Users step, map each exported user to a local user. Unmapped users are imported as guests. Restore preserves user assignments and deduplicates against every flight on the instance.

AirTrail treats uploaded files as untrusted. The server rejects personal imports that assign flights to another local user, even if the file or client requests those assignments.

Flight tracks in the file are restored. Custom field values are included in exports for reference but are not restored during import.