You can instantly export quiz questions into an .xlsx file and import them from a simple spreadsheet template. Quizzes can be exported into .xls, .xlsx, .json, or .docx files, where you can quickly edit or update questions and re-import them later into LifterLMS.
Video Tutorial
Watch the tutorial video below for a quick walkthrough of the add-on’s features and setup process.
For detailed instructions, please continue reading the full documentation. If you still have any questions, feel free to submit a support ticket.
Installation
- Install the LifterLMS plugin & activate it.
- Install LifterLMS Quiz Import/Export and activate it.
- A new Quiz Import/ Export menu will appear under the LifterLMS menu.
Activate License Key
The license key can be configured from the License Option tab, found on the main LifterLMS Quiz Import/Export menu. License keys will be sent to your email address when you purchase the add-on.
Insert your license key in the field and then click on Activate.
Quiz Import Options
Passing Percentage
In this section, you can set a minimum percentage of the total points a student requires to pass a quiz.
Allowed Attempts
Enter the maximum number of times a student can take the quiz.
Time Limit
In this section, you can enter the maximum number of minutes a student can spend completing a quiz on each attempt.
Show Correct Answers
When this setting is enabled, students will be shown the correct answer to any question they answered incorrectly.
Randomize Question Order
When enabled, this setting allows you to display quiz questions in a random order, resulting in different question orders for each attempt. Content questions are locked into their defined positions.
Enable Debug Logs
When this option is enabled, the debug logs are generated for easy troubleshooting of any issue. Enabling this option will add another tab, “Debug Logs” in LifterLMS Quiz Import/Export settings, which will list the logs and the name of the log file where the logs are stored, located in the wp-content/uploads/ directory. The logs generated will be related to quiz importing and license activation.
Minimum Role to Import
This dropdown menu allows the admin to select what is the minimum user role required to import quizzes. If you want any author or editor to be able to import and export quizzes, you should select the respective role.
Google Sheet Import
Here, you can enable this option to import quiz(s) from a Google Sheet.
Google Sheet Schedule
Here, you can select the Google Sheet import schedule. Based on the interval, a cron job will run to create/update the LifterLMS quiz(es) using the columns and records in the Excel sheet. You can select from the following options:
- Every minute
- Once Hourly
- Twice Daily
- Once Daily
- Once Weekly
Google Sheet Import Link
Here, you are supposed to provide the Google sheet import link from which you want to check and import/update the LifterLMS Quiz-related information. The URL link will be in the format:
“https://docs.google.com/spreadsheets/d/1nw/edit?usp=sharing”
To create your own LifterLMS Quiz from a Google sheet, the steps are as follows:
1- Navigate to the “Import Quiz” tab and click on the “Copy Template to Google Sheet” button. Here, you will be asked to make your own online copy of the quiz-importing Excel sheet into your Google account.
2- Finally, click the “Make a copy” button.
3- Once you have created your own quiz-importing Excel sheet. Click on the “Share” button. Provide restricted access to the Excel sheet with viewer role permissions.
4- Click the “Copy link” button to copy the Excel sheet URL.
5- Finally, navigate back to the “General Settings” tab and paste the Excel sheet URL in the “Google Sheet Import Link” option text field and click the “Update Settings” button.
Delete Existing Questions
When this option is enabled, existing questions in the quiz will be deleted before new questions are imported. When this option is disabled, existing questions in the quiz will not be deleted before new questions are imported. The updated/new questions created will be added below the last question at the bottom.
Import Google Sheet Now
Here, you can click the “Import Scheduled Quizzes” button to manually run the Google Sheet import function to import/update quiz(s) from Google Sheet. After the function has been executed, your quiz-related information/content will be updated.
Google Docs Import
Here, you can enable this option to import a single quiz from a Google Doc.
Google Docs Schedule
Here, you can select the Google Doc import schedule. Based on the interval, a cron job will run to create/update the respective single LifterLMS quiz using the content in the Google Doc file links of the question and answer. You can select from the following options:
- Every minute
- Once Hourly
- Twice Daily
- Once Daily
- Once Weekly
Questions Google Doc Import Link
Here, you are supposed to provide the Google Doc question file import link from which you want to check and import/update the respective LifterLMS Quiz-related information. The URL link will be in the format:
“https://docs.google.com/document/d/1nw/edit?tab=t.0”
To create your own LifterLMS Quiz question file from a Google Doc, the steps are as follows:
1- Navigate to the “Import Quiz” tab and click on the “Copy Questions to Google Docs” button. Here, you will be asked to make your own online copy of the respective quiz’s question file into your Google account.
2- Finally, click the “Make a copy” button.
3- Once you have created your own online copy of the respective quiz’s question file. Click on the “Share” button. Provide restricted access to the Google Doc with viewer role permissions.
4- Click the “Copy link” button to copy the Google Doc URL.
5- Finally, navigate back to the “General Settings” tab and paste the Google Doc URL in the “Questions Google Doc Import Link” option text field.
Answers Google Doc Import Link
Here, you are supposed to provide the Google Doc answer file import link from which you want to check and import/update the respective LifterLMS Quiz-related information. The URL link will be in the format:
“https://docs.google.com/document/d/1nw/edit?tab=t.0”
To create your own LifterLMS Quiz answer file from a Google Doc, the steps are as follows:
1- Navigate to the “Import Quiz” tab and click on the “Copy Answers to Google Docs” button. Here, you will be asked to make your own online copy of the respective quiz’s answer file into your Google account.
2- Finally, click the “Make a copy” button.
3- Once you have created your own online copy of the respective quiz’s answer file. Click on the “Share” button. Provide restricted access to the Google Doc with viewer role permissions.
4- Click the “Copy link” button to copy the Google Doc URL.
5- Finally, navigate back to the “General Settings” tab and paste the Google Doc URL in the “Answers Google Doc Import Link” option text field and click the “Update Settings” button.
Delete Existing Questions
When this option is enabled, existing questions in the quiz will be deleted before new questions are imported. When this option is disabled, existing questions in the quiz will not be deleted before new questions are imported. The updated/new questions created will be added below the last question at the bottom.
Import Google Docs Now
Here, you can click the “Import Google Docs Now” button to manually run the Google Doc import function to import/update the respective single quiz from Google Doc. After the function has been executed, your quiz-related information/content will be updated.
Shortcodes
Shortcode # 1
You can use the [llms_qie_quiz_export] to show a button on the frontend which will allow the users to download the respective lesson’s quiz in the .docx template.
The shortcode works as follows:
1- This shortcode will only work/show for logged-in users. The [llms_qie_quiz_export] shortcode (without attributes) will only work on the lesson page, as it will automatically fetch the respective lesson’s ID.
2- To make the shortcode work on any other page, the shortcode [llms_qie_quiz_export] has 4 attributes, of which the “lesson_id” attribute is a required/mandatory attribute to be included for the shortcode’s functionality to work, like [llms_qie_quiz_export lesson_id=”123″].
3- To allow multiple users of different user roles to access the shortcode functionality on the frontend, add multiple user roles in the “role” attribute separated by a comma, like [llms_qie_quiz_export lesson_id=”123″ role=”editor,subscriber”]. This attribute is optional to use in the shortcode.
4- To get the value to enter for the “role” attribute, navigate to the “Users” menu and open any profile to the “Role” field and inspect the dropdown to get the user role value to enter in the shortcode.
5- You can use the “button_text” attribute to change the button text on the frontend pages, like [llms_qie_quiz_export lesson_id=”123″ role=”author” button_text=”Export Quiz in DOCX template”]. This attribute is optional to use in the shortcode.
6- You can use the “button_class” attribute to change the button CSS on the frontend pages, like [llms_qie_quiz_export lesson_id=”123″ role=”author” button_text=”Export Quiz (DOCX)” button_class=”llmsqie-docx-export-button”]. This attribute is optional to use in the shortcode. You can add your custom CSS on the site using your theme Customizer like:
.llmsqie-docx-export-button { background-color:red; }
Blocks
You can place the “LifterLMS Quiz DOCX Export” block on any page you want to allow the selected user roles to download the respective lesson’s quiz in a .docx template from the frontend pages. It will work just like the “[llms_qie_quiz_export]” shortcode on the frontend.
Import Quiz
To import a quiz, navigate to the “Import Quiz” tab of the LifterLMS Quiz Import/Export. Then simply select the quiz file by clicking the button next to the Import Quiz option
Spreadsheet Import
To import a quiz from an Excel file, the steps are as follows:
1- Upload the Excel file using the “Import Quiz” option. Keep in mind that your quiz file should be in .xls or .xlsx format.
2- If you want to delete any existing questions and replace them with new questions from the selected file, enable the toggle next to Delete Existing Questions. When enabled, existing questions in the same quiz will be deleted before importing new questions.
3- Finally, click the “Import XLSX” button.
Note: Quizzes imported/updated using .xls, .xlsx files will have their quiz settings updated according to the options set in the “Quiz Import Options” tab (Passing Percentage, Allowed Attempts, Time Limit, Show Correct Answers, Randomize Question Order).
JSON Import
To import a quiz from an JSON file, the steps are as follows:
1- Upload the JSON file using the “Import Quiz” option. Keep in mind that your quiz file should be in .json format.
2- If you want to delete any existing questions and replace them with new questions from the selected file, enable the toggle next to Delete Existing Questions. When enabled, existing questions in the same quiz will be deleted before importing new questions.
3- Finally, click the “Import JSON” button.
Note: Quizzes imported/updated using .xls, .xlsx files will have their quiz settings updated according to the options set in the “Quiz Import Options” tab (Passing Percentage, Allowed Attempts, Time Limit, Show Correct Answers, Randomize Question Order).
DOCX Import
To import a quiz from DOCX files, the steps are as follows:
1- Select the Quiz’s question file in the “Questions DOCX” file.
2- Select the quiz’s answer file in the “Answers DOCX” file.
3- If you want to delete any existing questions and replace them with new questions from the selected file, enable the toggle next to Delete Existing Questions. When enabled, existing questions in the same quiz will be deleted before importing new questions.
4- Click the “Import DOCX” button to start the import process.
Note: Quizzes imported/updated using .xls, .xlsx files will have their quiz settings updated according to the options set in the “Quiz Import Options” tab (Passing Percentage, Allowed Attempts, Time Limit, Show Correct Answers, Randomize Question Order).
Template
LifterLMS Quiz Import/Export offers easy-to-use templates for importing quizzes. Simply click the Download Excel Template button to acquire the .xls file, make necessary modifications, and then proceed with the import process. Similarly, click the Download DOCX Template button to download the .zip file containing the template quiz’s question and answer DOCX files.
Export Quizzes
Using the LifterLMS Quiz Import/Export add-on, you can also export any quizzes you create into an .xls, .xlsx, .json file, or a .zip file containing both the respective quiz’s question and answer .docx files. This file can then be imported into another site using this add-on. To export the quiz, follow these steps:
- Navigate to LifterLMS, select Courses, and then select Lessons.
- There will be 2 export buttons which will be listed next to every lesson that has a quiz available. You can select whichever format you want to download in.
- To export a quiz, click on the respective Export button next to the Lesson containing the quiz you want to download. The quiz will be downloaded as an .xls, .xlsx, json file or a .zip file containing both the respective quiz’s question and answer .docx files.
Bulk Export
To export multiple quizzes at once, simply put a check on the quizzes you want to export and from the Bulk Actions WordPress dropdown, select any of the respective 3 options “Export XLS Quiz”, “Export XLSX Quiz” or “Export JSON Quiz” and click on Apply.
LifterLMS Quiz Import/Export Template Guide (.xls, .xlsx files)
LifterLMS Quiz Import/Export uses a standard template to import and export all LifterLMS question types. This template should be followed to create your own files for import/export. The standard template can be generated by exporting an existing quiz from the LifterLMS > Lessons listing page.
Important
- Do not add, delete, rename, or reorder any columns in the provided template.
- Leave unused fields blank.
- Ensure all data is mapped to the correct columns before importing.
- Modifying the template structure may cause the import to fail or produce unexpected results.
Downloading The Template:
The standard template can be found in the plugin folder:
Lifter-lms-quiz-import-export > Sample-import-files > LifterLMS_Quiz_Import_Export_Sample.xls
Completing the Template:
The template contains the standard LifterLMS question field names as column names. You will use the following columns, which translate to LifterLMS quiz questions:
1. Lesson ID
In this column, you can specify the Lesson ID for the lesson you wish to associate your new quiz to. When left empty, you can associate the quiz with any lesson later on directly from the Course Builder. To do this, just select Add Quiz and then select Add Existing Quiz. Next, you will be able to select the specific quiz from the drop-down menu.
2. Quiz Title
The Quiz Title column represents the quiz title you want to assign for the LifterLMS quiz.
3. Quiz Description
The Quiz Description column represents the quiz description you want to assign for the LifterLMS quiz.
4. Question Title
In the Question Title column, you can assign each question you create for your quiz its own question title. Just add the chosen title in the specific field.
5. Question Type
This column allows you to specify what type of LifterLMS question you want to add to your quiz. The fields in this column can take any of the following values:
6. Multiple Choices
Entering Yes in this column indicates that you have more than one correct answer for a multiple-choice question type. If there’s only one correct answer to the question, simply enter No.
7. Description
By filling out a field in this column, you can provide a question description to display with your question.
8. Clarifications
In the clarifications column, you can add solution hints that students can be able to see if they need help figuring out the answer to the question.
9. Image
If your question includes images, this column provides a field to enter the image URL.
10. Video
To add video content to a quiz question, use this column to enter the video URL.
11. Points
This column represents the total points a student will be awarded for each answer.
12. Formula Data
This column represents the answer section of the “Arithmetic Questions” of our LifterLMS Quizzes Pro add-on. You need to provide the following fields in the respective format as follows:
- Formula Field
Provide the variables in enclosed rectangular brackets.
- Variable Name(s)
Provide the variables in enclosed rectangular brackets.
- Variable Minimum Value(s)
- Variable Minimum Value(s)
- Auto Grade
- yes (for enabling the toggle)
- no (for keeping the toggle disabled)
Format:
{“formula”:”[x]+[y]”,”variables”:[{“variable_name”:”[x]”,”min”:”1″,”max”:”2″},{“variable_name”:”[y]”,”min”:”3″,”max”:”4″}],”auto_grade”:”yes”}
This is how it will look after importing:
13. Swipe Data
This column represents the answer section of the “Swipe Question” of our LifterLMS Quizzes Pro addon. You need to provide the following fields in the respective format as follows:
- Answer Option Fields
- Correct Answer Field
- yes (for enabling the checkbox)
- no (for keeping the checkbox disabled)
Format:
{“items”:[{“text”:”<p>Horse<\/p>”,”correct”:”no”},{“text”:”<p>Lion<\/p>”,”correct”:”yes”},{“text”:”<p>Tiger<\/p>”,”correct”:”no”},{“text”:”\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t”,”correct”:”no”},{“text”:”\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t”,”correct”:”no”}]}
This is how it will look after importing:
14. List Data
This column represents the answer section of the “Select from List” of our LifterLMS Quizzes Pro addon. You need to provide the following fields in the respective format as follows:
- List Name(s)
Provide the variables in enclosed rectangular brackets. - List Item(s)
Provide the list items separated by a comma.
- Correct Value(s)
- Auto Grade
- yes (for enabling the toggle)
- no (for keeping the toggle disabled)
Format
{“items”:[{“shortcode”:”[helpingverb]”,”words_list”:”will, shall, might”,”correct_answer”:”will”},{“shortcode”:”[verb]”,”words_list”:”play, played, read”,”correct_answer”:”played”}],”auto_grade”:”no”}
This is how it will look after importing:
15. Correct Answers
The correct answers column is the place where you should enter all the correct answers for the different types of questions. For the multiple-choice question type, you can add multiple correct answers by separating them with a comma (,).
16. Answer: (A, B, C)
Different answer columns, allow you to add your different answer options. For True False questions, you can use the Answer A and Answer B column for True and False respectively. For multiple-choice questions simply use a separate answer column to enter each one of the possible answer choices.
LifterLMS Quiz Import/Export Template Guide (.docx file)
To create .docx question and answer files to import a quiz, the steps are as follows:
Docx Question File
1- Provide the Lesson ID after the text “Lesson ID: ”.
2- Provide the Quiz Title after the text “Quiz Title:”.
3- Provide the Quiz Description after the text “Quiz Description:”.
4- Use the following format ( 1. , 2. , 3. ) to provide questions. Write the question’s text after it.
5- Provide the question type:
[SC] – Multiple Choice (“Multiple Correct Choices” option disabled)
[MC] – Multiple Choice (“Multiple Correct Choices” option enabled)
[PC] – Picture Choice
[TF] – True or False
6- In the next line, use the “[llms_question_description]” shortcode and in the next line provide the question’s Description.
7- In the next line, use the “Clarifications:” text and in the next line provide the question’s Result Clarifications.
8- In the next line, use the “[llms_question_image]” shortcode and in the next line provide the question’s Image.
9- In the next line, use the “[llms_question_video]” shortcode and in the next line provide the question’s Video Link.
10- In the next line, use the “Points:” text and in the next line provide the question’s point(s).
11- Use Alphabetical numbering to provide the question’s options in the correct order (in the same line for [SC], [MC], [TF]). In case of [PC], Use Alphabetical numbering to provide the question’s options in the correct order, but place the images in the next line of the Alphabetical numbering.
Docx Answer File
1- Use the following format ( 1. , 2. , 3. ) to provide the question’s answers in the same order as in the question file.
2- Use the “Correct:” text and after it provide the correct option’s alphabet of the respective question in alphabetical order. In case of [MC], [PC] (multiple correct answers), you can provide multiple correct options’ alphabets separated by a comma.
3- Provide the question type:
[SC] – Multiple Choice (“Multiple Correct Choices” option disabled)
[MC] – Multiple Choice (“Multiple Correct Choices” option enabled)
[PC] – Picture Choice
[TF] – True or False
Note: We recommend you use the Excel file template to import quiz(s) if you want to set other options related to the quiz as well during quiz import process.
FAQ
Does the Add-On support all question types present in LifterLMS?
The LifterLMS Quiz Import/Export add-on supports all the default question types that are available in the free version and also supports LifterLMS Advanced Quizzes question types.
What will happen if I re-import a quiz?
When a quiz is re-imported, its content will be updated with the changes made to the Excel file.
Which excel file extension does this add-on support?
LifterLMS Quiz Import/Export only supports the .xls and .xlsx file extensions.
What does the “Delete Existing Questions” option do?
If you have enabled the “Delete Existing Questions” option, any existing questions from the quiz will be deleted first when importing an Excel file. Afterward, the questions included in the file will be added to the quiz. This will prevent any questions that had been previously imported from being duplicated.
Where can I configure the default quiz options that will be applied to imported quizzes?
You can find these settings on LifterLMS > Quiz Import/Export > Quiz Import Options tab.
Where can I find a standard XLS template?
The LifterLMS Quiz Import/Export .zip file includes a standard XLS template for quiz imports. You can locate this template in the Documentation folder stored in the main LifterLMS-quiz-import-export folder.
Changelogs
1.6.0
- Fix: Google Sheet and Google DOCX cron events now update independently and carry their source URLs as cron arguments.
- Fix: All imported and updated quizzes now explicitly apply the five General quiz behavior settings.
- Fix: Imported questions are now explicitly appended to the bottom of an existing quiz when deletion is disabled.
- New: Added a Delete Existing Questions option to JSON imports.
- New: Added scheduled Google DOCX imports using WordPress cron schedules.
- New: Added an enable toggle and conditional settings display for Google DOCX import, matching Google Sheet import.
- New: Added a Delete Existing Questions option to direct Google DOCX imports.
- New: Added separate XLS and XLSX export actions for individual and bulk lesson exports.
- New: Added JSON quiz import and export using the complete spreadsheet-compatible field schema.
- New: Added direct quiz import from public Google Docs question and answer documents.
- New: Added copy links for the Google Docs question and answer templates.
- New: Added JSON export to individual and bulk lesson actions.
1.5.1
- New: Added frontend DOCX export support using WordPress block or shortcode provided in the general settings page.
1.5.0
- New: Added DOCX import and export compatibility to export and import quizzes in DOCX file format.
1.4.2
- Fix: Fixed “Debug Log” – Copy to Clipboard button CSS.
1.4.1
- New: Added google sheet compatibility to import quizzes from google sheet directly.
1.4.0
- Fix: Improved Licensing module.
1.3.10
- Fix: Fixed license text minor issue.
1.3.9
- Fix: Questions types compatibility issues with LifterLMS Quizzes Pro.
1.3.8
- Fix: Minor compatibility issues with LifterLMS Quizzes Pro.
1.3.7
- Fix: Fixed an issue where HTML tags appeared in the Excel file after export.
- Fix: Fixed an issue where options and images were not displaying correctly after import.
1.3.6
- Fix: Fixed security and performance issues.
1.3.5
- Fix: Fixed dynamic property deprecation in LifterLMS_QIE_Plugin_Updater.
1.3.4
- New: Added Debug Log tab.
1.3.3
- Fix: Answer keys on quiz import.
- New: Added documentation and support links.
1.3.2
- New: Added support for downloading sample template from import tab.
- New: Added support for LMS Manager and Instructor to import quizzes.
- New: Updated plugin settings UI/UX.
1.3.1
- Fix: Minor compatibility issues.
1.3.0
- Fix: Compatibility issues with the latest versions of LifterLMS and WordPress.
1.2.0
- New: Support for LifterLMS Advanced Quizzes question types.
- Fix: License activation issue.
- Fix: Compatibility issues with the latest versions of LifterLMS and WordPress.
1.1.0
- Fix: Fixed lesson id issue on import.
1.0.0
- Initial Release.
