What is the file format for the Questionmark Live CSV import?

Applies to the following products: 
Questionmark OnDemand
Questionmark OnPremise

A template is available to assist anyone who wishes to create questions using the Questionmark Live CSV format. The template can be downloaded below:

The way this CSV template works is by allowing you to create a question in each row of the questions table. Each row of data represents different details or question data.

The questions that can be created using the CSV file are listed below along with the question type code to use in the CSV:

  • Multiple Choice - MC
  • Multiple Response - MR
  • Multiple Response (right/wrong) - MRWR
  • True/False - TF
  • Yes/No - YN
  • Text Match - TM
  • Likert Scale - LKS

The data must be added in to each row of the spreadsheet. What data is entered will depend on the type of question you are creating. See the relevant section below.

Because the Questionmark CSV file format is comma delimited, if you need to use commas in a text field such as the stimulus or a choice, you must enclose the text in quotations. Neglecting to do so will cause errors.

Multiple Choice and Multiple Response question types

Question type code Stimulus Choice 1 Score Feedback 1 Choice 2 Score Feedback 2 Choice N Score 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.
MR Where in Canada is the Questionmark office? Edmonton 1 That is correct. Alberta 1 That is correct. Toronto 0 That is incorrect.

Multiple Response (right/wrong)

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 and Yes/No

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.
YN Questionmark has an office in Edmonton. Yes 1 That is correct. No 0 That is incorrect.

Text Match

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

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

Saving the data as a CSV file

Once you have added all your questions in to the spreadsheet using the particular layout for the question types, as indicated above, you will need to save the file as a CSV file. To do this in Excel:

  1. From the File menu, click Save As.
  2. In the Save as type drop-down list, select CSV (Comma delimited).
  3. Enter a filename, and click Save.

The file can now be imported in to Authoring.