Template Guide

LearnDash Quiz Import/Export uses a standard template to import and export all LearnDash question types. This template should be filled in the given order to create your own templates for import/export.

Downloading The Template:

The standard template can be found in the plugin folder:

LearnDash-quiz-import-export > Documentation > Standard Template.xls

Completing The Template:

Note that the LearnDash Quiz Import/Export template supports special characters and has been tested with dozens of languages. If you need to import quizzes that contain special characters, please input your file encoded in UTF-8 format. This will ensure all quizzes are imported accurately and avoid the conversion of strings like “≤, ÷, ∑, ∛, µ” into unwanted characters.

The template contains the standard LearnDash question field names as column names. You will use the following columns, which translate to LearnDash quiz questions:

LearnDash Quiz Import/Export Template Guide

1. Quiz Title

This column will hold the quiz title for the quiz to be imported.

2. Quiz Content

This column will hold quiz content/description in text/HTML format.

3. Quiz category

This column will hold quiz category(s) in text format, separated by a comma.

4. Quiz tags

This column will hold quiz tag(s) in text format, separated by a comma.

5. Question

The column represents the type of LearnDash question. This column can have the following values corresponding to the LearnDash question types.

• Single => Single choice
• Multiple => Multiple choices
• Sort_answer=> Sorting choice
• cloze_answer => Fill in the blank
• free_answer => Free choice
• matrix_sort_answer => Matrix Sorting choice
• assessment_answer => Assessment
• essay => Essay / Open Answer

Note: The left column above contains the template values and the column on the right lists the corresponding LearnDash question types.

6. Category

The column should contain the value for the LearnDash question category field.

7. Title

This represents the question title for a LearnDash quiz question.

Note: Same question titles are not allowed in a single quiz.

8. Total Points

The column represents the total points for each answer. It can be left empty for all question types except the essay-type questions. For all other question types, the total points are calculated from their individual answers. However, in essay-type questions, the column is used to assign a point value to each essay question.

9. Show points in box

This option should be set to “yes” if you want to show the reached points in the correct and incorrect messages. This column will only work if the value of another column, “Different Points for each answer,” is also set as “yes”. Otherwise, you can set it to “no”.

10. Answer # and Point # Columns

These columns should be set according to the maximum number of answers present in any of the questions for the particular quiz import.
If a quiz contains 13 answers for a particular question, there should be 13 columns in the template.

From:

Answer 1 – Answer 13

Point 1 – Point 13

This column will contain all the answers that are available for a question. If a question has fewer answers than the maximum answer # column, then simply leave the unused columns empty. The point # column associates points with each answer. This column is used when the “different points for each answer” option is enabled.

Note:

For a matrix sort answer, the value inside these answer columns should be in this format {criterion}{element}

11. Allow HTML # and Allow HTML sort # Columns

“Allow HTML #” column should be used for the following questions type only:

• Single choice
• Multiple choice
• “Sorting” choice
• “Matrix Sorting” choice

“Allow HTML #” column should be set to “yes” if you want to check the “Allow HTML” option for the respective answer. Otherwise, leave it empty.
 Similarly, “Allow HTML sort #” should be used for the “Matrix Sorting” choice question type only. “Allow HTML sort #” column should be set to “yes” if you want to check the “Allow HTML” option for the “Sort elements” column of “Matrix Sorting” choice” question type only. Otherwise, set it to “no” if you want the “Allow HTML sort” option for the “Sort elements” column of “Matrix Sorting” choice” question type to be kept unchecked.

12. Answer

After the individual answer and points column, you will find a column titled “Answer”. This column serves multiple purposes that vary according to the question type.

Single choice

→ For a single-choice answer, this column represents the correct answer from all the choices.

Multiple choices

Multiple correct answers can be defined by placing a pipe sign (|) between them. For example, if there are 5 options (1,2,3,4,5) available and only (2,3,5) are correct, then it can be defined like this: 2|3|5.

Free choice

→ For a free choice answer, the column represents the single answer for this question type, as there can only be one answer. The answers can, however, be separated through line breaks. To add multiple answers for a free choice using this column, you need to add line breaks in the spreadsheet cell.

For e.g:

• value1
• value2
• value3

(To add a line break in an Excel file, use ALT + Enter when typing in the selected column cell)

“Sorting” choice

→ For the “Sorting” choice answer, provide all the answers in the Answer # column in order. E.g. answer provided in the “Answer 1” column will come at the top, then the “Answer 2” column, then the “Answer 3” column and so on.

“Matrix Sorting” choice

→ For the “Matrix Sorting” choice answer, provide all the answers in the Answer # column in order.  E.g. answer provided in the “Answer 1” column will come at the top, then the “Answer 2” column, then the “Answer 3” column and so on.

Provide “Criterion” and “Sort elements” column content in the “Answer #” columns in the following format: {Criterion content }{Sort elements content}

Note: You can use HTML here for both columns as well.

Assessment

→ For an assessment answer, the answer column represents the single answer values for this question type. The answer should be typed in the following format:

{[ans1][ans2][ans3]}

Fill In the Blank

→ For a closed (fill in the blank) answer, the column represents the value for the single correct answer for this question type. The answer should be typed in the following format:

This is a sample {cloze|5} question and it represents a sample cloze {type} question.

Note: A blank answer should be enclosed in {} and to enable a different number of points for each blank answer, the point has to be added after the pipe (|). If there is no separate point for each blank, then there is no need to add the pipe (|) symbol.

Essay

→ For an essay answer, the column represents the answer submission method and the grading criteria. The following combination of values can be added to define the above values for this answer type.

• Text submitted, not graded, and full points

awarded (text | not-graded-full)

• Text submitted, graded, and full points

awarded (text | graded-full)

• Text submit, not graded, and no points

awarded (text | not-graded-none)

• Upload, submit, not graded, and full points

awarded (upload | not-graded-full)

• Upload, submit, grade,d and full points

awarded (upload | graded-full)

• Upload submit, not graded, and no points

awarded (upload | not-graded-none)

13. Different points for each answer

This option should be set to “yes” if you need to set different points for each answer and “no” If you want to set a standard number of points for all answers.

14. Answer points diff modus activated

If “Different points for each answer” is set to “yes” then you can activate modus and this changes the calculation of the points. To activate modus, set the value of the “Answer Points diff Modus activated“ column to “yes” and if you don’t want to enable it, then set its value to “no”.

15. Question text

This column would fill up the question text area. You can enter HTML here as well.

16. Message with correct answer

The text added to this column will be visible if a question is answered correctly. It can be used to explain complex questions. You can enter HTML here as well.

17. Message with incorrect answer

This text will be visible if a question is answered incorrectly. It can be used to explain complex questions. You can enter HTML here as well.

18. Message same text

This option should be set to “TRUE” if you want to check the “Same text for correct- and incorrect-message?” option checkbox on the question’s edit page in the “Message with the correct answer (optional)” metabox. Otherwise, leave it empty.

19. Hint

Here you can enter a hint for the question-answer.

20. Materials

Supporting material for the quiz can be plain text or HTML.

21. Certificate awarded for

Required percentage to award a certificate.

22. Passing percentage

Required percentage to pass a quiz.

23. Course

LearnDash course post ID to associate the quiz with.

24. Lesson or topic

Enter the LearnDash lesson post ID to associate the quiz with (in this case, it will be treated as a lesson’s quiz) or the LearnDash topic post ID to associate the quiz with (in this case, it will be treated as a topic’s quiz).

25. Certificate

LearnDash certificate post ID to assign to the quiz.

Note: If you don’t want to enter data in certain columns of the template, you can simply leave those fields blank. The system will ignore empty fields during the import process.

LearnDash Advanced Quizzes Add-on Support

The LearnDash Advanced Quizzes add-on offers new question types and some advanced quiz settings that are not offered by default by LearnDash LMS.

The 5 new question types offered by the LearnDash Advanced Quizzes add-on are:

1. Jumbled Questions
2. Swipe Questions
3. Calculated Formula 
4. Drag & FIll
5. Audio

The advanced questions setting is:

1. Negative Marking
2. Different Time Limits for each question

LearnDash Advanced Quizzes Support (Template Guide)

To use LearnDash Quiz Import/Export and Advanced Quizzes together, you’ll need to use a standard template to import and export all LearnDash question types and the advanced quizzes question types and settings. This template should be filled in the given order to successfully import/export quizzes that include the Advanced Quizzes question types and settings.

Downloading The Template: The advanced quizzes supported template can be found in the plugin folder:

LearnDash-quiz-import-export > Documentation > Sample Template with Advanced Quiz Support.xls

The template contains the standard LearnDash question fields represented as columns with support for LearnDash Advanced Quizzes add-on features. On this template, the following columns should be filled to import information from the spreadsheet and translate data to LearnDash quiz questions:

1. Quiz Title

This column will hold the quiz title for the quiz to be imported.

2. Quiz Content

This column will hold quiz content/description in text/HTML format.

3. Quiz category

This column will hold quiz category(s) in text format, separated by a comma.

4. Quiz tags

This column will hold quiz tag(s) in text format, separated by a comma.

5. Question

This column represents the LearnDash question type and includes support for the question types and settings offered by LearnDash Advanced Quizzes Addon. This column can have the following values, which correspond to the LearnDash question types.

• Single => Single choice
• Multiple => Multiple choices
• Sort_answer => Sorting choice
• cloze_answer => Fill in the blank
• free_answer => Free choice
• matrix_sort_answer => Matrix Sorting choice
• assessment_answer => Assessment
• essay => Essay / Open Answer
• laq_jumbled_sentence => Jumbled Sentence Question
• laq_swipe_questions => Swipe Question
• laq_calculated_formula => Calculated Formula 

Note: The left column above contains the template values and the column on the right lists the corresponding default LearnDash and LearnDash Advanced Quizzes Addon question types.

6. Category

The column should contain the value for the LearnDash question category field.

7. Title

This represents the question title for a LearnDash quiz question.

Note: Same question titles are not allowed in a single quiz.

8. Total Points

The column represents the total points for each answer. It can be left empty for all question types except the essay-type questions. For all other question types, the total points are calculated from their individual answers. This column is only significant for essay-type questions since it is used to assign points to each essay question.

9. Show points in box

This option should be set to “yes” if you want to show the reached points in the correct and incorrect messages. This column will only work if the value of another column, “Different Points for each answer,” is also set as “yes”. Otherwise, you can set it to “no”.

10. Sub question text

This column will be of use if your Question type is Jumbled Sentence, Calculated Formula or “Drag & Fill” Question

• For Jumbled Questions, use this column to add your question’s text with the variables enclosed in square brackets. 

E.g.. By landmass, Earth’s biggest continent is [x] and the country is [y].

The ‘[x]’ and ‘[y]’ are the variables for which answers are given in the following columns.

• For Calculated Formula Questions, use this column to denote your calculation formula along with the variables. Variables should be enclosed in square brackets.

E.g.  [x]+[y]=? | [a]+[b]=?

The ‘[a]’, ‘[b]’, ‘[x]’ and ‘[y]’ are the variables for which answers are given in the following columns.

• For “Drag & Fill” Questions, use this column to add your question’s text with the variables enclosed in square brackets.

E.g.. By landmass, Earth’s biggest continent is [x] and the country is [y].

The ‘[x]’ and ‘[y]’ are the variables for which answers are given in the following columns.

11. Question blank option

This option should be set to “yes” if you want to check the “Blank Option on jumbled dropdowns?” option checkbox on the question’s edit page in the “Answers (required)” metabox. Otherwise, leave it empty.

12. Question randomize option

This option should be set to “yes” if you want to check the “Randomize Options in Dropdown” option checkbox on the question’s edit page in the “Answers (required)” metabox. Otherwise, leave it empty.

13. Additional Question Settings

Use this column if your question contains Negative Marking. You can use this column too if you want to if you want your quiz to have different time limits for each question.

The Negative Marking and Different Time Limits can be denoted in this column following the formatting example below:
“{“negative_points”:4,”time_limit”:40}”

Here, “4” is the negative points assigned for wrong answers and 40 is the number of seconds allotted for the question.

If you don’t want the question to contain Negative marking or Different Time limits, add ‘0’ in the spot where these numbers would be added. 

Note: If you want to use this column, then make sure the “Allow negative marking?” and “Different time limits for each question?” options are enabled in the “LearnDash Advance Quizzes” addon; these 2 options will not be imported.

If you only want to use the “Allow negative marking?” option, then the format will be as follows:
{“negative_points”:10}

Similarly, if you only want to use the “Different time limits for each question?” option,n then the format will be as follows:
{“time_limit”:100}

14. Answer # and Point # Columns

These columns should be set according to the maximum number of answers present in any of the questions for the particular quiz import.

If a quiz contains 13 answers for a particular question, there should be 13 columns in the template.

From:

Answer 1 – Answer 13

Point 1 – Point 13

This column will contain all the answers that are available for a question. If a question has fewer answers than the maximum answer # column, then simply leave the unused columns empty. The point # column associates points with each answer. This column is used when the “different points for each answer” option is enabled.

If your Question type is a jumbled sentence, the answer columns will be dependent on the number of variables your question contains. Answer 1 will contain the number of choices offered for the First variable of your question and Answer 2 column will have the choices offered for the second variable of the question, respectively.

If the Question type is Swipe Question, this will contain the choices for the swipe questions.

If your question type is Calculated Formula, this column will contain the Calculation formula as well as the values of the variables of the questions you want to offer.

E.g.. If our calculation formula for the question is ‘[x] + [y]’ and we want to offer the value of x as 1 or 2 and the  value of y as 3 or 4, we will fill the column as

 “ [x] + [y] | 1,2|3,4 ”

If your Question type is a “Drag & Fill” question, the answer columns will be dependent on the number of variables your question contains. Answer 1 will contain the number of choices offered for the First variable of your question and Answer 2 column will have the choices offered for the second variable of the question, respectively.

Provide the correct value for a variable in the format:
“x”|”Washington”|no

Where “x” is the variable with the respective value “Washington”.

Note:

For a matrix sort answer, the value inside these answer columns should be in this format {criterion}{element}

15. Answer

After the individual answer and points column, you will find a column titled “Answer”. This column serves multiple purposes that vary according to the question type.

Single choice

→ For a single-choice answer, this column represents the correct answer from all the choices.

Multiple choices

Multiple correct answers can be defined by placing a pipe sign (|) between them. For example, if there are 5 options (1,2,3,4,5) available and only (2,3,5) are correct, then it can be defined like this: 2|3|5.

Free choice

→ For a free choice answer, the column represents the single answer for this question type, as there can only be one answer. The answers can, however, be separated through line breaks. To add multiple answers for a free choice using this column, you need to add line breaks in the spreadsheet cell.

For e.g:

• value1
• value2
• value3

(To add a line break in an Excel file, use ALT + Enter when typing in the selected column cell.)

“Sorting” choice

→ For the “Sorting” choice answer, provide all the answers in the Answer # column in order. E.g. answer provided in the “Answer 1” column will come at the top, then the “Answer 2” column, then the “Answer 3” column and so on.

“Matrix Sorting” choice

→ For the “Matrix Sorting” choice answer, provide all the answers in the Answer # column in order.  E.g. answer provided in the “Answer 1” column will come at the top, then the “Answer 2” column, then the “Answer 3” column and so on.

Provide “Criterion” and “Sort elements” column content in the “Answer #” columns in the following format: {Criterion content }{Sort elements content}

Note: You can use HTML here for both columns as well.

Assessment

→ For an assessment answer, the answer column represents the single answer values for this question type. The answer should be typed in the following format:

{[ans1][ans2][ans3]}

Fill In the Blank

→ For a closed (fill in the blank) answer, the column represents the value for the single correct answer for this question type. The answer should be typed in the following format:

This is a sample {cloze|5} question and it represents a sample cloze {type} question.

Note: A blank answer should be enclosed in {} and to enable a different number of points for each blank answer, the point has to be added after the pipe (|). If there is no separate point for each blank, then there is no need to add the pipe (|) symbol.

Essay

→ For an essay answer, the column represents the answer submission method and the grading criteria. The following combination of values can be added to define the above values for this answer type.

• Text submit, not graded, and full points

awarded (text | not-graded-full)

• Text submit, graded and full points

awarded (text | graded-full)

• Text submit, not graded, and no points

awarded (text | not-graded-none)

• Upload submit, not graded, and full points

awarded (upload | not-graded-full)

• Upload submit, graded, and full points

awarded (upload | graded-full)

• Upload submit, not graded, and no points

awarded upload | not-graded-none

Jumbled Questions

→This column contains the correct answer to the question. It represents the correct answer(s) from all the choices. The pattern to indicate the correct choice is as follows:

The pipe (|) sign is used to separate answer numbers in a list when your question has more than 1 variable. For example, if a question has 5 different answers, the formatting would look as follows: |1|2|3|4|5. However, only the correct answer numbers should be included in this format (therefore, numbers representing incorrect answers should be deleted). For example, if only answers 2,3, and 5 were correct, you should fill this column as follows |2|3|5 and leave the other spaces blank. If all answers are correct, then all answers should be listed.

 Additional Example:

|2|4|6 → This indicates that answers # 2,4 and 6 are correct for this multiple choice question and answers # 1,3 and 5 are not correct.

Swipe Questions

→It contains the correct answer to the question. It represents the correct answer(s) from all the choices. The pattern to indicate the correct choice is as follows:

The pipe (|) sign is used to separate answer numbers in a list if there is more than one correct accepted answer. For example, if a question has 5 different answers, the formatting would look as follows: |1|2|3|4|5. However, only the correct answer numbers should be included in this format (therefore, incorrect answers should be deleted. For example, if only answers 2,3, and 5 were correct, you should fill this column as follows: |2|3|5. If all answers are correct, then all answers should be listed.

 Additional Example:

|2|4|6 → This indicates that answers # 2,4 and 6 are correct for this multiple choice question and answers # 1,3 and 5 are not correct.

Calculated Formula Questions

→If your question type is a calculated formula question, then leave this column empty.

Drag & Fill Questions

→If your question type is a Drag & Fill question, then leave this column empty.

Audio Questions

→If your question type is an audio question, then leave this column empty.

16. Different points for each answer

This option should be set to “yes” if you need to set different points for each answer and “no” If you want to set a standard number of points for all answers.

17. Answer points diff modus activated

If “Different points for each answer” is set to “yes” then you can activate modus and this changes the calculation of the points. To activate modus, set the value of the “Answer Points diff Modus activated“ column to “yes” and if you don’t want to enable it, then set its value to “no”.

18. Question text

This column would fill up the question text area. You can enter HTML here as well.

19. Message with correct answer

The text added to this column will be visible if a question is answered correctly. It can be used to explain complex questions. You can enter HTML here as well.

20. Message with incorrect answer

This text will be visible if a question is answered incorrectly. It can be used to explain complex questions. You can enter HTML here as well.

21. Message same text

This option should be set to “TRUE” if you want to check the “Same text for correct- and incorrect-message?” option checkbox on the question’s edit page in the “Message with the correct answer (optional)” metabox. Otherwise, leave it empty.

22. Hint

Here you can enter a hint for the question-answer.

23. Materials

Supporting material for the quiz can be plain text or HTML.

24. Certificate awarded for

Required percentage to award a certificate.

25. Passing percentage

Required percentage to pass a quiz.

26. Course

LearnDash course post ID to associate the quiz with.

27. Lesson or topic

Enter the LearnDash lesson post ID to associate the quiz with (in this case, it will be treated as a lesson’s quiz) or the LearnDash topic post ID to associate the quiz with (in this case, it will be treated as a topic’s quiz).

28. Certificate

LearnDash certificate post ID to assign to the quiz.

Note:
If you don’t want to enter data in certain columns of the template, you can simply leave those fields blank. The system will ignore empty fields during the import process.

LearnDash Multi-Question Categories Add-on Support

The LearnDash Multi Question Categories add-on organizes your LearnDash question bank by assigning multiple categories to a single question.

LearnDash Multi Question Categories Support (Template Guide)

To use LearnDash Quiz Import/Export and Multi Question Categories together, you’ll need to use a multi-question category template to import and export all LearnDash question types and the multi-question category question types and settings. This template should be filled in the given order to successfully import/export quizzes that include the multi-question category question types and settings.

Downloading The Template: The multi-question category supported template can be found in the plugin folder:

learndash-quiz-import-export > sample-import-files > sample-template-with-multi-question-category.xls

The template contains the standard LearnDash question fields represented as columns with support for the LearnDash Multi Question Categories add-on features. On this template, the following columns should be filled to import information from the spreadsheet and translate data to LearnDash quiz questions:

1. Quiz Title

This column will hold the quiz title for the quiz to be imported.

2. Quiz Content

This column will hold quiz content/description in text/HTML format.

3. Quiz category

This column will hold quiz category(s) in text format, separated by a comma.

4. Quiz tags

This column will hold quiz tag(s) in text format, separated by a comma.

5. Question

This column represents the LearnDash question type and includes support for the question types and settings. This column can have the following values, which correspond to the LearnDash question types.

• Single => Single choice
• Multiple => Multiple choices
• Sort_answer => Sorting choice
• cloze_answer => Fill in the blank
• free_answer => Free choice
• matrix_sort_answer => Matrix Sorting choice
• assessment_answer => Assessment
• essay => Essay / Open Answer

Note: The left column above contains the template values and the column on the right lists the corresponding default LearnDash question types.

6. Category

The column should contain the value for the LearnDash question category field.

7. Multi question category

This column contains the Multi Question Categories, which include parents & children.

Multi categories examples:

• Category A > Category A1 

In this example, Category A is the parent while Category A1 is the child and after importing, Category A1 will be selected.

• Category A, Category A > Category A1 

In the example, both Category A are the parents while Category A1 is the child and after importing, Category A and A1 will be selected.

Note:

• “>” This sign represents a parent-child relationship.
• Each category should be created with a comma in between.

8. Title

This represents the question title for a LearnDash quiz question.

Note: Same question titles are not allowed in a single quiz.

9. Total Points

The column represents the total points for each answer. It can be left empty for all question types except the essay-type questions. For all other question types, the total points are calculated from their individual answers. However, in essay-type questions, the column is used to assign a point value to each essay question.

10. Show points in box

This option should be set to “yes” if you want to show the reached points in the correct and incorrect messages. This column will only work if the value of another column, “Different Points for each answer,” is also set as “yes”. Otherwise, you can set it to “no”.

11. Answer # and Point # Columns

These columns should be set according to the maximum number of answers

present in any of the questions for the particular quiz import.

If a quiz contains 13 answers for a particular question, there should be 13 columns in the template.

From:

Answer 1 – Answer 13

Point 1 – Point 13

This column will contain all the answers that are available for a question. If a question has fewer answers than the maximum answer # column, then simply leave the unused columns empty. The point # column associates points with each answer. This column is used when the “different points for each answer” option is enabled.

Note:

For a matrix sort answer, the value inside these answer columns should be in this format: {criterion}{element}

12. Allow HTML # and Allow HTML sort # Columns

“Allow HTML #” column should be used for the following questions type only:

• Single choice
• Multiple choice
• “Sorting” choice
• “Matrix Sorting” choice

“Allow HTML #” column should be set to “yes” if you want to check the “Allow HTML” option for the respective answer. Otherwise, leave it empty.
 Similarly, “Allow HTML sort #” should be used for the “Matrix Sorting” choice question type only. “Allow HTML sort #” column should be set to “yes” if you want to check the “Allow HTML” option for the “Sort elements” column of “Matrix Sorting” choice” question type only. Otherwise, set it to “no” if you want the “Allow HTML sort” option for the “Sort elements” column of “Matrix Sorting” choice” question type to be kept unchecked.

13. Answer

After the individual answer and points column, you will find a column titled “Answer”. This column serves multiple purposes that vary according to the question type.

Single choice

→ For a single-choice answer, this column represents the correct answer from all the choices.

Multiple choices

Multiple correct answers can be defined by placing a pipe sign (|) between them. For example, if there are 5 options (1,2,3,4,5) available and only (2,3,5) are correct, then it can be defined like this: 2|3|5.

Free choice

→ For a free choice answer, the column represents the single answer for this question type, as there can only be one answer. The answers can, however, be separated through line breaks. To add multiple answers for a free choice using this column, you need to add line breaks in the spreadsheet cell.

For e.g:

• value1
• value2
• value3

(To add a line break in an Excel file, use ALT + Enter when typing in the selected column cell.)

“Sorting” choice

→ For the “Sorting” choice answer, provide all the answers in the Answer # column in order. E.g. answer provided in the “Answer 1” column will come at the top, then the “Answer 2” column, then the “Answer 3” column and so on.

“Matrix Sorting” choice

→ For the “Matrix Sorting” choice answer, provide all the answers in the Answer # column in order.  E.g. answer provided in the “Answer 1” column will come at the top, then the “Answer 2” column, then the “Answer 3” column and so on.

Provide “Criterion” and “Sort elements” column content in the “Answer #” columns in the following format: {Criterion content }{Sort elements content}

Note: You can use HTML here for both columns as well.

Assessment

→ For an assessment answer, the answer column represents the single answer values for this question type. The answer should be typed in the following format:

{[ans1][ans2][ans3]}

Fill In the Blank

→ For a closed (fill in the blank) answer, the column represents the value for the single correct answer for this question type. The answer should be typed in the following format:

This is a sample {cloze|5} question and it represents a sample cloze {type} question.

Note: A blank answer should be enclosed in {} and to enable a different number of points for each blank answer, the point has to be added after the pipe (|). If there is no separate point for each blank, then there is no need to add the pipe (|) symbol.

Essay

→ For an essay answer, the column represents the answer submission method and the grading criteria. The following combination of values can be added to define the above values for this answer type.

• Text submitted, not graded, and full points

awarded (text | not-graded-full)

• Text submitted, graded, and full points

awarded (text | graded-full)

• Text submit, not graded, and no points

awarded (text | not-graded-none)

• Upload, submit, not graded, and full points

awarded (upload | not-graded-full)

• Upload, submit, grade, and full points

awarded (upload | graded-full)

• Upload submit, not graded, and no points

awarded (upload | not-graded-none)

14. Different points for each answer

This option should be set to “yes” if you need to set different points for each answer and “no” If you want to set a standard number of points for all answers.

15. Answer points diff modus activated

If “Different points for each answer” is set to “yes” then you can activate modus and this changes the calculation of the points. To activate modus, set the value of the “Answer Points diff Modus activated“ column to “yes” and if you don’t want to enable it, then set its value to “no”.

16. Question text

This column would fill up the question text area. You can enter HTML here as well.

17. Message with correct answer

The text added to this column will be visible if a question is answered correctly. It can be used to explain complex questions. You can enter HTML here as well.

18. Message with incorrect answer

This text will be visible if a question is answered incorrectly. It can be used to explain complex questions. You can enter HTML here as well.

19. Message same text

This option should be set to “TRUE” if you want to check the “Same text for correct- and incorrect-message?” option checkbox on the question’s edit page in the “Message with the correct answer (optional)” metabox. Otherwise, leave it empty.

20. Hint

Here you can enter a hint for the question-answer.

21. Materials

Supporting material for the quiz can be plain text or HTML.

22. Certificate awarded for

Required percentage to award a certificate.

23. Passing percentage

Required percentage to pass a quiz.

24. Course

LearnDash course post ID to associate the quiz with.

25. Lesson or topic

Enter the LearnDash lesson post ID to associate the quiz with (in this case, it will be treated as a lesson’s quiz) or the LearnDash topic post ID to associate the quiz with (in this case, it will be treated as a topic’s quiz).

26. Certificate

LearnDash certificate post ID to assign to the quiz.

Note:
If you don’t want to enter data in certain columns of the template, you can simply leave those fields blank. The system will ignore empty fields during the import process.

How To Import A Quiz Using Docx

Templates

You can import quizzes not only from Excel files (XLSX/XLS) but also from Word documents (.docx). There are two types of templates you can use for importing quizzes:

• The first one is for simple quizzes where each answer gives the same score.
• The second one is for quizzes that use different points for each answer.

You can find both templates in the “Import Docx” tab. When you click the download button, a ZIP file will be saved to your computer. This ZIP file includes two Word documents, one for questions and one for answers.

Note: Please note that the options available under the “General Settings” and “Quiz Settings” tabs are not supported by this feature.

Importing Quiz

To import the quiz, navigate to the “Import Docx” tab in the Quiz Import/Export menu, which is located in the LearnDash LMS plugin menu. On this tab, you are required to upload a question and answer file (in docx format) separately. Follow these steps to complete the import process:

1. Select the appropriate .docx files for the question and answer sections.
2. Click the “Upload” button to import the files.

Selecting Quiz and Configuring Options

When you upload the files, New Settings will appear. You need to choose the quiz for importing the questions. If the desired quiz does not exist, click the “create a new quiz here” link to open a new tab, create the quiz, and then return to the “Import Docx” tab to locate it by name. Next, configure the following options:

1. Display the Same Message for Incorrect Answers:

If checked, the “Same text for correct and incorrect message?” will be displayed when students attempt a question, whether the answer is right or wrong If this option is unchecked, you will have the option to display dynamic/different text for each correct and incorrect answer.

Note: Individual question settings specified in the answer .docx file will take precedence over this global setting.

2. Points for Correct Answers:

In the “points for the correct answer” field, you can assign the point to a question that is not previously defined in the answer.docx file. If no value is specified, these questions will default to 1 points.

This process ensures efficient and accurate quiz imports while maintaining flexibility for customization.

LearnDash Docx File Import Support (Template Guide)

We have added six LearnDash Question Types for Quiz Import are as follows:

1. Single choice
2.  Multiple choice
3.  “Free” choice
4.  “Sorting” choice
5.  “Matrix Sorting” choice
6.  Fill in the blank

DOCX Question File – Question Formatting Rules

• Question Numbering (Mandatory Format)
  • Use Word’s built-in numbered list
  • Format: 1. only (number followed by a dot)
  • Do not type the number manually. You must use Word’s automatic numbering feature.
  • Do not use any other format for starting question only use 1. List Format.
  • Questions will only be detected if they begin with automatic numbering in the format “1.”
• Option Formatting
  • Each option must start with formatting A. (uppercase letter + dot) such as A., B., C.
    Note: This must be applied using Word formatting. Manually typing A. will not be accepted.
  • Do NOT use a., a), or any other variation.
• Additional Notes
  • Between questions, you may use other numbering styles like 1), i), I) i.e as long as they are not used for questions or options.
  • Do not use 1., A. format in anywhere except for starting question and starting option.

Question Docx File

By following these steps, you can easily create a question docx file:

1. The numbered list format is needed to create a list of questions.
2.  Docx format allows you to use images in questions.
3.  You can also include/embed videos in the questions by “ Video Link ” shortcode. Videos can be included from different platforms like YouTube and Vimeo.
   For example:
   
   
   

1. Single choice

You can create a single-choice question by following these steps:

1. Write your questions in an ordered list format using numbers only (not alphabetically).
2. In the second step, you have to write your options in an ordered list format using alphabetical order.

2. Multiple choice

You can easily create a multiple-choice question by following these steps:

1. Format all questions using a numbered list (e.g., 1, 2, 3…).
2. For each question, display the answer choices in a lettered list using alphabet (e.g., A, B, C, D).

3. For “Free” choice

You can create a free-choice question by following these steps:

1. Format all questions using a numbered list (e.g., 1, 2, 3…).
2. You have to add the shortcode “[FC]” at the end of the question to indicate that it is a free-choice question.

4. For “Sorting” choice

You can create sorting questions by following these steps:

1. Format your question using a numbered list (e.g., 1, 2, 3…).
2. In the second step, you have to write your options in an ordered list format using alphabetical order.

5. For “Matrix Sorting” choice

To create Matrix Sorting questions:

1. Format the question using a numbered list (e.g., 1, 2, 3…).
2. List the criteria options (first column in LearnDash) in alphabetical order.

  6. For Fill in the blank

You can ask these types of questions by following these steps:

1. Format the question using a numbered list (e.g., 1, 2, 3…).
2. Insert 3–4 underscores (___) in the position where the learner should enter their answer.
3. Add the shortcode “[FB]” at the end to mark it as a Fill-in-the-Blank question. (No answer needs to be included.)

DOCX Answer File – Answer Formatting Rules

• Answer Formatting
  • Each answer must be listed using 1. format only to match the corresponding question number.
  • Do not type the number  1. to start the answer manually. You must use Word’s automatic numbering feature.
• Correct Option Labeling
  • Each answer must start with the correct option letter, written manually,
    like:
    A.
    B.
    C.
    D. etc
  • In the answer DOCX file, when listing quiz answers, do not use automatic formatting because if your question has B. option correct, an automatic list will always start with A. not B. so you must type option manually. This applies to all the 6 question types.
  • This also applies to Fill-in-the-blanks:
    Fill-in-the-blank questions, which don’t have options defined in the question docx, also require you to start their answer with A. for the first blank answer. If your question has multiple blanks, then start the first blank answer with A., second with B., third with C., and so on.
    
    For Free choice,
    Similarly like fill in the blanks it also requires you to start your answer with A.
    If a question has multiple correct answers, then you need to add answers like this.

1)
i)   A. First Option
ii)  B. Second Option
iii) C. Third Option                                                              [FP:3 ] [MC]

This is the correct message for this quiz.

See, we didn’t add any labels in the above mentioned text.

• If your question includes a correct message, incorrect message, hint, or any combination of these, they must be added in the following way. The order does not matter — you may place the hint first and the correct or incorrect message afterwards if you prefer.
  
  1) 
  i)   A. First Option
  ii)  B. Second Option
  
  I.   Correct Message:
  This is a correct message.
  
  II. Incorrect Message:
  This is an incorrect message.
  
  III.   Hint:
  This is hinting message.
• Do not use these formats anywhere in the answer docx except for the starting answer, option, correct message, incorrect message, and hint, respectively.

The following formatting options are not supported during the importing and exporting of the Questions, Message with the correct answer (optional), Message with the incorrect answer (optional) and Hint (optional):

1. Numbered List 
2. Blockquote
3. Align left
4. Align centre
5. Align right
6. Read More tag
7. Increase indent
8. Decrease indent 

The DOCX supports the following formatting options during the importing and exporting of the Questions, Message with the correct answer (optional), Message with the incorrect answer (optional) and Hint (optional):

1. Bold
2. Italic
3. Underline
4. Subscript
5. Superscript
6. Strikethrough
7. Font size
8. Text color
9. Background Color
10. Shadow on text (in clear form)
11. Links embedding
12. Links styling
13. List styling
14. Proper line breaks

Answer Docx File

By following these steps, you can create an answer docx file:

1- Use a numbered list to align each answer with its corresponding question. The numbering in the answer document should match the question numbers in the quiz.

2- After writing each answer, include the appropriate shortcode to indicate the question type:

• [SC] – Single Choice
• [MC] – Multiple Choice
• [MX] – Matrix Sorting
• [SR] – Sorting
• [FB] – Fill in the Blank
• [FC] – Free Choice

3- You can optionally include images in your answers by navigating to Insert → Image → Upload from Computer.

4- Any text written after a question-type shortcode will be treated as the default correct answer message for that question.

5- To define custom messages for correct, incorrect, or hint text, use the following headings with Uppercase Roman numeral numbering.

• Correct Message:
• Incorrect Message:
• Hint:

Note: Order of the 3 does not matter. They can be provided in any order.

6- The following shortcodes are optional and can be added after the last answer option, but before the [FP:1] (1 is the number of points to be assigned) and question type shortcode like [MC]: 

• [SM] Displays the same message for both correct and incorrect responses.
• [IA] Marks an incorrect answer (useful for negative marking in multiple-choice questions).

7- [FP:x] Assigns total points to a question.

Example: [FP:4] awards 4 points to the question.

Use this shortcode position-wise after providing the last option of the answer, [SM], [IA], and before the question type shortcode, like [MC].

8- [P:x] Assign individual points to each answer option.

Use this shortcode when you want to assign different points to each answer (i.e., when the “Different points for each answer” option is enabled in LearnDash quiz settings).

Place the shortcode after the last option of an answer (such as [SM] or [IA]) and before the question type shortcode (like [MC]).

Example:
[P:1] awards 1 point to that specific option.

1.Single Choice ([SC])

To provide a single-choice question’s answer, the steps are as follows:

1. Number your answer
2. List the correct option(s) alphabetically (A., B., etc.). Including text is optional.
3. Use the [SM] option in the respective question. If the same message should appear for both correct and incorrect answers. 
4. Add [FP:1] or [P:1] to assign points. This helps control whether the “Different points for each answer” setting is applied to that question or not.
5. Use [SC] to mark the question type.
6. Any text added after the [SC] shortcode will automatically be treated as the default correct answer message.
7. To define messages manually for each question, use the following headings with uppercase Roman numeral numbering:
   • Correct Message:
   • Incorrect Message:
   • Hint:

2.Multiple choice

To create a multiple-choice question’s answer, the steps are as follows:

• Number your answer
• Use lowercase Roman numerals (i, ii, iii, …) to indicate multiple correct answers.
  List the correct options in alphabetical order (A., B., C., etc.) as shown in the question DOCX file. Including the option text after each letter is optional.
• Use the [SM] shortcode in the last option to enable the “Same text for correct and incorrect message” setting.
  List correct options alphabetically (A., B., etc.); adding text is optional.
• Use the [IA] shortcode to mark incorrect answers for negative scoring. This is optional.
• Use [FP:1] or [P:1] to assign individual points and control whether the “Different points for each answer” option is applied.
• End question with [MC].
• Any text added after the [MC] shortcode will be treated as the default correct answer message.
• To specify custom messages for each question, use the following headings with uppercase Roman numeral numbering:
  • Correct Message:
  • Incorrect Message:
  • Hint:

3.Free Choice ([FC])

To provide a free-choice question’s answer, the steps are as follows:

• Number your answer
• For single or multiple correct answers, list them alphabetically (A., B., etc.) as in the question DOCX file. Including the option text after each letter is optional.
  Use lowercase Roman numerals (i, ii, iii, …) if indicating multiple correct answers explicitly.
• Use the [SM] shortcode to show the same message for both correct and incorrect answers in a question.
• Use [FP:1] or [P:1] to assign points and enable the “Different points for each answer” setting.
  
  Assign points in either format:
  • A. 10.8 litres   [P:4]     (Using [P:4] shortcode)
  • B. 11 |3                       (Using a vertical bar followed by the points)
• Use the [FC] shortcode and place it at the end of the answer.
• Any text placed after the [FC] shortcode will be treated as the default correct answer message.
• To provide detailed messages for each question, use the following headings with uppercase Roman numeral numbering:
  • Correct Message:
  • Incorrect Message:
  • Hint:

4.Sorting Choice ([SR])

To provide a sorting-choice question’s answer, the steps are as follows:

1. Number your answer
2. Use lowercase Roman numerals (i, ii, iii, …) to indicate the correct answer order.
   List the answers alphabetically (A., B., etc.) as in the question DOCX file. Including the option text is optional.
3. Use the [SM] shortcode to show the same message for both correct and incorrect answers when needed.
4. Use [FP:1] or [P:1] to assign points and control the “Different points for each answer” setting.
5. Use the [SR] shortcode for the question and place it at the end of the answer.
6. Any text placed after the [SR] shortcode will be treated as the default correct answer message.
7. To provide custom messages for each question, use the following headings with uppercase Roman numeral numbering:
   • Correct Message:
   • Incorrect Message:
   • Hint:

5.”Matrix Sorting” choice

To provide a “Matrix Sorting” choice question’s answer, the steps are as follows:

1. Number your answer
2. Use lowercase Roman numerals (i, ii, iii, …) to list all correct pairs.
   Provide answers alphabetically (A., B., etc.) and include the matching text from the second column of the LearnDash “Sort Elements” table.
3. Use the [SM] shortcode to show the same message for both correct and incorrect answers.
4. Use [FP:1] or [P:1] to assign points and enable the “Different points for each answer” setting.
5. Use the [MX] shortcode for the question and place it at the end of the answer.
6. Any text placed after the [MX] shortcode will be treated as the default correct answer message.
7. To provide custom messages for each question, use the following headings with uppercase Roman numeral numbering:
   • Correct Message:
   • Incorrect Message:
   • Hint:

6.Fill in the Blank ([FB])

To create a fill-in-the-blank question’s answer, the steps are as follows:

• Number your answer
• List the correct answer(s) alphabetically (A., B., etc.) as in the question DOCX file. Including the option text is optional.
  For multiple correct answers, use lowercase Roman numerals (i, ii, iii, …).
• Use the [SM] shortcode in the last option to show the same message for both correct and incorrect answers when needed.
• Use [FP:1] or [P:1] to assign points and enable the “Different points for each answer” setting.
  Assign points using one of these formats:
  •  A. Six    [P:2]       (Using [P:2] shortcode)
  • B.  [60 |3] [59 |2]     (using square brackets and a vertical bar for multiple answers with different points)
• Use the [FB] shortcode for the question and place it at the end of the answer.
• Any text placed after the [FB] shortcode will be treated as the default correct answer message. 
• To define custom messages for each question, use the following headings with uppercase Roman numeral numbering:
  • Correct Message:
  • Incorrect Message:
  • Hint: