Help / Import quiz questions with a spreadsheet
Bulk import quiz questions with our Excel template
Save time by uploading hundreds or thousands of questions in a single go with our FlexiQuiz Excel template.You can add questions directly to a quiz or organize them into categories within your question bank for quick and easy reuse.
How to upload questions with our Excel template
Admins and Trainers can import questions to a classic quiz.
- To start, log in to your FlexiQuiz account.
- From your main dashboard, select the quiz that you would like to import your questions to or click + Create to add them to a new test.
- Then select Create a classic quiz and Start from scratch.
- Now enter a name for your quiz and click Create. A pop-up will appear that allows you to select the first element that you want to add to your quiz.
- Click upload questions and your upload options will appear.
- Now click Download Excel template and the file upload template will download.
- Then open the template and please read all of the instructions before completing it. We have provided a description for each section below.
- Once you have filled in the Excel template, click Select file to upload it to your quiz. Please wait a few moments while the file uploads.
Once the file is successfully uploaded, the questions will appear in your quiz. If you have also included a category, the questions will appear in your question bank.
Top tips for adding your questions to the Excel template
- Do not move or delete any of the columns, or the file will not upload correctly.
- You can leave some columns blank, such as the options column.
- It's not possible to upload images, files, audio, or video using the template. However, you can add media to your quiz after you've uploaded the questions.
- If you want to add questions to a category in your bank, you must create the category before uploading the file.
- It is not possible to add picture choice or matching questions to the Excel template.
Description for each field
- Question text: Enter the text for your question, statement, or challenge.
- Question type: Choose the question type - see options below. If this column is left blank, questions will be uploaded as a single-choice (drop-down).
- Points type: Choose how you want to award points from the drop-down menu. You can award points for learners getting the whole question right or for each answer option.
- Question points: Enter the number of points you want to award for learners who get the whole question right.
- Page number: The page that you want the question to appear on the quiz.
- Required: Select yes from the drop-down menu if the test-taker needs to respond before the quiz is submitted.
- Question feedback: Share feedback about the question with learners.
- Question categories: To add a question to the question bank, you must provide a category already in the bank.
- Randomize options: Shuffle the answer options each time the quiz is taken. Choose yes or no from the drop-down menu.
- Option 1 Text: Enter the text for the first answer option or matching text.
- Option 1 Correct: If you have chosen to award question points - select yes or no if you would like the FlexiQuiz system to award points for this answer.
- Option 1 Points: If you have chosen option points, set how many points you would like to award for this option. The points can be positive or negative.
- Question types:
- Single-choice(radio buttons): Test-takers can select one correct response from a list of possible responses. This is also known as multiple-choice.
- Single choice (drop-down): Test takers can select one answer from a drop-down menu.
- Multiple-choice: Test takers can select several answer options from the list. This is also known as a checkbox question.
- Learners type their response; it can be matched to a predefined list of correct answer options.
- Free text: Users manually enter text in response to your question, statement, or challenge. You will need to mark and grade free-text questions manually.
Relevant help guides:
How to manage question categories
