Bulk import multiple choice questions in BookWidgets

As you know, creating quizzes and worksheets in BookWidgets is pretty easy. The process of creating multiple questions is about to speed up with the CSV Import for multiple choice questions, which allows you to insert many questions from a .CSV file with one click of a button. Let me show you how this works

How to import multiple choice questions - Step by step

1. Create a question list in Excel

Make a list of all your multiple choice questions in Excel (or another spreadsheet app such as Google Docs, OpenOffice, …). Use this question file template to begin with. Make sure to make a copy of the file before you start adding words.

Add all the multiple choice question aspects, or delete some if you don’t have more answer options.

The example above will have the following result. Click on the image to take a closer look.

Multiple choice quiz example

When you’re done filling in the spreadsheet, you have to save the file as a CSV file. In Excel, you have to ‘Save as unicode text’ to do this; in other spreadsheets, saving the file as a CSV file is enough.

Some things to take into account when creating your CSV file:

  • The configuration values for the titles have to use the English terms, no matter what language your questions are in.
  • It’s important to leave the first line in the file template untouched. You can’t just add your own values.

2. Import your .CSV file

  • Create a quiz, a worksheet, a split worksheet, or a survey widget, or open an existing one. (Importing multiple choise questions only works in widgets where you can add questions)
  • Open the cog wheel menu in the upper right corner, and choose “Import CSV”.
  • The widget editor will fill your list with all the questions from your CSV file. To see how this looks for your students, click on “Preview” in the upper right corner.

Quiz question Import BookWidgets

Now, there’s only one thing left to do:

3. Upload your widget and share with students

Get your shareable link in the upper right corner. Then, share the widget link with your students or send it to Google Classroom.

That’s it! You’ll get the hang of it. If you have any questions, just reach out to us via support or via our Facebook page.

Lucie Renard

Join over 30,000 subscribers and get the best content on technology in education.

About BookWidgets

BookWidgets enables teachers to create fun and interactive lessons for tablets, smartphones, and computers.

Choose from over 40 exercise templates (quizzes, crosswords, jigsaw puzzles, ...), and adapt them with your own content.