Kumars Softech - Question Paper GeneratorEntrance examination question bank

Import questions from Excel or CSV

Upload the workbook as it is — .xlsx files are opened directly, so nothing needs converting.

Download sample file

How the sheet should look

Row 1 holds the column names. Spelling is flexible — Option A, option_a and A all work.

ColumnRequiredAlso accepted as
subjectYesMaths, Math, SST, Social, ಗಣಿತ, विज्ञान …
questionYesquestion text, qn, q, ಪ್ರಶ್ನೆ, प्रश्न
opt_a … opt_dYesoption a, optionA, a, choice_a
correct_answerYesanswer, ans, key — the value may be A–D, 1–4, or the option text itself
noteNoexplanation, reference, remarks — trimmed to 500 letters
chapter, difficulty, marksNotopic, level, mark

If an import still fails

What you seeWhat to do
Kannada or Hindi becomes ??? or ಕ The CSV was saved as ANSI. Upload the .xlsx itself, or in Excel use File → Save As → CSV UTF-8.
"This is an old-format .xls file" Save As → Excel Workbook (.xlsx) and upload that.
"PHP is missing the zip extension" In php.ini remove the semicolon before extension=zip, then restart Apache.
Everything lands in one column The CSV uses a different separator — pick it in the dropdown instead of automatic.
"larger than upload_max_filesize" Raise upload_max_filesize and post_max_size in php.ini, or split the sheet.
Only part of the sheet imported Only the first worksheet is read. Move everything onto sheet 1, or import one sheet at a time.
Merged cells or a title row above the headers Delete those rows — the column names must sit in row 1.