How to import questions from a spreadsheet to your kahoot
Are you looking to bulk upload questions or collaborate with other educators offline? You can easily import questions to Kahoot from a spreadsheet using our downloadable template. This seamlessly transfers your quiz questions, saving you time and enhancing your game creation process.
- How do I prepare the spreadsheet for import?
- How do I import the spreadsheet into the kahoot creator?
- FAQ
How do I prepare the spreadsheet for import?
Before you begin, you must use our official template.
- Download the official Kahoot! template.
- Open it in a compatible spreadsheet program like MS Excel, Libre Office, Google Spreadsheets, or Numbers.
- Type your questions and answers in the designated columns.Questions in the template have a stated limit of 120 characters, and answers have a limit of 75 characters. Each question must have at least two answers.
- Set the allowable time limit (sec) values to 5, 10, 20, 30, 60, or 120.
- Indicate correct answers by listing the answer numbers separated by commas (e.g., “1” or “2,3”).
- Save the template as a .xlsx file (MS Excel 2007 or newer).
☝️ You can currently only import standard Quiz questions. Other question types are not supported via the spreadsheet tool.
How do I import the spreadsheet into the kahoot creator?
- Enter the kahoot creator by clicking Create in the top right corner of the platform.
- Click the Add button in the left panel.
- Select Import from the menu.
- At the bottom of the prompt, select the Import spreadsheet option.
- Upload your .xlsx file by dragging it into the prompt or clicking the Select File button.
- Click the Upload button.
💡 Our system will automatically check for errors. If any are found, you can go back to fix the spreadsheet or continue and drop the problematic questions. Once successfully imported, your questions will appear instantly in the kahoot creator.
FAQ
-
Can I import other question types like True/False or Puzzle? At the moment, you can import only standard quiz questions.
-
Can I import images or math equations using the spreadsheet? No, images and special characters cannot be imported via the spreadsheet. However, you can copy and paste mathematical symbols directly into the kahoot creator later, either directly or as LaTeX code.
-
Can I download an existing kahoot as a spreadsheet? If you want to combine kahoots, we have a built-in feature to combine existing kahoots so you don't need to download and re-upload them. If you need a spreadsheet for other reasons, you can play through the kahoot and download the spreadsheet report afterward, which provides an .xlsx file with all questions and answer options.
- What happens if there are errors in my spreadsheet? The import system will check for formatting errors. You can either fix them in your file or choose to continue without importing the problematic questions.
12 comments
Will there soon be an option to then download existing kahoots as spreadsheets? This will make it easy to combine our existing kahoots that were created before the spreadsheet import feather was added
Hi CCBCMissAlly! We now have a built-in way to combine kahoots. No need to download the kahoot only to re-upload it :-)
But if you do want to export a kahoot for any other reason, you can play through the kahoot and download the report after. This will give you an xlsx file that includes all questions and answer options.
Where do the questions go after importing?
On the creation page the character limit for questions is 120 but the instructions on this page and your Excel template is set at 95. These need to be updated.
Is there a way to import questions and answers containing special characters ( f(x) equations ) automatically? Is there also a way to import an image from a spreadsheet? Thank you! This is a fantastic feature!
hello, You can copy paste a lot of mathematical symbols into the kahoot creator, either directly or as LateX code. Example code:
$$\Braket{ \phi | \frac{\partial^2}{\partial t^2} | \psi }$$
Is there a way to import other quesiton types such as type answers, puzzle…
Hello benjaminprentiss, at the moment you can import only quiz questions.
The option import spreadsheet is not available
Hey @danielcardinal17, we have recently updated the layout of our creator, and you can now find the Import spreadsheet button by following the Add question > Import path. We are currently working on updating the above article – sorry for any confusion caused by this.
Is there a way to have 5-6 answers?
Hey abyanmalik12345!
Adding more than 4 answer choices (up to 6) is available only with specific plans. Any feature in the kahoot creator marked with a star isn't included in your current plan.
Please sign in to leave a comment.