Import from Word

This guide explains how to format a Word file for importing survey questions and answers into your questionnaire platform. By following these instructions, you can ensure a smooth and accurate import process.

Introduction

You can use the import from Word feature in the question management menu to quickly add questions and answers to your survey. Proper formatting is essential for successful import.

---

Formatting questions

1. Question title

• The title should be in bold text.
• Format: "Label. Title"
  • Label: One or more alphanumeric characters followed by a dot (e.g. Q1., A2_n., O10_b.).
  • Each number must be between 0 and 99.

Example:

F1. How many children aged 3 to 6 live in your household?

2. Question type

• On the first line below the title, write the type in UPPERCASE and bold.
• You may prefix the line with PROG: for easier identification.
• The type must include one of the following keywords:

Keyword	Question type	Description
SINGLE	Closed question, one answer	Respondent selects only one answer
MULTIPLE	Closed question, multiple answers	Respondent can select several answers
ITEMS SINGLE	Item battery, one answer per item	Matrix: one answer per row
ITEMS MULTIPLE	Item battery, multiple per item	Matrix: multiple answers per row
OPEN	Open-ended text question	Respondent enters free text
R3M	3 spontaneous words	R3M "3 words" question

Example:

SINGLE

3. Additional options (optional)

• Add options after the question type if needed.
• Use one of these keywords:

Keyword	Option description
SHUFFLE ANSWERS	Answers shown in random order (closed/item batteries)
SHUFFLE ITEMS	Items shown in random order (item batteries only)

---

Formatting answers

Closed questions (SINGLE / MULTIPLE)

• Answers should be in a table format:
  • First column: Answer text
  • Second column: Answer number
  • Third column (optional): Instruction keyword(s)

Keyword	Instruction description
STOP	Screen out if this answer is selected
MANDATORY	Screen out if this answer is not selected
EXCLUSIVE	Only this answer can be selected
QUOTAS xx%	Limit the number of responses for this option to a specified percentage
FREE FIELD	Allows respondent to enter free text for this answer
FIXED	Keeps the answer/item in current position when shuffling

Example:

Answer	Number	Instructions
None	1	STOP
1 child	2
2 children	3	QUOTAS 50%
3 children and more	4	FREE FIELD QUOTAS 45%

---

Item batteries (ITEMS SINGLE / ITEMS MULTIPLE)

• Format as a table:
  • First column: Item number
  • Second column: Item text
  • Answer options: Provided as column headers in the first row

Example:

		YES, I TOTALLY AGREE	YES, I SOMEWHAT AGREE	NEITHER AGREE NOR DISAGREE	NO, I SOMEWHAT DISAGREE	NO, I TOTALLY DISAGREE
1	This product has a good taste	1	2	3	4	5
2	This product has a neutral taste	1	2	3	4	5
3	This product has a sweet taste	1	2	3	4	5
4	This product leaves a pleasant aftertaste	1	2	3	4	5

tip

Proper formatting in your Word file ensures a smooth and error-free import of your survey into the platform.