Import events from Excel

You can import an Excel file containing your rundown. See the template from the above screenshot

Ontime allows importing rundown and project data from a spreadsheet. For a successful import, there are a few conventions to follow

  1. Ontime reads a single worksheet

  2. The name of the worksheet and columns is given in the app on import

  3. Ontime creates an event for every row on the table

  4. All fields in an event (row) are optional. Missing data will be defaulted if needed

  5. Time fields not provided will be calculated at import. The times can be either an Excel time field or a short text entry as described in the docs eg: 00:10:15 or 10h15

  6. Any text under a field named Is Public will make the event public. We show this as a toggle for simplicity

  7. See below the expected data types of the rundown data

Project data

The project data can be defined in the sheet. These fields must have their data on the cell to its right (see screenshot or template)

Rundown

Field names are not case-sensitive. Meaning: both Event Title and event title would be recognised on import

User Fields

There are ten custom fields available.

These can have any name, the names are given to Ontime on import

PreviousRollNextURL Aliases

Last updated