Import questions from CSV or Excel

The format Quizlix expects

The CSV must have these columns in this order. Header row is required.

Column reference

• question — the question text. Wrap in quotes if it contains commas. Max 500 characters.
• type — one of multiple_choice, true_false, text (free-form answer).
• answer — the correct answer. For true_false, use True or False.
• wrong1, wrong2, wrong3 — wrong choices for multiple_choice. Leave empty for true_false and text.
• points — points awarded for a correct answer. Default 10.
• category — optional grouping (Music, Sports, History, etc.). Used to balance round difficulty.

Step-by-step

1. Download the template above.
2. Open it in Excel, Google Sheets, Numbers, or any spreadsheet app.
3. Replace the example rows with your own questions. Keep the header row exactly as-is.
4. Save as CSV (UTF-8) — important for special characters like é, ü, ñ. In Excel: File → Save As → choose "CSV UTF-8 (Comma delimited)".
5. In Quizlix Creator, open your quiz, click Import → Upload CSV.
6. Quizlix shows a preview of all detected questions. Click Confirm import — questions are added.
7. Edit individual questions afterwards if you want (rephrase, swap categories, change points).

Common errors

• "Special characters look broken (ä instead of ä)" — your file is not UTF-8. Re-save with UTF-8 encoding.
• "Some rows were skipped" — the row probably has too few columns or an unrecognised type. Quizlix shows which row failed in the preview.
• "My quiz already has questions" — upload appends, doesn't replace. Delete existing questions first if you want a clean import.

Tips for great quiz CSVs

• Mix difficulty per category — for each round (5 questions), include 1 easy, 3 medium, 1 hard.
• Keep questions short — 1–2 sentences. Long questions kill pace.
• Make wrong answers plausible — "1989, 1985, 1991, 1987" beats "1989, ABC, XYZ, 1234".
• Use categories consistently — Quizlix uses them to assemble balanced rounds.