Skip to Main Content
EngagementHQ Ideas

Let our product team know which features and ideas would help you do better online engagement.

Status Needs review
Categories Analytics
Created by Guest
Created on Aug 19, 2024

Change survey output on excel spreadsheet

All categories to a multiple response question selected by a respondent are in one cell> Usually for survey software the response to each category is in a separate column.

e.g. Question: 1. Which animals do you like? a dogs, b cats, c rabbits, d none of the above

The data would usually output like this or with the answer selected shown as a number e.g. dogs 1, cats 2 etc:

Q 1 a dogs

Q1 b. cats

Q1 c. rabbits

Q1 d none

Respondent 1

dogs

cats

Respondent 2

none

Respondent 3

dogs

rabbits

Respondent 4

cats


  • Attach files