View Categories

How to Import Questions with More Category Values via Excel

This article explains how to import questions (with additional category values) into the question pool using an Excel template.

Question categories are used for better question organization, search, and creating filters for test generators. Preconditions of importing questions with categories are that the categories must be created in the Settings and customization.

One question can have multiple categories and multiple category values.

Creating question category #

For more information on creating question categories, you can check this article.

Importing questions with assigned category values #

  1. Select the Tests/Question pool tab.
  2. Select the question pool where you want to import the questions.
  3. Select the Questions tab.
  4. Select the Load questions/Without images (.xlsx format) option.
  5. When the pop-up window shows up, click on the Excel template to download it.

Once you download the Excel template, you should fill it out with relevant information.

Categories are specified in the column “Categories (Optional)” in the following format:
<QuestionCategory1>:<Value1>…;
<QuestionCategory2>:<Value2>…;

Example:
Topic area: Biology; Difficulty level: Easy;

How this looks like in the Settings and customization:

How it looks like in the Excel file:

Once you fill in the template, you should:

  1. Select the created file by clicking the Select file button and choosing the file.
  2. Click the Upload button.

The questions with assigned question category values will be imported into the desired question pool.

For more useful instructional materials, please check these links:

Powered by BetterDocs