How do Kahoot, Blooket, and Gimkit spreadsheet formats differ?
Kahoot and Quizizz expect .xlsx workbooks with numeric answer keys (1 through 5), Blooket expects a .csv starting with a Blooket Import Template banner row, and Gimkit expects a 5-column .csv placing Correct Answer text in Column 2. Rearranging columns manually across hosts frequently breaks uploads.
Comma-separated exports follow the IETF RFC 4180 CSV file specification so embedded commas, quotation marks, and chemical or algebraic punctuation stay properly quoted inside every row. Using a dedicated quiz spreadsheet converter lets you maintain one clean question source and target whichever classroom game your students are playing that day.
If your master test bank starts in Moodle with percentage weights or matching pairs, you can first validate Moodle GIFT partial-credit and matching banks before exporting multiple-choice subsets for live review. Every spreadsheet target enforces its exact header schema and character rules automatically.
| Target platform | File container | Stem & choice limits | Answer key format | Supported question types |
|---|---|---|---|---|
Kahoot (kahoot-xlsx) |
.xlsx (Kahoot Quiz) |
120 chars / 75 chars |
Numeric 1–4 (1,3 multi) |
Single choice, Multi-select, True/False |
Blooket (blooket-csv) |
.csv (Row 1 banner) |
300 chars / 150 chars |
Numeric 1–4 (Max: 300s) |
Single choice, Multi-select, True/False |
Gimkit (gimkit-csv) |
.csv (5 columns) |
Full text (whitespace-cleaned) | Column 2 Correct Answer text |
Single choice, True/False, Short answer |
Quizizz (quizizz-xlsx) |
.xlsx (Quizizz Import) |
Up to 5 option columns |
Numeric 1–5 + Question Type |
Multiple Choice, Checkbox, Fill-in, Essay |
Universal (generic-csv) |
.csv (11 columns) |
Unlimited lossless text | Letters A–E, ± or -> |
All 7 quiz types + points & feedback |
Enforcing character limits and timers across game exports
Uploading a semester exam into a live game host usually fails on the first verbose stem or five-option question. Normalizing option counts, string lengths, and countdown timers during export eliminates trial-and-error spreadsheet editing before class starts.
Trimming Kahoot 120-character stems and Blooket rows
Selecting Kahoot spreadsheet (.xlsx) builds a native workbook matching the IANA SpreadsheetML (.xlsx) media type registration with worksheet tab Kahoot Quiz and exact template column headers. Prompts longer than 120 characters and options longer than 75 characters are collapsed to single-line whitespace and trimmed cleanly with a trailing ellipsis (…), while extra choices beyond 4 slice neatly to four options.
Selecting Blooket import (.csv) writes the required Blooket Import Template banner on Row 1, sequential Question # integers starting at 1, 300-character stem clamping, 150-character choice clamping, and countdown values capped at 300 seconds. Whenever stems or options are shortened or non-choice questions are skipped, a completion note summarizes the exact counts underneath the download card.
Mapping Gimkit answer columns and Quizizz item types
Gimkit rejects numeric 1–4 answer indices because its importer expects the right option text in Correct Answer (Column 2) and up to 3 wrong options in Incorrect Answer 1 through Incorrect Answer 3 (Optional). Selecting Gimkit import (.csv) reorders each question’s choices automatically and also preserves single-answer short-response prompts by leaving the three distractor columns blank.
Selecting Quizizz / Wayground (.xlsx) writes 9 columns (Option 1 to Option 5 plus `Time in seconds`) for Multiple Choice, Checkbox, Fill-in-the-Blank, and Open-Ended (180 seconds default) items. Set Question timer to 10 sec through 120 sec, or run Word drafts through the strict Aiken multiple-choice cleaner.
Converting Quizlet sets and existing game sheets in reverse
Teachers often store vocabulary lists in Quizlet or inherit a colleague’s Kahoot .xlsx file from last year when their current school uses Blooket or Gimkit. Both tabular inputs parse directly without intermediate spreadsheet formulas.
Generating multiple-choice distractors from Quizlet
Paste tab-separated Term and Definition lines exported from Quizlet into the editor or pick Quizlet (Term / Def) under Input syntax. For sets with 4 or more unique definitions, a seeded shuffler pairs each term with its matching definition and 3 distractors drawn from other cards in the set.
Vocabulary lists with fewer than 4 unique definitions convert into exact short-answer items so Gimkit and Quizizz Fill-in-the-Blank games still work cleanly. For offline classroom stations, you can also turn Quizlet term lists into two-sided flashcard PDFs with mirrored front-and-back alignment.
Cross-converting Kahoot, Blooket, and Quizizz uploads
Opening an .xlsx or .csv game file scans the first 8 rows to skip template banners and find the header row containing Question plus Answer, Option, or Choice. The parser reads Gimkit’s Correct Answer column alongside numeric 1..4 and letter A..F keys while keeping per-row timers (5 seconds floor).
Tip: Click Load sample to load
world-geography-game.txt, adjust Question timer from30 secto20 sec, and test Export Kahoot XLSX or Export Gimkit CSV to compare how each host structures the same four geography questions.
Moving classroom games into LMS banks with local privacy
Review games built for Friday trivia often hold strong formative questions that belong in formal unit tests. Because every spreadsheet parses into a shared assessment model, game files convert straight into LMS packages too.
Upgrading review games into graded Canvas quizzes
All .xlsx files are read and assembled locally in browser memory according to the ECMA-376 Office Open XML SpreadsheetML standard without third-party cloud APIs. After opening a Kahoot, Blooket, Gimkit, or Quizizz sheet, switch Output format to Canvas / Blackboard QTI 1.2 (.zip) or Moodle XML (.xml) to import graded quizzes into Canvas without manual retyping.
Choosing Universal quiz table (.csv) exports an 11-column archival table (Number, Type, Question, Option A through Option E, Correct Answer, Points, and Feedback). That layout preserves numerical ± tolerances, -> matching pairs, and item feedback inside one portable CSV file.
Resolving unmatched answer keys within 25 MB files
If a custom spreadsheet row contains an unparseable answer key, a row-numbered Note warning flags that item and defaults to Option A so you can fix the typo in the editor before downloading. Every file up to 25 MB (25,000,000 bytes) runs 100% locally in a browser Web Worker, ensuring 0 bytes of classroom material ever leave your device.