Skip to main content
The Bulk Import feature lets you import multiple-choice questions from an Excel file into Socratease Quizzes. This saves significant time when you have many questions in an existing Excel or Word format, or when multiple people collaborate on a large question set.
Bulk Import is available to Elite Plan customers only. See Elite Features for details.

​
How to Import Questions

1

Download the Template

Open your quiz in the Socratease editor and download the Excel template. This template contains the required column headers and formatting.
2

Add Questions to the Excel File

Fill in the template with your questions, answer choices, and correct answer indicators. See the column reference below for details on each field.
3

Upload the Excel File

Upload the completed Excel file to your quiz. The questions import automatically and appear in your quiz editor.

​
Excel Template Column Reference

ColumnRequiredDescription
Question TypeYesMCQ for single correct answer, or MCA for multiple correct answers
QuestionYesThe question text
Opt1 — Opt5NoAnswer choices. Use only as many as needed (e.g., if you have 3 options, fill Opt1, Opt2, Opt3 and leave Opt4 and Opt5 blank)
CorrectAnsIndYesFor MCQ: a single number indicating the correct option (e.g., 2 for Opt2). For MCA: comma-separated numbers without spaces (e.g., 2,3 for Opt2 and Opt3)
MarkdownNoEnter 1 to format the question text as Markdown
PointsNoPoint value for a correct answer
Time (seconds)NoTime limit per question, in seconds
ImageNoA direct URL to an image file (.jpg, .png, etc.) to display with the question
The Image column requires a direct URL to the image file. Google Drive sharing links are not supported. Use a direct link that ends in a file extension like .jpg or .png.

​
Tips for a Successful Import

  • Fields marked with Required: Yes must be filled in for every question.
  • You can leave optional columns blank if they are not needed.
  • Make sure the column headers match the template exactly — do not rename or reorder columns.
  • For MCA questions, separate the correct answer numbers with a comma and no space (e.g., 2,3 not 2, 3).
  • If you import a large number of questions, consider breaking them into smaller batches to make troubleshooting easier.
Bulk Import currently supports MCQ and MCA question types only. For other question types, add them manually through the quiz editor. See Question Types for the full list of available formats.