Skip to content
Nabeeh Nabeeh Help Center Open the app

Import the question library

Add or update your question library from an Excel file with two sheets: the questions, of all eight types, with their settings, then their options and table headings. Saved answers stay linked to their options.

The question library holds the questions you link to services and inspection plans; you find it under Tenant Services › Manage questions library. Use this import to add many questions at once, or to edit your current questions and their options from the exported file. Only the account admin imports and exports the library, like on the Tenant Services screen.

Where to start

Open the Import & Export Center and select Import on the Question Library row, in the Services and contracts group. The import then follows the steps in Import your data.

Fill in the template

Select Download template. The template has two sheets:

  • Questions: one row per question.
  • Options: one line per option of a choice question, and one line per column heading of a table question, in the order they should appear, or numbered in the Order column.

The Questions sheet

Column What to enter
Question title (three languages) At least one title. On a new question, a language left empty first shows the title written in another one, then is translated automatically shortly after the import.
Question description (three languages) Optional. Written in one language, it is translated automatically into the languages left empty.
Question type Required on a new question. Choose it from the list: the same types as the question form.
Status Active or Inactive; left empty on a new question, the question is added as Active.
Order Optional. A whole number from 0 to 65535.
Additional details on options Single and multiple choice questions only: Yes or No.
Remarks for each item Checklists only: Yes or No.
Table header orientation, Table rows, Number of table rows and Table numbering Table questions only. Left empty on a new table question, they take what the form preselects: First row as header, Fixed number of rows and None. The number of rows is required while the rows are fixed.

A setting written for a type it does not belong to is not saved, and the review tells you so.

The Options sheet

Column What to enter
Question The question’s title as you wrote it on the Questions sheet, in any language. If more than one question in the file has that title, enter the Question ID instead, or give them different titles: the import never picks one of them by guessing.
Option name (three languages) At least one name. For a table question, this is the column heading. A language left empty first shows the name written in another one, then is translated automatically shortly after the import.
Additional details (three languages) Optional, and saved only when Additional details on options is Yes. Written in one language, they are translated automatically into the languages left empty.
Order Optional. A whole number from 1 to 65535 that sets the option’s place among its question’s options, such as 1, 2, 3. Numbered lines come first, by number (two lines with the same number keep their file order); lines without a number follow in their file order. Any other value is an error on the line, so its question is Blocked.

Single choice, multiple choice, checklist and table questions need at least one line on the Options sheet. Short text, long text, number and file questions take no options; a line written for one is an error.

A question imports with all of its options

A question and its lines on the Options sheet are one unit: when one of its lines has an error, the whole question is not imported and shows as Blocked in the review until you fix or delete that line. That is why the review and the result count questions, not rows; the other questions in the file can still be imported.

New, update or no change

  • A row with the Question ID (do not edit) from an exported file updates that question; every row without an ID adds a new question, even when its title repeats.
  • On an update row, an empty cell keeps the current value. Enter [CLEAR] to empty the question description, the order or an option’s details. The title, the type and the settings cannot be cleared.
  • When a question has no line on the Options sheet, its options stay as they are. When it has lines, its options become those lines, in the order of their Order numbers, or in file order where the Order cell is empty. [CLEAR] in Order counts as empty.
  • A row that changes nothing shows as No change, and an exported file imported back without edits changes nothing.

Options and saved answers

Saved answers keep the option key, not its name, so:

  • You can safely rename or reorder an option: answers stay linked to it.
  • A new option gets a new key that no current option of the question and no saved answer uses.
  • Removing an option’s line removes the option, unless saved answers use it: then the question is refused until you put the line back.
  • A question’s Question type does not change while the question is in use: it has saved answers, or it is linked to a service or an inspection plan. Add a new question with the type you need instead.

The import never deletes a question and never changes which questions a service asks; that stays in the service form on Tenant Services.

Edit the whole question library in Excel

Select Export on the Question Library row of the Import & Export Center to get every question of the library on the same two sheets, each starting with Question ID (do not edit). Edit the file, then import it to update the library. See Export your data.

In the exported file, the Order column numbers each question’s options 1, 2, 3… in their current order: change the numbers to reorder them, or leave them as they are. Only in the exported file, the Options sheet has two columns the template does not have:

  • Question ID (do not edit): it decides which question a line belongs to, not the title. Clear it and the line links by the title in the Question column; you can also correct or clear it in the review.
  • Option key (do not edit): it keeps saved answers linked to the option. Leave it empty on a line you add for a new option.

Note: the question form under Manage questions library does not yet stop you from changing the type of a question in use or removing an option that has answers; only the import does.

What's next