Skip to main content
The Operations module must be enabled for your workspace. You also need the appropriate operations permissions. Contact your workspace administrator if you cannot access these features.
You can import multiple trips at once from a CSV file instead of creating each trip manually. This is useful when migrating from another system, importing a season’s schedule, or loading historical trip data.

​
File Format Requirements

PlaneConnection accepts CSV files with the following column structure. Column headers must match exactly (case-insensitive).
Download a sample CSV template from the import page to see the exact format and column names expected.

​
Import Workflow

​
Validation and Error Handling

The import process validates the following before creating trips:
Rows with warnings are still imported — the system creates the trip without the unmatched reference (aircraft, crew). You can assign these manually after import from the trip detail page.

​
Bulk Import Best Practices

Import 5-10 trips first to verify your CSV format and column mapping. Review the results before importing a full season or historical dataset.
Import trips with status set to draft (the default). This gives dispatchers a chance to review, assign aircraft and crew, and confirm each trip individually.
Cross-reference your airport codes against the PlaneConnection airport database. Common issues include using IATA codes (e.g., TEB instead of KTEB) or codes for airports not in the system.
Each row in the CSV creates a single-leg trip. For multi-leg trips, import each leg as a separate row with the same trip_number. The system groups legs under the same trip when they share a trip number.
When importing historical trips, set the status to completed only if the trip has already been flown. Include actual departure and arrival times for accurate historical reporting.

Create a Trip

Create trips manually with the trip wizard.

Trip Statuses

Understanding trip lifecycle statuses after import.

Manage Aircraft

Ensure aircraft records exist before importing trips with aircraft assignments.

Manage Crew

Set up crew members before importing trips with crew assignments.
Last modified on April 11, 2026