Can CueSetter import a CSV file?

Not directly. Open the CSV in Excel, Google Sheets or Numbers and save it as .xlsx, or copy the rows with the header row and paste them into CueSetter as text.

My CSV comes from a rundown or event tool. Will it work?

If it has a header row and one row per item, yes. Open it in a spreadsheet first, check that the columns are split correctly, then save as .xlsx or copy and paste.

Is the file uploaded to a server?

No. Files and pasted text are read in your browser on your own computer and are never sent to us or any other server.

CSV run sheet to grandMA3 cue list

Two ways in

A CSV file is plain text: one line per row, with the cells separated by commas or semicolons. CueSetter reads Excel files and text copied from a spreadsheet, so the spreadsheet program does the CSV part:

Save as .xlsx: open the CSV, save or download it as an Excel workbook (.xlsx) and upload it to CueSetter. Best when you will get new versions of the file.
Copy and paste: open the CSV, select the rows including the header row, copy, and paste them into the “Or paste text” box in CueSetter. Quickest for a one-off.

Both give the same result: the columns are found from the header row, and every row becomes a cue.

Step by step

1Open the CSV in Excel, Google Sheets or Numbers. If everything lands in one column, use the program’s import or text-to-columns tool and choose the separator the file uses (comma or semicolon).
2Check that there is a header row, with words like #, Start, Time, Duration, Title or Item.
3Save it as .xlsx (in Google Sheets: File → Download → Microsoft Excel; in Numbers: File → Export To → Excel), or select the rows with the header and copy them.
4Upload the .xlsx file, or paste the rows, in CueSetter. Check the columns and cues.
5Download the macro and import it on the console. Run it once, and the sequence is built.

Why not paste the CSV text itself?

When you copy cells from a spreadsheet, they come out separated by tabs, and CueSetter reads tab-separated text with a header row column by column. The raw text of a CSV file has commas instead of tabs, so it would be read line by line, like a run sheet written as “18:30 Doors open”. That works for simple lists, but the columns are lost. Copy from the spreadsheet, not from a text editor.

What CueSetter reads in the rows

The header row can be below a title or info rows; it is looked for in the first 20 rows.
Number, start time, duration and title are found from the header. Other columns, like notes, are shown but not used.
A row without a number or time continues the item above, so a set list over several rows stays one cue, ready to split into sub-cues.
Cue numbers follow the # column. Rows without a number get one between their neighbours.

More about spreadsheets in Excel to grandMA3. Making the run sheet from scratch? Start from the free run sheet template.