<img height="1" width="1" src="https://www.facebook.com/tr?id=755385498933168&amp;ev=PageView &amp;noscript=1">
Skip to content
English
  • There are no suggestions because the search field is empty.

Admin: How to Bulk Import Travel Files

Guide on how to bulk import travel bookings for administrators using a spreadsheet file import. This is helpful where there is a high volume of travel bookings that would be difficult to add individually.

  1. In the Admin Panel, click on "Itineraries."
  2. Click on "Import Itineraries" button.
    Administering Itineraries - Itineraries Section
  3. Review the list of accepted import templates, then:
    1. Copy the required template in Excel.
    2. Enter the travel booking fields in the same order shown.
    3. Follow the formatting examples in the templates exactly.
      1. E.g. Departure date is YYYYMMDD and Departure time is HHMM
    4. Save the completed template as a CSV file.
    5. Click "Choose File" to select your file, or drag and drop into the upload area.
    6. Green: Import was successful.
    7. Red: Import failed and needs to be reviewed.

Admin - Bulk Import Travel Files - Import Itineraries

It is recommended to always check a few booking references after a successful import to ensure everything has been imported correctly into the platform.

Red Import Fail:

  • There may be an obvious formatting error in the import file. The system may identify which cell/field is reporting the error. Review the import file and check for any instances where the format may be incorrect.
  • If the cause of the failed import is unclear, contact the Global Guardian support team and send them the travel booking securely. The original file is required to diagnose the problem.