Importing Questions from Excel

If you already have an Excel spreadsheet with test questions you can import them to iSpring QuizMaker. To make QuizMaker automatically recognize questions, answer choices, points and other test details you have to use special formatting in your Excel file. For your convenience we're prepared a correctly formatted sample template file.

The following types of questions can be imported:

To import questions for Microsoft Excel:
  1. Click the iSpring QuizMaker application button and choose Import Questions. Then select Microsoft Excel.

    Or

    Click the Import Questions button on the main ribbon.

  2. In the newly open window browse for the file with the questions you want to import. Only Microsoft Excel files with *.xls and *.xlsx extensions are supported.

    Note: You have to have Microsoft Excel installed on your computer in order to successfully import questions to iSpring QuizMaker.

  3. Define where you want to import questions to:

    1. New Group:  A new group is created in the list of questions. By default, the group is named Imported Questions. You can rename it by typing a new name in the field on the right.

    2. Existing Group: if you choose to import questing to the group which already exists in your quiz, the imported questions will be inserted at the end of the group.

  4. Click the Import button.
  5. The questions will be imported to iSpring QuizMaker.

  6. Those questions that are formatted incorrectly won’t be imported. The rows along with error descriptions will be listed in the Import Result window.

Excel File Format

Quiz questions can be imported from a standard Microsoft Excel spreadsheet. The questions must be located in the first sheet. The Row 1 contains fields description, all the following rows – questions and answer choices.

You can learn about import format by opening a sample template file with correctly formatted example.

Field Description
Question type Question type abbreviation.
Question text Question text.
Image A path to an image file. It can be both absolute and relative path. The last has to be specified with regard to a source .XLS file.
Video A path to a video file.
Audio A path to an audio file.
Answer 1 Answer choices (up to 10 choices). The correct answer must begin with asterisk (*). Use a pipe (vertical bar) character "|" as a delimiter to separate premises and responses in Matching questions. Each type of question has its minimal number of answer choices and correct answers (e.g. Multiple Choice question has to have at least 2 correct answer choices). Optional parameters can be specified in brackets "[]".

If the fields Points, Correct / Incorrect Feedback are empty, the default values specified Quiz Properties is used.

 
Note: You can check the sample template is in the "Sample" tab  of the .XLS sample spreadsheet.
Answer 2
Answer 3
Answer 4
Answer 5
Answer 6
Answer 7
Answer 8
Answer 9
Answer 10
Correct Feedback

A feedback message for a correct answer (in a Graded Test) or a feedback for an answered question (in a Survey). If this field is empty, a message from Quiz Properties is used.

Incorrect Feedback An incorrect answer feedback message.
Points

Points awarded for a correct answer. You can set any point value between 0,1 and 99999. Plus, you can use fractional points (up to 1 symbol after a decimal point). If points are not specified in the corresponding fields, values from Quiz Properties are used.

Graded Questions

Table 1. True/False
Field Description
Question type TF
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 There must be 2 answer choices. A correct answer is preceded with an asterisk *. Only 1 correct answer is allowed for this type of question.
Correct Feedback

A feedback message for a correct answer (optional).

Incorrect Feedback An incorrect answer feedback message (optional).
Points

Points awarded for a correct answer (optional).

Table 2. Multiple Choice
Field Description
Question type MC
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 There must be at least 2 answer choices. A correct answer is preceded with an asterisk *. Only 1 correct answer is allowed for this type of question.
Correct Feedback

A feedback message for a correct answer (optional).

Incorrect Feedback An incorrect answer feedback message (optional).
Points

Points awarded for a correct answer (optional).

Table 3. Multiple Response
Field Description
Question type MR
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 The minimal amount of answer choices is 2. Correct answer choices are preceded with an asterisk *. There can be any number of correct answer choices between 1 and the overall number of alternatives.
Correct Feedback

A feedback message for a correct answer (optional).

Incorrect Feedback An incorrect answer feedback message (optional).
Points

Points awarded for a correct answer (optional).

Table 4. Type In
Field Description
Question type TI
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 There must be at least 1 answer choice. List only correct answer alternatives in Answer fields. Thus, you don’t have to mark any with an asterisk *.
Correct Feedback

A feedback message for a correct answer (optional).

Incorrect Feedback An incorrect answer feedback message (optional).
Points

Points awarded for a correct answer (optional).

Table 5. Matching (Graded)
Field Description
Question type MG
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 The minimal amount of answer choices is 2.  Each answer choice is a pair of alternatives where matching items are separated with a pipe character |.
Correct Feedback

A feedback message for a correct answer (optional).

Incorrect Feedback An incorrect answer feedback message (optional).
Points

Points awarded for a correct answer (optional).

Table 6. Sequence
Field Description
Question type SEQ
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 The minimal amount of answer choices is 3.  Answers should be listed in the correct order.
Correct Feedback

A feedback message for a correct answer (optional).

Incorrect Feedback An incorrect answer feedback message (optional).
Points

Points awarded for a correct answer (optional).

Table 7. Numeric (Graded)
Field Description
Question type NUMG
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 The minimal amount of answer choices is 1. For this type of quiz question an answer choice is always a number. You can specify an exact  number or a range:

"=Х" – equal to Х

"Х..Y" – any value between  Х and Y

">Х" – greater than Х

"<Х" – less than Х

">=Х" – greater than or equal to Х

"<=Х" – less than or equal to Х

"!= Х" – not equal to X
Correct Feedback

A feedback message for a correct answer (optional).

Incorrect Feedback An incorrect answer feedback message (optional).
Points

Points awarded for a correct answer (optional).

Survey Questions

Table 8. Yes/No
Field Description
Question type YN
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 There must be 2 answer choices.
Correct Feedback A feedback message for an answer (optional).
Incorrect Feedback Not used.
Points

Not used.

Table 9. Pick One
Field Description
Question type PO
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 There must be at least 2 answer choices.
Correct Feedback A feedback message for an answer (optional).
Incorrect Feedback Not used.
Points

Not used.

Table 10. Pick Many
Field Description
Question type PM
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 There must be 2 answer choices.
Correct Feedback A feedback message for an answer (optional).
Incorrect Feedback Not used.
Points

Not used.

Table 11. Short Answer
Field Description
Question type SA
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 Not used.
Correct Feedback

A feedback message for an answer (optional).

Incorrect Feedback Not used.
Points

Not used.

Table 12. Matching (Survey)
Field Description
Question type MS
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 The minimal amount of answer choices is 2.  Each answer choice is a pair of alternatives where matching items are separated with a pipe character |.
Correct Feedback A feedback message for an answer (optional).
Incorrect Feedback Not used.
Points

Not used.

Table 13. Ranking
Field Description
Question type RNK
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 The minimal amount of answer choices is 3.
Correct Feedback A feedback message for an answer (optional).
Incorrect Feedback Not used.
Points

Not used.

Table 14. Numeric (Survey)
Field Description
Question type NUMS
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 Not used.
Correct Feedback A feedback message for an answer (optional).
Incorrect Feedback Not used.
Points

Not used.

Table 15. Essay
Field Description
Question type ESS
Question text Question text.
Image A path to an image file (optional).
Video A path to a video file (optional).
Audio A path to an audio file (optional).
Answer 1..10 Not used.
Correct Feedback

A feedback message for an answer (optional).

Incorrect Feedback Not used.
Points

Not used.