Skip to main content

Import Issues

Common problems when importing CSV files and how to fix them.

File Won't Upload​

Check File Format​

  • Must be .csv format
  • Use comma (,) as delimiter
  • UTF-8 encoding recommended
  • No extra blank rows at end

File Size Issues​

  • Keep under 10MB
  • Split large files into smaller batches
  • Remove unnecessary columns
  • Delete duplicate entries

Browser Problems​

  • Try different browser
  • Disable browser extensions
  • Clear cache and cookies
  • Allow pop-ups for SkyJourney

Missing Data After Import​

Required Fields​

Check your CSV has these columns:

  • flight_number or Flight
  • date or Date
  • departure or From
  • arrival or To

Column Name Variations​

SkyJourney accepts multiple formats:

  • Date: date, Date, flight_date
  • Flight: flight_number, Flight, flight
  • Airports: from, departure, origin / to, arrival, destination

Empty Cells​

  • Fill in missing required fields
  • Use "N/A" or "Unknown" for optional fields
  • Check for hidden characters
  • Remove extra spaces

Incorrect Data After Import​

Date Format Issues​

Supported formats:

  • YYYY-MM-DD (2024-01-15)
  • MM/DD/YYYY (01/15/2024)
  • DD-MM-YYYY (15-01-2024)

Fix: Use consistent date format throughout file

Time Format Problems​

  • Use 24-hour format: 14:30
  • Or AM/PM: 2:30 PM
  • Include colon separator
  • Match timezone if specified

Airport Codes​

  • Use 3-letter IATA codes (JFK, LAX, LHR)
  • All uppercase
  • No spaces
  • Check spelling

Aircraft Type​

  • Use ICAO codes (B738, A320, B77W)
  • Or full names (Boeing 737-800)
  • Capitalize correctly
  • Remove special characters

Format Errors​

"Invalid CSV Format"​

Problem: File structure incorrect

Solutions:

  • Open in Excel/Numbers, save as CSV
  • Check delimiter is comma
  • Remove merged cells
  • Delete formatting

"Header Row Not Found"​

Problem: Missing or incorrect column headers

Solutions:

  • First row must be column names
  • Use supported column names
  • No blank first row
  • Check spelling

"Duplicate Entries"​

Problem: Same flight imported multiple times

Solutions:

  • Remove duplicate rows
  • Check flight number + date combination
  • Clean data before import
  • Use unique identifier

Import Speed Issues​

Large Files Taking Too Long​

  • Import in smaller batches (500 rows max)
  • Remove unnecessary columns
  • Close other applications
  • Check internet speed

Import Freezes​

  • Refresh page and retry
  • Reduce file size
  • Clear browser cache
  • Try incognito mode

Data Not Appearing​

After Successful Import​

  1. Refresh the page
  2. Check date filters
  3. Verify correct account/logbook
  4. Look in "Recent Flights"

Partial Import​

  • Check error log
  • Verify which rows failed
  • Fix errors in CSV
  • Re-import failed rows only

Export and Re-import​

Clean Existing Data​

  1. Export current data as backup
  2. Fix issues in spreadsheet
  3. Delete problematic entries
  4. Re-import corrected file

Template Method​

  1. Download SkyJourney CSV template
  2. Copy your data to template
  3. Match column headers exactly
  4. Import template file

Common CSV Mistakes​

  • Mixed date formats in same column
  • Spaces before/after airport codes
  • Using semicolon instead of comma
  • Extra quotation marks
  • Non-English characters causing encoding issues
  • Hidden columns with bad data
  • Excel auto-formatting (dates to numbers)

Need More Help?​

  • Download the official CSV template
  • Check CSV format documentation
  • Validate CSV with online tools
  • Contact support with sample file