How do I work with Questionmark CSV files? | Questionmark

How do I work with Questionmark CSV files?

Applies to the following products: 
Questionmark OnDemand
Questionmark OnPremise

This page provides contains the following sections:

Where can I get a template for the Questionmark CSV?

A template is available to help create questions using the Questionmark CSV format. Download the template here.

How do I create questions using the Questionmark CSV template?

The Questionmark CSV template is an Excel document made up of several worksheets. Only the first worksheet is actually used by Authoring. To create questions, the following is recommended:

  1. Copy the Blank questions table from Template examples worksheet to the Questions worksheet.
  2. Remove from the Questions worksheet any rows containing question types you don't intend to create.
  3. Fill in the required information (as described on the Templates examples worksheet) for each question type you are creating.
  4. Create any additional rows for further questions.

Once you've added all your questions to the Excel spreadsheet using the particular format for the question types, as indicated above, you'll need to save the file as a CSV file. To do this:

  1. From the File menu, click Save As.
  2. Select a location in which to save the CSV file.
  3. Enter a file name.
  4. From the drop-down list, select CSV UTF-8 (Comma delimited).
  5. Click Save.

The CSV file can now be imported into Authoring.

Importing a CSV file into Authoring

To import a Questionmark CSV file, follow the steps in Importing questions.