How to Import Questions from a Spreadsheet into Blooket

 

You can easily import multiple choice questions into new or existing Question Sets!

 

To import a spreadsheet into a new set: select the "CSV Import" option on the Set Creator Page. Then, add a title and select "Create Your Set".

SCR-20230713-gsnf-2.png

 

To import a spreadsheet into an existing set: select the "Spreadsheet Import" option on the Set Edit page

SCR-20230713-gugj.png

 

1. Copy or Download Blooket's spreadsheet template.

Select "Copy" to edit our format in Google sheets
Select "Download" to edit our format in Excel

https://helpcenter-io.s3.amazonaws.com/uploads/blooket/hFlSiPJC62okuevXwTSyhcOXCM6ZL6KayPyUclgw-Import%20csv.PNG

 

2. Edit the spreadsheet to fit your needs 
Note: Do not edit any of the colored (blue or gray) cells when adding question, answers, or time limits

https://helpcenter-io.s3.amazonaws.com/uploads/blooket/gzPPeo1jOUdf4lFu39CfkIUXesCBYb4BG1tmjg89-image.png

 

Bonus Tip: Add typing to the J column for any questions you'd like to be "typing answer" questions. Any answers you enter in the answer columns will be imported as "is exactly" options.

SCR-20231116-iogr.png

SCR-20231116-irwo.png

 

3. Download the file as a .CSV (Comma Separated Values)

SCR-20230713-hacg.png

 

4. Navigate back to Blooket and Upload the CSV file

https://helpcenter-io.s3.amazonaws.com/uploads/blooket/2KYOsv8TUPxWweXYPvtPwpiOxblX8noXOlGSYRtZ-Import%20csv.PNG

 

Once imported, you will be taken to the Set Edit page where you can further customize and edit your question set.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.