How to add questions in Bulk? Excel Import

How to add questions in Bulk? Excel Import

1.To upload questions in bulk, select the "Import question" button located within the "Question" tab.

2. Next, on the right-hand side, click the "Import" button.



3.After you click on the “import” button - download the sample Excel file by clicking on the green “sample file" button.




4. When you click on “sample file”, an Excel file will download. Add your questions here, and remember to fill in the Subject name, Topic name, and question type correctly.



5. Then, go back to the Import question tab on the ThinkExam portal and upload your Excel file.


6. After that, scroll down and click the "save" button.


7. Now, you'll see the status of the uploaded file. If it says "successful," your questions were added without any issues. However, if it shows "revert back" or "some records were rejected," you may need to make some changes to your file.


8. To identify errors, click on the highlighted section as shown in the image below. An error report will download. Review the file, correct any errors, and re-upload your question file. You may need to repeat this process until all errors are resolved.



Note:
  1. Save your Excel file in a compatible format, such as Excel 97-2003 workbook.
  2. Enter the Question text, subject name, topic name, question type, correct answer, and 4 mandatory options.
  3. You can leave any optional fields blank, but ensure not to delete them to avoid errors during uploading.


    • Related Articles

    • How to view and add questions in Multiple languages?

      Overview: The "Support Multiple Languages for Interface Test" feature allows users to create tests that can be viewed in multiple languages. This functionality ensures that candidates can access and answer questions in their preferred language, ...
    • How to manually add questions to the question bank?

      1.To add questions, navigate to the Question Tab and select "Question." Then, click on the "Add" button located on the right-hand side. 2. Choose the subject, topic from the dropdown menu located on the left side of the screen. 3. If you want to add ...
    • How To Add Candidates From The Admin Panel?

      Candidate : Overview The “Candidate” Tab allows you to add candidates either manually or you can import via an excel upload. You can create different groups and you can also associate candidates with each group. You can search for any candidate by ...
    • How to create a test from Test Manager?

      To create a test, follow the steps given below. Step 1 : create Test 1.Click on the “Test Manager” Tab and then click on the “Test” button. 2. Now click on the “Add” button which is on the right hand side of the screen. 3. Here, add all relevant ...
    • How to add Questions using Word Parser