How to Bulk-Import Questions From Excel
With ProProfs Quiz Maker, you can bulk upload questions using Excel files or ProProfs AI, depending on how your content is prepared.
If your questions are already structured in an Excel sheet, you can upload them using the ProProfs Import feature. This supports offline authoring, allowing even users without a ProProfs account or an internet connection to prepare questions, and also supports importing questions from an existing ProProfs quiz.
Alternatively, If your questions are stored in documents—or you only have learning material—you can use ProProfs AI to attach a file and import existing questions or automatically generate new ones.
In this article, you'll learn:
Bulk Import Questions From Excel
In the Excel sheet, apart from adding questions and answers along with question types, you can also:
-
Assign marks or points for each question
-
Assign topics or categories to questions
Below is an overview of a sample Excel file with proper formatting to let you import questions for your quiz in bulk:
Steps to Bulk Import Questions From Excel
Follow the steps below to upload questions using an Excel sheet:
Step 1: In the quiz editor,
-
Go to Add > Import Questions.
-
Select “Excel” and click Next.
You can download the sample Excel file to import questions for your quiz in bulk.
Step 2: Click Upload file to import questions from your Excel sheet.
After you finish uploading, you will see the following:
Once done, the added questions will show up as regular questions:
Bulk Upload Questions Using ProProfs AI
In addition to importing questions from Excel, ProProfs Quiz Maker lets you bulk-upload questions using AI by attaching a document in the quiz editor.
You can use this option in two scenarios:
-
When your document already contains questions, and you want to import them in bulk.
-
When your document contains informational content, and you want the AI to generate quiz questions from it.
This approach eliminates the need to manually format questions in an Excel sheet.
Attach a Reference File
While using ProProfs AI in the quiz editor, click the Attach File icon in the input field to upload a document.
Depending on the content of your file, ProProfs AI will:
-
Import existing questions
If the document already includes questions, the AI can identify and import them directly into your quiz. -
Generate questions from content
If the document contains material such as class notes, training content, or policy manuals, the AI can automatically convert the information into relevant quiz questions.
Supported file formats: .DOCX, .PDF, .TXT
Maximum file size: 20 MB
Once uploaded, all imported or generated questions are added to your quiz as regular questions, which you can review, edit, or rearrange as needed.
That’s all you need to do. From here, you can edit the questions imported directly into the quiz editor if required.