Working with Questionmark CSV files

Applies to the following products: 
Questionmark OnDemand
Questionmark OnPremise

You can use the Questionmark CSV template to import 3rd party questions into Questionmark. Each row in the template represents an individual question, with the columns representing different question elements. What data you enter on each row depends on the type of question you're creating.

This page contains the following sections:

Where can I get a template for the Questionmark CSV?

Download the template here.

What question types can I create?

You can create the following question types. Each question type has an associated code (shown in the list below in bold font) which is used in the CSV file:

Multiple Choice example

Question type code Stimulus Choice 1 Score Feedback 1 Choice 2 Score Feedback 2 Choice N Score N Feedback N
MC Where in Canada is the Questionmark office? Edmonton 1 That is correct. Calgary 0 That is incorrect. Toronto 0 That is incorrect.

Multiple Response example

Question type code Stimulus Choice 1 Score Feedback 1 Choice 2 Score Feedback 2 Choice N Score N Feedback N
MR Where in Canada is the Questionmark office? Edmonton 1 That is correct. Alberta 1 That is incorrect. Toronto 0 That is incorrect

Multiple Response (right/wrong) example

Question type code Stimulus Score for correct answer Feedback for correct answer Score for incorrect answer Feedback for incorrect answer Choice 1 Is answer? Choice 2 Is answer? Choice N Is answer?
MRWR Where in Canada is the Questionmark office? 1 Correct 0 Incorrect Edmonton 1 Alberta 1 Toronto 0

True/False example

Question type code Stimulus Choice 1 Score Feedback 1 Choice 2 Score Feedback
TF The Questionmark offices are in Edmonton. TRUE 1 That is correct. FALSE 0 That is incorrect.

Yes/No example

Question type code Stimulus Choice 1 Score Feedback 1 Choice 2 Score Feedback
YN Questionmark has an office in Edmonton. Yes 1 That is correct. No 0 That is incorrect.

Text Match example

Question type code Stimulus Score for incorrect answer Feedback for incorrect answer Correct answer 1 Score for correct answer 1 Feedback for correct answer 1 Correct answer 2 Score for correct answer 2 Feedback for correct answer 2 Correct answer N Score for correct answer N Feedback for correct answer N
TM Where in Canada is the Questionmark office? 0 That is incorrect. Edmonton 1 That is correct. Alberta 1 That is correct. Edmonton, Alberta 1 That is correct.

Likert Scale example

Question type code Stimulus Scale N description Scale N score Scale 3 description Scale 3 score Scale 2 description Scale 2 score Scale 1 description Scale 1 score
LKS How nice was your last airline flight? Nice 3 Average 2 Not nice 1 Terrible 0

How do I create questions using the Questionmark CSV template?

The Questionmark CSV template is an Excel document made up of several worksheets:

  • The Instructions sheet explains the basic steps for creating your CSV file
  • The Template examples sheet contains one example for each valid question type, so you can see how it should look. It also contains a table of blank questions which you can use to start creating questions
  • The Questions sheet is where you add all the questions you want to import. This is the sheet which will be imported into Questionmark.

To create questions, we recommend the following:

  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.

Save your template in the correct format

Important: You should check your computer's default delimiter before you begin! Questionmark CSV files require the comma to be set as the delimiter.

For Windows, access (or search for) your Control Panel > Clock and Region > Change date, time, or number formats

Once there, click Additional Settings, then check that the List separator field shows a comma. If not, change it to a comma and apply the change!

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.

Troubleshooting

No valid questions were found in the import file

While importing 3rd party questions, if you receive an error message which says No valid questions were found in the selected import file [filename] the most likely cause could be the delimiter.

When importing to Questionmark in the CSV format, commas must be used as the delimiter otherwise the import will fail. It isn't always obvious which default delimiter your computer uses, and even if you save in the CSV format, this does not guarantee the delimiter is a comma!

Therefore we highly recommend checking your delimiter is correct. If you find it is not, please update it as shown below (it is slightly different depending on whether you are a Windows or Mac user, so please follow the steps carefully!) and then save a new CSV file.

For Windows:

  1. Go to Control Panel > Clock and Region.
  2. Under Region, select the Change date, time, or number formats option.
  3. In the Region pop-up which appears, click on the Additional settings... button.
  4. Change the List separator to a comma and apply the changes.

For Mac:

  1. Go to System Preferences.
  2. Open the Language & Region pane.
  3. Change the Decimal Separator to a period:
    1. If the Decimal Separator is a period (.) then the CSV separator will be a comma - this is what you want!
    2. If Decimal Separator is a comma (,) then the CSV separator will be a semi-colon - don't use this!

Other possibilities

An error occurred while performing the action

If you try to import a CSV file and you receive the message An error occurred while performing the action it is likely that the data has not been input correctly into the CSV file, such as feedback being added to the score field by mistake, or something similar. Check the file carefully for any errors!