> For the complete documentation index, see [llms.txt](https://helpdesk.ldtsoft.work/ldt-online-course/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://helpdesk.ldtsoft.work/ldt-online-course/quizzes-and-certificates/bulk-importing-quiz-questions-for-your-courses.md).

# Bulk Importing Quiz Questions for Your Courses

Import quiz questions from a CSV file instead of typing each one

This guide will show you how to quickly create a quiz with a large number of questions by uploading a single CSV file.

This is the fastest way to migrate an existing question bank from another system (like Google Forms, Word, or Excel) into your LDT course.

### Prerequisites

* **Course** and **Module** are already created: You have an available lesson within a module to add the quiz to. Follow [this guide to create your new course](https://helpdesk.ldtsoft.work/ldt-online-course)

### 1. Add a Quiz to Your Lesson

First, you need to create the quiz content block within your course lesson.

Navigate to your lesson: Go to **Courses** > Select your course > Select your module > Select or create a Lesson.

* **Add new content**: In the lesson, scroll down to the Contents section and click + Add new content.
* Select content type: Choose "**Quiz/tests**" from the list.
* Name your quiz: Enter a Content title.

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-aa5f934008208d911fe8f7501da81a25a02efa67%2Fbulk-import-content-dialog.png?alt=media" alt="Choosing Quiz / tests in the Add lesson content dialog"><figcaption></figcaption></figure>

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-75ab8437ad644452ad31597fe9db0c0c4726fea0%2Fbulk-import-quiz-block.png?alt=media" alt="The quiz block added to the lesson, with its first question"><figcaption></figcaption></figure>

### 2. Access the Bulk Import Feature

After adding the quiz content block, you'll find the option to import questions.

* Within the quiz setup interface, look for and click the **Add questions in bulk** button.
* A new window will appear with an Upload your csv file option and a Download sample csv link.

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-151f29311bf3466d8d8f7ec85c072dce8a90227d%2Fbulk-import-add-bulk.png?alt=media" alt="The quiz question list with the Add question, Add questions in bulk and Sort questions buttons"><figcaption></figcaption></figure>

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-c6d83662f3be5f9d00964832e71fb04df664ee34%2Fbulk-import-modal.png?alt=media" alt="The Import questions window with Upload your csv file and Download sample csv"><figcaption></figcaption></figure>

### 3. Download the CSV Template and Fill in Your Questions

This is the most critical step. Follow these instructions precisely to avoid errors.

* **Download the template**: Click Download sample csv to get the template. ALWAYS use this template to ensure the correct format.
* **Fill in the information**: Populate the columns with your question data. The key columns are:
* **Question**: The text of your question.
* **Type**: The question type. Enter "Choice" for multiple-choice or "Essay" for a free-response question.
* **Explanation**: An optional explanation for the answer.
* **Answer**: The text of the answer choice.
* **Is Correct**: Mark whether an answer is correct. Enter "Yes" for the correct answer and "No" for incorrect ones.

| Question                                    | Type   | Explanation                      | Answer | Is Correct |
| ------------------------------------------- | ------ | -------------------------------- | ------ | ---------- |
| Which of the following is a mammal?         | Choice | Mammals give birth to live young | Cat    | Yes        |
| Which of the following is a mammal?         | Choice |                                  | Fish   | No         |
| Which of the following is a mammal?         | Choice |                                  | Bird   | No         |
| Describe the water cycle in your own words. | Essay  |                                  |        |            |

### IMPORTANT RULES FOR FORMATTING THE CSV FILE:

* Multiple Choice Questions (Type: "Choice"):
* A single question will span MULTIPLE ROWS in the CSV file, with each row representing one answer option.
* The row containing the correct answer should have "Yes" in the "Is Correct" column.
* Essay Questions (Type: "Essay"):
* Only ONE ROW is needed for an essay question.
* The "Answer" and "Is Correct" columns can be left blank.

### 4. Upload the CSV File

Once your CSV file is complete and saved, you can upload it.

* Go back to the import interface in LDT, click **Upload** your csv file, and select your file.
* The system will process and import all the questions directly into your quiz.

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-aadfb757c394c65679a0c908e9651da7e582a326%2Fcourse%20a.7.png?alt=media" alt="The quiz with the imported questions after the CSV upload"><figcaption></figcaption></figure>

### 5. Review and Configure Additional Settings

After importing, take a moment to review the quiz to ensure everything looks correct. You can also configure additional settings:

* **Display mode**: Choose between Slide (one question at a time) or Scrollable (all questions on one page).
* **Students must pass this quiz to complete the lesson**: Check this box to prevent students from progressing until they pass the quiz.
* **Maximum attempts**: Leave this field empty for unlimited retakes, or enter a specific number.
* **Allow students to view a results summary**: Check this to let students see their results after completion.

### Result

The quiz now holds every question from the CSV. Multiple-choice questions are grouped from their rows, essay questions are single rows, and the settings you chose (display mode, pass requirement, attempts, results summary) apply when students open the quiz.

### Troubleshooting

* **The import fails or adds no questions.** Start from the downloaded sample CSV and keep its exact column names; a changed header or a missing `Question`/`Type` value stops the import.
* **A choice question shows only one answer.** Each answer is a separate row with the same question text; keep the question rows together.
* **An essay question is missing.** Essay rows need `Type` = `Essay`; leave `Answer` and `Is Correct` blank.
* **The wrong answer is marked correct.** Exactly one choice row per question should have `Is Correct` = `Yes`.
* **The quiz looks wrong after import.** Reopen the quiz and review the questions; fix the CSV and import again if needed.

### Related pages

* [How to set up a quiz in a lesson](https://helpdesk.ldtsoft.work/ldt-online-course/quizzes-and-certificates/how-to-set-up-a-quiz.md)
* [How to Review and Grade Student Quizzes and Tests](https://helpdesk.ldtsoft.work/ldt-online-course/quizzes-and-certificates/how-to-review-and-grade-student-quizzes-and-tests.md)
* [Want to Test Student Knowledge? Here's How to Add Quizzes to Your Lessons](https://helpdesk.ldtsoft.work/ldt-online-course/quizzes-and-certificates/want-to-test-student-knowledge-heres-how-to-add-quizzes-to-your-lessons.md)

<br>
