Import from Excel File

This feature is useful if:

1. You already have many questions in an Excel or Word format
2. You are collaborating with people in generating a large number of questions and want to review them before creating them on the Socratease quiz

Steps

The steps involved are:

1. Download the template as an Excel file
2. Add the questions to the Excel file
3. Upload the Excel file to the quiz

Excel Template

The Excel file looks like this. It has the following columns. Any column with a * corresponds to a column that cannot be empty.

1. Question Type*: Can be one of MCQ (Single Correct Answer) or MCA (Multiple Correct Answers)
2. Question*: The text of the question you want to ask
3. Opt1 - Opt5: The text of the different choices. If you have only three choices, fill in Opt1, Opt2, Opt3 and leave the rest blank
4. CorrectAnsInd*: For an MCQ, this is an integer corresponding to the choice number that is correct. For example, if Option Number 2 is the correct answer, CorrectAnsInd = 2. For an MCA, if Option Numbers 2 and 3 are correct, CorrectAnsInd = 2,3. That is, separate the numbers with a comma and no space
5. Markdown: If you want your questions and options to be shown as Markdown, enter 1 in this column. Else, you can leave it blank
6. Points: Number of points for the correct answer. You can leave this blank if you aren't assigning points
7. Time (in seconds): If your quiz has questions coming one-by-one, instead of all-at-once, you can specify the time limit in seconds for each question
8. Image: The URL of an image you want to show along with the question. The image has to be a direct URL (ending in a .jpg, .png, etc). Do not share a Google Drive link or the link to a page that contains an image.

Updated on: 02/12/2025