Upload Via Excel

Instructions

  • File-Size Limit 10mb
  • Columns Name - S.No, Question Text, [Options: 1,2,3 or A,B,C], Correct Answer, Level, Section, Explanation, Multiple, Tag
  • Section and Tag columns are optional. If provided, sections and tags are auto-created if they don't exist.
  • The uploaded file must not have - Rowspans or Colspans or Any comments
  • To add Multiple Images Please group the images.
    1. In Excel select all images in cell to be grouped and right click them.
    2. Go to Group option then Select "Group" again
  • Download Sample File- with ABC based indexes
  • Download Sample File- with 123 based indexes
Upload Weighted MCQs Via Excel

Instructions

  • File-Size Limit 10mb
  • Columns Name - S.No, Question Text, [Options: 1,2,3 or A,B,C], Correct Answer, Difficulty, Section, Explanation, Multiple, Tag, Weight (per option: Weight 1, Weight 2 ...)
  • Section and Tag columns are optional. If provided, sections and tags are auto-created if they don't exist.
  • The uploaded file must not have - Rowspans or Colspans or Any comments
  • To add Multiple Images Please group the images.
    1. In Excel select all images in cell to be grouped and right click them.
    2. Go to Group option then Select "Group" again
  • Download Sample File- with ABC based indexes
  • Download Sample File- with 123 based indexes
Upload Subjective Questions via Excel

Instructions

  • File-Size Limit 10mb. Only .xlsx files.
  • Required columns: S.No, Question Text, Answer, Level
  • Optional columns: Section, Tag, Explanation, SubType
  • Answer: Numeric value (e.g. 42.5). Leave empty for text-based or date-based subjective.
  • SubType column: text = text-based subjective, date = date-based subjective, blank = numeric subjective (default)
  • Section: Section name. Auto-created if it doesn't exist.
  • Tag: Tag name. Auto-created if it doesn't exist.
  • Download Sample File
Upload Match the Following via Excel

Instructions

  • File-Size Limit 10mb. Only .xlsx files.
  • Required columns: S.No, Question Text, A1, A2, ..., An (Column A items), B1, B2, ..., Bn (Column B items), Mapping, Level
  • Optional columns: Section, Tag, Explanation
  • Mapping format (One-to-One): A1:B2,A2:B1,A3:B3 — each A maps to exactly one B
  • Mapping format (One-to-Many): A1:B1+B2,A2:B3,A3:B1+B3 — each A can map to multiple B items using +
  • Do not add or remove columns. Do not use merged cells.
  • Download Sample File
Locked to Column A count

Select topic

Select test

Test ID: {{selectedTest._id}}
Cloned test — Parent ID: {{selectedTest.parent_test_id}}
✓ Synced with parent ⚠ Out of sync ✕ Parent test deleted Sync from parent

Start »

Sections:

Questions Total : {{numOfQuestions}}

{{c_name}} › {{t_name}} ✓ Synced ⚠ Out of sync

  • {{$index+1}}

    Compulsory :

    Weight: {{ option.weight }}
    Answer : {{question.correct_ans_sb}}

    Multiple Correct Type:

    Type: Weighted MCQ
    Total Marks:

    Multiple Correct Type:

    Type: Match the Following (One-to-One)
    Type: Match the Following (One-to-Many)
    Matching Pairs Preview
    Column A
    Column B
    Answers
    A{{pair.col_a_index + 1}} → B{{pair.col_b_index + 1}}
    A{{pair.col_a_index + 1}} → B{{bIdx + 1}}{{$last ? '' : ', '}}

    Select a section :

    Section :

Preview

Question :

No sections available. Use "Add Section" to create one.

Section :

Type :

Options :

Select Answer Set :


Explanation :

Option Weights :

Note: Only Integer values greater than or equal to 0 will be accepted (Default Value : 0)

Auto-set to Column A count in One-to-One mode.

Generated {{appliedCountA}} Column A and {{appliedCountB}} Column B fields. Re-apply / Reset fields
Enter counts above, then click Apply to generate the input fields.

Step 1: Fill Column B Options (These appear as choices in the matching dropdowns)

Step 2: Fill Column A Items & Select Matches

⚠ Please fill all Column B options first before selecting matches.
Selected: B{{idx + 1}} ({{column_b_options[idx]}}){{$last ? '' : ', '}}

Preview

Match the Following
Column A
  1. {{column_a_options[$index] || '(empty)'}}
Column B
  1. {{column_b_options[$index] || '(empty)'}}

Question Bank

No Questions Available

Set tag for all rows:

Validate Test

×
How to validate your test:
  1. Click Download Template to get a pre-filled Excel with all your questions.
  2. Fill in the mandatory columns: Question Text, Correct Answer, Marks, Level (1-4), Explanation, Tag ID.
  3. Do not add, remove, or reorder rows. Do not modify the Question ID column.
  4. Save the file as .xlsx and upload it below.
  5. The validator will scan every row and report all errors grouped by question number.
Answer format guide:
MCQ: option number (e.g. 2)  |  Multiple correct: 1,3  |  Subjective: decimal (e.g. 42.5)
Weighted MCQ: 1:5,2:3 (option:weight)  |  Matching: A1:B2,A2:B1  |  Multi-match: A1:B1+B2,A2:B3
Pre-filled with {{numOfQuestions}} question(s) from this test
Selected: {{validateFile.name}}
{{validateResult.message}}
Validation failed.  Total rows scanned: {{validateResult.summary.total}}  |  Questions with errors: {{validateResult.summary.questionsWithErrors}}  |  File-level errors: {{validateResult.summary.globalErrors}}
File-level errors:
  • {{err}}
Errors by question:
{{qLabel}}
  • {{err}}