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 Add Candidates?

      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 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 Sub Admins?

      Overview Sub-admins are secondary admins who assist in managing the system. They have specific permissions set by the main admin, allowing them to perform various tasks without full access to all system settings. Steps to create sub-admins Step 1: ...
    • How to Evaluate Subjective Questions?

      Subjective Test Evaluation : Overview The evaluation process for subjective tests involves manually evaluating the responses given by candidates to these questions. Since subjective questions do not have a single correct answer, the evaluation ...