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:          

  • Multiple Choice      
  • Multiple Response
  • True/False 
  • Short Answer
  • Numeric
  • Matching           
  • 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 new 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 FormatLink to Excel File Format

Quiz questions can be imported from a standard Microsoft Excel spreadsheet. The questions must be located on 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 a correctly formatted example.

Field
Description
Question typeQuestion type abbreviation.
Question textQuestion text.
ImageA path to an image file. It can be both an absolute and a 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.

Question TypesLink to Question Types

Table 1. Multiple Choice (Graded)

Field
Description
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 2. Multiple Response (Graded)

Field
Description
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 3. True/False (Graded)

Field
Description
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 4. Short Answer (Graded)

Field
Description
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)

Field
Description
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 (Graded)

Field
Description
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)

Field
Description
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 QuestionsLink to Survey Questions

Table 8. Multiple Choice (Survey)

Field
Description
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 9. Multiple Response (Survey)

Field
Description
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 10. True/False (Survey)

Field
Description
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 11. Short Answer (Survey)

Field
Description
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 FeedbackNot used.
Points

Not used.


Table 12. Matching (Survey)

Field
Description
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.