Cue descriptions to ASCII

This application is designed to convert a spreadsheet of light cue descriptions into USITT ASCII for import into a lighting console. The resulting show file will insert numbered cues, times, follows, and links. The provided cue description will be appended to the console cue label.

To convert your cue descriptions, please create a CSV export using your preferred spreadsheeting application and upload it here.

Column name detection is case in-sensitive.
The order of columns does not matter.
Columns not described here will be ignored.
Column format specifications are below.
You should clear your existing console cues before attempting to import a generated show; the generated file will not clear them for you.
Because most spreadsheet applications do not allow you to export multiple sheets into a single CSV file, users utilizing multiple sheets will need to upload each sheet individually.

Example spreadsheet
Cue
Description
Pg
Time
Follow
Link
Flags
1
House Lights
1
3
 
 
 
.5
House at half
5
10
 
 
1.5
Blackout
 
3/5F10
 
 
B
2
Top of show
1
5/10
 
 
 
3
 
 
 
 
 
 
P1
 
 
15D3
 
 
 
5
Blackout
10
3.5
 
1.5
B
Format Details
Cue
Any number (e.g. 1, 1.5, 4.22)
Note: Rows without a Cue entry will be ignored
Optional: Part cues are defined by P[part number] (e.g. P1)
Note: Parts are assumed to belong to the closest Cue number preceding them.
Caution: When specifying parts, the only allowed data is a time for the part.
You cannot provide a description for the part or the parent cue. You cannot provide a time for the parent cue.
This is a limitation of the USITT ASCII standard and cannot be avoided.
Example:
Cue
1
P2
(Cue 1 Part 2)
P3
(Cue 1 Part 3)
2
P2
(Cue 2 Part 2)
Description
Any text. The USITT ASCII standard sets a maximum length of 75 for any give line. Characters in excess of this limit will be truncated.
Caution: Specifying Page and/or Flags will reduce the maximum description length
Page or pg
Any text. This gets appended to the cue description.
Flags
Any text. This gets prepended to the cue description.
Time
[time]; [up]/[down]; [up]\[down]; (e.g. 3, 4/6, 5\10)
Note: If a single number is specified, it will be used for both up and down times
Optional: You may also specify cue Follows in this column using the format [time]:F[follow time] (e.g. 4F10, 4/5F10)
Optional: You may also specify cue Delays in this column using the format [time]:D[delay time] (e.g. 4D10, 4/5D10,)
Caution: This app will accept and output decimal times (e.g. 4.5) but only you know if your console supports them. Tread lightly.
Link
Any number
Caution: This app does not verify that the linked cue actually exists
Follow
Any number
Note: Follows can also be specified in the Time column. See Time column for more information