FlexiQuiz allows Premium plan users to import questions and options directly to a quiz from an Excel spreadsheet.
Follow the steps below for importing questions to your own quiz.
Step 1
On the Create page of your quiz select Add item and then select Import questions.
Step 2
Select to Download the pre-formatted Excel template, the template can also be downloaded from here
Step 3
Open the spreadsheet and enter your questions and options.
Fields
Question Text: Unlimited amount of text, this can also include HTML formatting (Required)
Question Type: Select options from dropdown, if blank option will default to Single Choice (Dropdown)
Points: Any number which is 0 or greater, if blank will default to 1
Page Number: Any number which is 1 or greater, if blank will default to 1
Option (n) Text: Unlimited amount of text, this can also include HTML formatting
Option (n) Correct: Select Yes or No, if blank will default to no
Question types
Single Choice (Radio Button): All options are shown and users can only select one option.
Single Choice (Dropdown): Options are shown in a dropdown box and users can only select one option
Multiple Choice: All options are shown and users can select multiple options
Matching Text: Users manually type the option, this is matched to a predefined list of correct options
Free Text: Users can manully enter any text, these questions are not graded
Notes
There is a limit of 1000 questions
There is a limit of 10 options per question
Do not change the format of the spreadsheet by deleting or moving any columns or rows. However, it is ok to change column widths if required
Step 4
Save the spreadsheet ensuring it is still saved as a .xlsx file
Step 5
If you had previously closed the Import quesions dialog re-open it through the Add item -> Import questions button. Press the Select File button and then navigate to your file. Select your file and FlexiQuiz will then import your questions to the Quiz.