> ## Documentation Index
> Fetch the complete documentation index at: https://help.autoproctor.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk Import Questions from Excel

> Import multiple-choice questions from an Excel file into your Socratease quiz.

The Bulk Import feature lets you import multiple-choice questions from an Excel file into Socratease Quizzes. This saves significant time when you have many questions in an existing Excel or Word format, or when multiple people collaborate on a large question set.

<Note>
  Bulk Import is available to **Elite Plan** customers only. See [Elite Features](/elite-plan-features) for details.
</Note>

## How to Import Questions

<Frame caption="How to import questions from Excel into Socratease">
  <video controls className="w-full rounded-xl" src="https://mintcdn.com/autoproctor/zjKbapH90wQjAvW2/videos/socratease/import-from-excel.mp4?fit=max&auto=format&n=zjKbapH90wQjAvW2&q=85&s=dd88c9a52d58425a7b881efe6820ff58" data-path="videos/socratease/import-from-excel.mp4" />
</Frame>

<Steps>
  <Step title="Download the Template">
    Open your quiz in the Socratease editor and download the Excel template. This template contains the required column headers and formatting.
  </Step>

  <Step title="Add Questions to the Excel File">
    Fill in the template with your questions, answer choices, and correct answer indicators. See the column reference below for details on each field.
  </Step>

  <Step title="Upload the Excel File">
    Upload the completed Excel file to your quiz. The questions import automatically and appear in your quiz editor.
  </Step>
</Steps>

## Excel Template Column Reference

| Column             | Required | Description                                                                                                                                                  |
| ------------------ | :------: | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Question Type**  |    Yes   | `MCQ` for single correct answer, or `MCA` for multiple correct answers                                                                                       |
| **Question**       |    Yes   | The question text                                                                                                                                            |
| **Opt1 -- Opt5**   |    No    | Answer choices. Use only as many as needed (e.g., if you have 3 options, fill Opt1, Opt2, Opt3 and leave Opt4 and Opt5 blank)                                |
| **CorrectAnsInd**  |    Yes   | For MCQ: a single number indicating the correct option (e.g., `2` for Opt2). For MCA: comma-separated numbers without spaces (e.g., `2,3` for Opt2 and Opt3) |
| **Markdown**       |    No    | Enter `1` to format the question text as Markdown                                                                                                            |
| **Points**         |    No    | Point value for a correct answer                                                                                                                             |
| **Time (seconds)** |    No    | Time limit per question, in seconds                                                                                                                          |
| **Image**          |    No    | A direct URL to an image file (.jpg, .png, etc.) to display with the question                                                                                |

<Warning>
  The **Image** column requires a direct URL to the image file. Google Drive sharing links are **not** supported. Use a direct link that ends in a file extension like `.jpg` or `.png`.
</Warning>

## Tips for a Successful Import

* Fields marked with **Required: Yes** must be filled in for every question.
* You can leave optional columns blank if they are not needed.
* Make sure the column headers match the template exactly -- do not rename or reorder columns.
* For MCA questions, separate the correct answer numbers with a comma and **no space** (e.g., `2,3` not `2, 3`).
* If you import a large number of questions, consider breaking them into smaller batches to make troubleshooting easier.

<Note>
  Bulk Import currently supports **MCQ** and **MCA** question types only. For other question types, add them manually through the quiz editor. See [Question Types](/socratease-question-types) for the full list of available formats.
</Note>

## Related Resources

* [Question Types](/socratease-question-types) -- All available question formats
* [Question Banks](/question-banks) -- Create randomized question pools from your imported questions
* [Quiz Settings](/socratease-quiz-settings) -- Configure your quiz behavior
* [Question Display Mode](/question-display-mode) -- Control how questions appear to candidates
* [Elite Features](/elite-plan-features) -- Learn about Elite plan capabilities