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've prepared a correctly formatted sample template file.

The following types of questions can be imported:     

  • True/False      
  • Multiple Choice      
  • Multiple Response
  • Matching      
  • Type In      
  • Sequence      
  • Essay
  • Info Slides

To import questions from 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 toolbar.



  2. In the newly open window browse for the file with the questions you want to import. Only the 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: 
    a. 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
    b. Existing Group: if you choose to import questions 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. The questions will be imported to iSpring QuizMaker.


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.


FieldDescription
Question typeQuestion type abbreviation.
Question textQuestion text.
ImageA 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.
VideoA path to a video file.
AudioA path to an audio file.
Answer 1

Answer choices (up to 10 choices).  The correct answer must begin with an asterisk (*).

Use a pipe (vertical bar) character "|" as a delimiter to separate premises and responses in the Matching questions.

Each type of question has its minimal number of answer choices and correct answers (e.g. the Multiple Choice question has to have at least 2 answer choices and only 1 correct answer). Optional parameters can be specified in brackets "[]". If the fields PointsCorrect / Incorrect Feedback are empty, the default values specified in Quiz Properties are used. 

Check the sample template file to find the detailed info on the question formatting. 

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
FieldDescription
Question typeTF
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10There 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
FieldDescription
Question typeMC
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10There 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
FieldDescription
Question typeMR
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10The 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
FieldDescription
Question typeTI
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10There 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)
FieldDescription
Question typeMG
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10The 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
FieldDescription
Question typeSEQ
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10The 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)
FieldDescription
Question typeNUMG
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10The 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
FieldDescription
Question typeYN
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10There 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
FieldDescription
Question typePO
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10There 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
FieldDescription
Question typePM
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10There 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
FieldDescription
Question typeSA
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10Not used.
Correct Feedback

A feedback message for an answer (optional).

Incorrect Feedback Not used.
Points

Not used.



Table 12. Matching (Survey)
FieldDescription
Question typeMS
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10The 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
FieldDescription
Question typeRNK
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10The 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)
FieldDescription
Question typeNUMS
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10Not used.
Correct Feedback A feedback message for an answer (optional).
Incorrect Feedback Not used.
Points

Not used.



Table 15. Essay
FieldDescription
Question typeESS
Question textQuestion text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10Not used.
Correct Feedback

A feedback message for an answer (optional).

Incorrect Feedback Not used.
Points

Not used.


Info Slides

Table 16. Info Slides

FieldDescription
Question typeIS
Question textInfo Slide text.
ImageA path to an image file (optional).
VideoA path to a video file (optional).
AudioA path to an audio file (optional).
Answer 1..10Slide description.
Correct FeedbackNot used.
Incorrect Feedback Not used.
Points Not used.