How do I import the webinar chat script from a CSV?
In the builder's Chat step, the Import CSV button turns a file into script messages, with no typing and no generator. The file is read in your browser and is not sent anywhere: only the resulting script is saved with the webinar.
Role: any member with access to the workspace.
Before you start
- A webinar with Scripted chat enabled in the Chat step.
- A CSV file with at least a time column and a message column. Name and role columns are optional. Comma, semicolon or tab separated, up to 5,000 rows.
1. Choose the file
- In the Chat step, next to Generator, click Import CSV.
- Drop the file or click to choose it.
- Check the First row is the header box. It comes checked when the first row looks like titles.
2. Check the columns
Clickmax suggests the columns from the file's content, and you can change any of them:
3. Align the time, if the file has dates
When the time column carries a date and time, as in a live chat export, the Video start field shows up:
- Left blank, the first message in the file becomes 00:00 and the rest follow from it.
- Filled with the moment the video started, in the same format as the column, each message is placed relative to that start. Messages before the start are skipped.
4. Check the preview and import
The Preview shows the first converted messages, how many made it and how many rows were skipped (no readable time, no text, or before the video start).
If the script already has messages, choose between Add to the existing ones or Replace them all. Click Import. The messages join the script list, editable like any other, sorted by time. Save the step to publish.
If something goes wrong
- Couldn't read the file. Save the spreadsheet as CSV (not XLSX) and try again.
- The file has more than 5,000 rows. The whole file is refused, nothing is imported halfway. Split it into smaller files and import one at a time.
- Couldn't read the video start. The value in Video start is not in the same format as the time column. While it stays that way, the preview is empty and the import button is disabled. Copy the format of the value suggested in the field or leave it blank.
- Many rows skipped. Check the time column. A text column in the time slot skips every row.
- Messages land at the wrong time. With dates in the file, fill in Video start.