Copying and Pasting Trips from Spreadsheets

You can copy or import timetable data from spreadsheets created with third party software (for example, Microsoft Excel).

The import adds the trips times but note that it does not include any checks to ensure trip time integrity.
  1. In the Route Definition screen, create the number and abbreviation for all required nodes.
  2. Format the data properly.
  3. Make sure that the data to be imported meets all the requirements.
  4. Optional: Delete the trips in the existing timetable that you want to replace.
  5. Click Trip Building > Paste Trips From Clipboard.
    The data appears on the Trips grid. If the data is not properly formatted, ta message appears indicating that the format is invalid.
  6. Click OK. Review the spreadsheet and make the necessary changes. Repeat the procedure if necessary.
    The Paste Trips from Clipboard option is in the shortcut menus of all Trip Building tabs.