Import from spreadsheets
Ontime allows importing a rundown from a spreadsheet written elsewhere (eg. Excel or Google-Sheets).
Follow here to see the Google Sheet template in the screenshot.
Importing data
For a successful import, there are a few conventions to follow.
- Ontime reads a single worksheet
- You can have as many columns as necessary, Ontime only imports the columns you request
- The name of the worksheet and columns are given in the app on import
- Ontime creates an event for every row on the table (see exception in Timer type notes)
- All fields in an event (row) are optional, Ontime will fill in with default data if necessary
- The times can be either an Excel time field or a short text entry as described in the smart entry feature eg:
00:10:15
or10m15s
See below the expected data types of the rundown data
Field names are not case-sensitive: both Title
and title
would be recognised on import.
Event Field | Data Type | Default value |
---|---|---|
Start | Excel time | string | 00:00:00 |
Link start | boolean | false |
End | Excel time | string | 00:00:00 |
Duration | Excel time | string | 00:00:00 |
Cue | string | "" |
Title | string | "" |
Public | boolean | false |
Skip | boolean | false |
Note | string | "" |
Colour | string (# hex colour or named css colour) | "" |
End action | none stop load-next play-next | none |
Timer type* | count-down count-up time-to-end clock count-down time-to-end block skip | count-down |
Time warning | Excel time | string | 00:02:00 |
Time danger | Excel time | string | 00:01:00 |
Custom Fields
Ontime allows importing any amount of custom fields.
You will need to provide the title of the relevant columns on import.
For each field provided, Ontime will create a custom field and add the data in the excel table row to the event.