Managing Questions in Templates

Managing Questions in Templates

Why Add Questions to Templates

Questions in templates help when:

• Your survey has multiple open-ended questions
• You upload Excel files with one question per sheet
• You want consistent question text across analyses

Adding Questions Manually

1. Open your template for editing
2. In the Questions section, click Add Question
3. Enter:
   • Question ID — Short unique identifier (e.g., “Q1”, “P5”, “Brand_Aware”)
   • Question Text — The full question as asked in the survey
4. Repeat for additional questions
5. Save the template

Importing Questions from CSV

For surveys with many questions, import from a CSV file:

1. Prepare your CSV with two columns:
   • First column: Question ID
   • Second column: Question Text

Example Excel file:

| Q1 | How satisfied are you with our service? | | Q2 | What did you like most about your experience? | | Q3 | What could we improve? | | Q4 | Would you recommend us to others? Why or why not? |

2. In your template, click Import Questions from file
3. Select your file
4. Review imported questions
5. Save the template

Matching Questions to Excel Sheets

When uploading an Excel file with multiple sheets:

1. Name each sheet with the Question ID (e.g., “Q1”, “Q2”)
2. The template matches sheet names to question IDs
3. The correct question text is automatically applied

Example Excel structure:

• Sheet “Q1” → Contains responses for “How satisfied are you…”
• Sheet “Q2” → Contains responses for “What did you like most…”