Writing a quiz spreadsheet

One row per question. Plain columns, no formulas, no formatting rules. Upload it in Admin → Quizzes → Import and every row is checked before anything is saved.

Download CSV template Download XLSX template

Three things that catch people out

Save as CSV UTF-8 so emoji survive. In Excel: File, Save As, CSV UTF-8.
One row per question. Rows that share a round title become one round.
Check the preview before importing -- nothing is saved until every row passes.

Columns

Header names are case-insensitive and the order does not matter. Blank rows are skipped.

Column	What it means
`round`	Round title. Rows sharing a title form one round. Required.
`type`	Question type or slide type. Required. See the list below.
`question`	The prompt. For emoji questions, paste the emoji here. For slide rows this is the slide title. Required.
`option_a`	First answer option. Leave blank for true_false, free_text and numeric.
`option_b`	Second answer option.
`option_c`	Third answer option.
`option_d`	Fourth answer option.
`option_e`	Fifth answer option.
`option_f`	Sixth answer option (maximum).
`correct`	See the per-type rules below.
`alt_answers`	Extra accepted answers for free_text/emoji, separated by a pipe, e.g. jaws\|jaws 1975
`time_limit`	Seconds, 5-120. Blank uses the quiz default. On a break slide this is the break length.
`points`	Points for a correct answer. Default 100.
`media_url`	https:// image URL. Required for picture questions.
`explanation`	Shown on the big screen after the reveal. For slide rows this is the slide body text.
`answer_mode`	first_tap, captain or majority. Read from the first row of a round only.
`round_multiplier`	e.g. 2 for a double-points round. First row of a round only.

What goes in `correct`

Type	correct
`multiple_choice, picture`	The option letter, A to F.
`true_false`	true or false.
`free_text, emoji (no options)`	The answer text. Put alternatives in alt_answers.
`emoji (with options filled)`	The option letter.
`numeric`	The number, optionally with a tolerance: 1987 or 1987±2.
`order`	The option letters in the correct order, e.g. C,A,B,D.

Question types

multiple_choicetrue_falseemojifree_textpicturenumericorder

Slide rows

A quiz is a deck, not just questions. You can put slides in the sheet too: set type to one of these, put the title in question, the body in explanation, an image in media_url, and for a break the length in seconds in time_limit.

slide_breakslide_endslide_introslide_leaderboardslide_messageslide_round_resultsslide_round_titleslide_rules

Intro, round titles, leaderboards and the end slide are added automatically if you do not include them, so you can add just one sponsor message and still get a full deck.

Answer modes

Set answer_mode on the first row of a round to preset how that round is answered. The host can always override it live.

first_tapcaptainmajority

Example rows

The first eight columns of the rows shipped in the template.

round	type	question	option_a	option_b	option_c	option_d
Horror Movies	multiple_choice	Which year was the original Halloween released?	1976	1978	1980	1982
Horror Movies	true_false	Freddy Krueger wears a green and red jumper.
Emoji Round	emoji	🔪🚿👩
Emoji Round	emoji	🦈🏖️🚤
Picture Round	picture	Name this film	The Thing	Alien	Predator	They Live
Numbers	numeric	How many Saw films are there (to 2023)?

What the validator tells you

A dry run happens first, and reports by row in plain English:

Row 4: correct = "G" but only options A-D are filled.
Row 7: type "pictur" not recognised -- did you mean "picture"?
Row 9: time_limit 3 is below the minimum of 5.
Row 12: emoji question looks like it lost its emoji -- re-save the file as UTF-8.

Nothing is imported until there are zero errors. Warnings never block an import.