Bulk Import Questions
Bulk import lets you add many questions at once using a CSV file instead of creating them one by one. This is ideal for migrating existing question banks or preparing large exam pools.
Import Process
1
Navigate to Import
Go to Questions → Import from the sidebar.
2
Download the template
Download the CSV template for the question type you want to import. Each type has a specific column format.
3
Fill in the template
Open the CSV in a spreadsheet editor (Excel, Google Sheets). Fill in one question per row following the column format.
4
Upload the file
Click "Upload" and select your completed CSV file. The system validates the format before processing.
5
Review validation results
The system shows a preview with any errors or warnings. Fix issues in the file and re-upload, or proceed with valid rows.
6
Confirm import
Click "Import" to create all valid questions. They are created in DRAFT status by default.
CSV Template Format
The CSV template includes these common columns for all question types:
| Column | Required | Description |
|---|---|---|
type | Yes | Question type: MCQ, TRUE_FALSE, ESSAY, FILL_IN_BLANKS, MATCHING, MATRIX, HOTSPOT |
text | Yes | The question text / prompt |
points | Yes | Marks for the question (number, ≥ 0) |
difficulty | Yes | EASY, MEDIUM, or HARD |
subject | No | Subject name (must match existing subjects) |
topic | No | Topic within the subject |
tags | No | Comma-separated tags (e.g., "algebra,chapter-3") |
Type-Specific Columns
MCQ Columns
option_1,option_2,option_3,option_4— option text (minimum 2 required)correct— correct option number(s), e.g., "1" or "1,3" for multiple correctshuffle— "true" or "false"
True/False Columns
correct_value— "true" or "false"
Essay Columns
min_words— minimum word count (optional)max_words— maximum word count (optional)rubric— grading rubric text (optional)
Fill-in-Blank Columns
blank_1_answer,blank_2_answer— correct answer for each blankblank_1_alternatives— pipe-separated alternatives (e.g., "USA|United States")case_sensitive— "true" or "false"
Matching Columns
left_1,left_2, etc. — left column itemsright_1,right_2, etc. — corresponding right column itemsdistractors— pipe-separated extra right items
Import Tips
- Start small — test with 5–10 questions first to verify your format is correct.
- Use UTF-8 encoding — save your CSV as UTF-8 to support special characters and non-English text.
- One type per file — while mixed types are supported, using one question type per CSV is easier to manage.
- Review after import — all imported questions are created in DRAFT status. Review and publish them before adding to exams.