How to Bulk-Import Questions From Excel


With ProProfs Quiz Maker you can prepare questions anytime, anywhere without the need to remain online. Simply create questions on an Excel document and bulk upload them using ProProfs Import feature.


This feature supports ‘Offline Authoring’ so that even those without a ProProfs account can create questions for you. ProProfs also supports importing questions from an existing ProProfs quiz.


Advanced Tip* While bulk uploading questions from the Excel sheet you can:

  • Assign marks or points to quiz questions
  • Assign topics or category to quiz questions


Follow these steps to upload questions from an Excel sheet:


Step 1. Navigate to the quiz editor and click 'Import Questions' as shown below.


Step 2. A window appears as shown below. Select 'From a Microsoft Excel File' and click 'Next'.


Step 3. Click 'Upload' in the next window to import questions from your Excel document.


Step 4. Download the Sample Excel file, and make sure that the Excel file contains the following: Quiz Type, Question Text & Answer Options. 


You can also add the correct answer, topics, and question points to the quiz directly from the Excel sheet. Please select the question type and correct option from the drop-down menu provided in the excel sheet.


Related Articles:

How Do I Select Questions at Random From a Pool?
How Do I Find and Use Ready-Made Questions?
How to Add Feedback to Answers

Was this information helpful?

The page cannot be found

The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. Please make sure you spelled the page name correctly or use the search box.

add chat to your website