How to Import Questions Into Kahoot From a Spreadsheet
You’ve already written 25 questions in Excel, complete with answer choices. Entering them into Kahoot one at a time would mean repeating work you’ve finished. A spreadsheet import can move those questions into a quiz much faster.
The catch is formatting. Kahoot expects its own Excel template, numeric answer keys, and specific time limits. A file that looks perfectly fine in Google Sheets can still produce errors during upload.
Quick Answer: How to Import Questions Into Kahoot
To import questions into Kahoot, sign in and open the Kahoot creator. Select Add → Import → Import spreadsheet, then download the official template. Enter one Quiz question per row with at least two answers, an accepted time limit, and the number of the correct answer. Save the completed workbook as an .xlsx file, upload it, and review any validation errors. Fix rejected rows rather than skipping questions you need. Finally, check the question count and answers in the creator before saving the playable game.
What Can You Import From a Spreadsheet?
Kahoot’s spreadsheet tool imports standard Quiz questions. Each question needs written answer choices and an answer key. The method is useful for classroom reviews, training quizzes, and question banks already prepared in Excel or Google Sheets.
It doesn’t import every question type available in Kahoot. For example, a two-answer Quiz with “True” and “False” as choices is possible, but that isn’t the same as importing Kahoot’s separate True/False question type.
| Content | Spreadsheet importer |
|---|---|
| Standard Quiz question with 2–4 answer choices | Supported |
| Correct-answer numbers and supported timers | Supported |
| Native True/False, Poll, Puzzle, or Type Answer | Not supported |
| Images, videos, or formatted equations | Add after import |
| Five or six answer columns | Not provided by the standard template |
Advanced question types can be added later if your plan allows them. Our create a Kahoot guide covers building a quiz from scratch.
Prepare Kahoot’s Official Excel Template
Start with Kahoot’s official spreadsheet-import instructions and download the template linked there or inside the creator. Don’t invent column headings in a blank workbook; the importer expects the supplied structure.
Put One Question in Each Row
Open the template in Microsoft Excel or Google Sheets. Fill the designated columns for the question, Answer 1 through Answer 4, the timer, and the correct-answer number. Keep the template’s headings and place your data only in the intended cells.
Each row needs at least two answers. You can leave Answer 3 and Answer 4 empty for a two-option question. If you maintain a larger question bank with difficulty ratings and source notes, keep those extras in a separate master sheet rather than adding columns to the import template.
Use Valid Timers and Answer Numbers
The importer accepts 5, 10, 20, 30, 60, or 120 seconds. Enter a number from that list, not a phrase such as “half a minute” or a custom value such as 45.
The correct-answer field refers to an answer’s position. If Answer 2 is correct, enter 2, not B or the answer text. For questions with several correct choices, the template permits a comma-separated key such as 1,3, although this can trigger a paid Multi-select feature.
Here’s a short, illustrative example. Enter it into the corresponding fields of Kahoot’s actual template rather than uploading this table directly.
| Question | Answer 1 | Answer 2 | Answer 3 | Answer 4 | Time | Correct |
|---|---|---|---|---|---|---|
| What is 6 × 7? | 36 | 42 | 48 | 56 | 20 | 2 |
| Which is Earth’s natural satellite? | Mars | The Moon | Venus | The Sun | 30 | 2 |
Check the Character Limits
Kahoot’s updated October 2026 import guide lists 120 characters for questions and 75 for answers. However, an older accessible version of its spreadsheet instructions and template guidance still lists 95 and 60. That discrepancy matters when reusing an old workbook.
Follow the limits in the template you download and the errors shown by the importer. If a longer question is rejected, shorten it to 95 characters and its answers to 60 as a conservative compatibility measure; don’t assume the general creator’s limits always match an older template.
Import the XLSX File Into Kahoot
Once the workbook contains your intended questions, save it as a genuine Excel .xlsx file. The filename extension alone won’t convert a CSV or another document into an Excel workbook.
- Sign in to Kahoot and select Create → Kahoot.
- In the creator’s left panel, select Add.
- Choose Import, then Import spreadsheet.
- Drag your
.xlsxfile into the import window or choose Select File. - Click Upload and review the validation results.
The import menu moved from its older location. Kahoot support confirmed the new location after a teacher reported difficulty finding it. Ignore outdated screenshots showing a different menu.
Don’t Skip Rows Without Checking Them
Kahoot checks uploaded rows and can offer to continue without problematic questions. That may be acceptable for optional questions, but it’s risky for an assignment built around a fixed syllabus.
Suppose your spreadsheet contains 25 science questions, but only 23 appear after import. Look at the rejected rows before proceeding. The problem may be a missing answer, invalid timer, overly long text, or an incorrectly formatted answer key. Compare the imported count against your original list.
Import Questions From Google Sheets, CSV, Word, or PDF
Google Sheets: Open Kahoot’s template in Google Sheets, enter your questions, then select File → Download → Microsoft Excel (.xlsx). Upload that downloaded workbook to Kahoot. Double-check that number fields haven’t been converted into text during editing.
CSV or another Excel layout: Open the existing file in a spreadsheet application and copy its question data into Kahoot’s template. If your answer key uses letters, convert A to 1, B to 2, and so on. Use the required time column, then export as .xlsx.
Word or PDF: The spreadsheet importer doesn’t directly upload these formats as question tables. You can transfer their text into the template, or investigate Kahoot’s separate document/AI creation features where available. A PDF slide-import feature isn’t the same thing as importing PDF quiz questions.
For large banks, keep your source notes and tags in a master workbook. Create a clean import copy with only the intended questions; don’t rely on hidden or filtered rows to exclude them.
Why Is My Kahoot Spreadsheet Import Not Working?
Most problems arise from the file’s format or values, not from the quiz content itself. Use the importer’s error message first, then check the relevant row and column.
| Problem | What to check | Fix |
|---|---|---|
| Upload rejects the file | Not a real .xlsx workbook | Export properly from Excel or Sheets |
| Questions fail validation | Missing text or fewer than two answers | Complete the required cells |
| Wrong answers are marked | Letter or word used as answer key | Use positional numbers such as 2 |
| Timer is rejected | Unsupported value such as 15 | Use an accepted timer |
| Text is cut off or rejected | Template character limit | Shorten the affected cell |
| Fewer questions appear | Invalid rows were skipped | Fix missing rows and reimport |
| Import button missing | Old tutorial, different interface, or access limits | Check Add → Import and your workspace |
Multiple Correct Answers Can Prevent Saving
A key like 1,3 identifies two correct answers. Kahoot may automatically turn that Quiz into Multi-select, which is available only on eligible paid plans. Kahoot’s Multi-select guide explains why an account without the feature may be unable to save the game.
If you don’t have Multi-select, rewrite the question so one choice is unambiguously correct, or select an eligible plan if the activity genuinely requires multiple selections. Don’t randomly remove correct answers just to make the warning disappear.
The Import Option Still Isn’t Visible
Check that you’re using Kahoot’s web creator and that you’re editing a game in a workspace where the feature is available. The mobile creation interface and account plans can differ. An absent option doesn’t, by itself, establish that everyone must buy Premium.
Review and Save the Imported Quiz
Uploading isn’t the final quality check. Open the imported questions in the creator and verify their order, answer keys, time limits, spelling, and total number. A validated answer number doesn’t guarantee the answer itself is factually correct.
Images, diagrams, video, and math formatting don’t transfer through the spreadsheet importer. Add necessary media to individual questions afterward, using the creator’s supported editing tools. A fractions problem with visual parts, for instance, may need a diagram before students can answer fairly.
When the content is correct, add a clear game title and select Save. If Kahoot keeps it as a draft, review incomplete correct answers or starred premium features. Our publish a Kahoot guide covers those separate saving errors.
You can then host the finished quiz or assign a Kahoot for students to complete independently. Keep the original spreadsheet so you can fix or reuse the question set later without rebuilding it.
Frequently Asked Questions
Can I Import 200 Questions in One Upload?
Kahoot allows up to 200 questions in one game, according to its creator documentation. That isn’t proof that a single spreadsheet upload accepts 200 rows. Check the current importer for per-file limits and divide a large bank into batches if needed.
Is Spreadsheet Import Free?
Import availability can vary by account or workspace. Standard Quiz questions are broadly supported, but premium features such as Multi-select may require a subscription. Check the options shown in your own account rather than assuming every plan includes the same tools.
Can I Download an Existing Kahoot as an Import Template?
Not directly. Kahoot can produce spreadsheet reports after gameplay, and it offers a way to combine existing games, but a report workbook isn’t automatically formatted for importing questions into another quiz. Use the official template for new uploads.
Final takeaway: Use the official template, check your answer numbers, and fix validation errors before continuing. After importing, confirm the question count and accuracy. For related tutorials, browse our Kahoot learning guides.
Publisher note: Kahoots.it.com is an independent information site and is not affiliated with Kahoot!
[…] Fix Connection Errors How to Assign a Kahoot for Students to Complete at Their Own Pace How to Import Questions Into Kahoot From a Spreadsheet How to Publish a Kahoot Quiz From […]