Skip to main content
Instead of typing questions into a Custom Quiz one at a time, fill an Excel file and import them in a single upload. Imported questions are appended, so you can also add to a quiz that already has questions.

​
Downloading the Template

1

Open Custom Tests

From your Assessments Dashboard, select Custom Tests. Click New, or open an existing quiz.
2

Download the template

Click Import at the top right of the quiz, then Download Template. Alternatively, download the Google Sheets template as an Excel file.
3

Fill in your questions

Add one question per row, following the column rules in the next section.
4

Upload the file

Back in your quiz, click the Import from Excel icon and select your file. Optionally enable Autocalculate Negative Points before uploading.
Do not remove any columns from the template. Your file must contain only one sheet and no empty rows, or the import will fail.

​
Formatting Questions

The Excel import supports MCQ and MCA questions only. You can add other question types in the quiz after the import.

​
Autocalculate Negative Points

Enable Autocalculate Negative Points during the import to assign negative points to every MCQ automatically:
For example, an MCQ worth 2 points with 4 options gets 0.5 negative points. MCAs are never auto-assigned negative points.

​
Markdown and LaTeX Support

Enter 1 in the Markdown column to render the question text and options as Markdown. Leave it blank for plain text.
Write mathematical equations in LaTeX inside your Excel file, then enable LaTeX in the quiz’s Advanced Settings so they render for candidates.

​
Troubleshooting Imports

Importing the same file twice creates duplicate questions. Remove the extra questions in the quiz editor.