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
  • 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, Weight(As per the number of options e.g Weight 1, Weight 2 .....)
  • 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

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}}