How to bulk import to the question pool using Excel template

This article explains how to import questions into the question pool quickly and efficiently using a predefined YTM Excel format. You can insert questions with images (using a ZIP file) and without images.

You can add hundreds of thousands of questions to your Excel template and configure the settings of each question.

Accessing the page

To access the “Question pools” page, click on “Tests” in the main menu, and select “Question pools.”

Creating a question pool

To create a new question pool, follow these steps:

1. Click the “Create” button.
2. Enter the question pool name.
3. Enter the question pool description. (optional)
4. Click the “Save” button.
   

Loading questions using an Excel file

To import questions without images, you should upload an Excel file:

1. Click the “Load questions” button, and select the option “Without images.”
2. Click the “Excel template” link to download an Excel file you should fill in.
3. Download detailed instructions on how to fill in the template.
4. Check the box if you want to skip loading questions that already exist in the pool.
5. Choose an Excel file with question data by clicking the “Select File” button.
6. Click the “Upload” button to load questions into the system.

Loading questions with images using a .zip file

To load questions with images, you should upload a .zip file:

1. Click the “Load questions” button, and select the option “With images.”
2. Click the “Excel template” link to download an Excel file you should fill in.
3. Download detailed instructions on how to fill in the template.
4. Check the box if you want to skip loading questions that already exist in the pool.
5. Choose a.zip file containing the Excel file with questions data and folder with images by clicking the “Select File” button.
   Note: The name of each image should be the same as the Question’s ID in the Excel template.
6. Click the “Upload” button to load questions into the system.

For more related instructional materials, please visit:

• How to import a test from an Excel file 

For a video tutorial on Importing questions with Excel template please watch the video.