Create quizzes

Import questions from Excel or CSV

Bring an existing question bank into BQuiz and map your own columns.

5 min
5 steps
Intermediate
Interactive

Overview

If you already keep questions in a spreadsheet, you don't need to retype them. Upload the file, tell BQuiz which column holds what, and the questions open in the quiz builder.

You'll need

An .xlsx or .csv file up to 2 MB
One row per question, with a header row

Step by step

Step 1 of 5

Put each question on its own row, with column names in the first row. Useful columns: question, answer, type (mcq, sq or lq), explanation, and the options, either in one column separated by commas (“options”) or in separate columns (option_1, option_2, option_3, option_4). Your column names can be anything; you'll match them in step 4.
Try it: click the highlighted part to complete step 1.
app.bquiz.co · Import Excel
BBQuiz
Quizzes
Open “Create Quiz” and choose “Import Excel”.
Interactive preview. Nothing here changes your real account.

Good to know

For multiple choice, the answer must match one of the options exactly (same spelling and spaces).
Rows without a question are skipped.
If type is empty, the question is imported as multiple choice.

Common questions

Can I import into an existing quiz?

Yes. Use “Import Questions” in the quiz editor to add questions to the quiz you're working on.

Was this guide helpful?

See this featureHighlights and how it fits your classroom.

Still stuck? Our support team replies within one business day.

Contact support