How to Bulk Import to the Question Pool Using Excel Template

This article explains how to quickly and efficiently import questions into the question pool using a predefined YTM Excel format. You can bulk import 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 the Tests tab in the left-side 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. Optionally enter the question pool description.
  4. Optionally enter the question pool external ID.
  5. Click the Save button.


Bulk import 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.

Bulk import 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.Bulk Import

For more related instructional materials, please visit:

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

Powered by BetterDocs