Marketing & Sales
Analyzing Survey Open-Ended Responses for Beginners | Sort 30-60 answers with an affinity diagram
Beginner | 4 whiteboard pages · Task board: 5 columns (4 parent tasks, 12 subtasks)
Beginner: No technical terms. Just answer the whiteboard's questions, following the examples, and it takes shape.
Sort 30-60 survey comments with an affinity diagram: report, fix now, or ask again.
Read more Show less
Copy each answer onto its own sticky note in the respondent's own words, without deciding categories first, and turn what you fix into tasks with an owner and a deadline. Move similar voices together and give each group a one-sentence heading and a count. Compare headings on effort to fix, clarity, and reader interest, then vote with 3 dots per person. Unlike a tally ranked by count, this keeps a must-not-miss voice in its own frame, even if there is only one.
For two to four staff of an event, class, or shop. About 40 answers take roughly 30 minutes to copy and 60 minutes to group and sort. Check the results in the next survey and keep using this board.
The whiteboard has four A4 pages that run in order: goal and copying, grouping, sorting, then fixing and reporting. The task board has 5 columns, 4 parent tasks (one per page), and 12 subtasks.
Once you have a free account, you can copy this template from the marketplace
Whiteboard preview
Read the whiteboard text as plain text
Survey Comments Summary Board
How to use (4 pages): ① Set the goal and how to copy on page 1 (boards①–⑤) → ② Copy one voice per note, group similar ones, add headings on page 2 (boards⑥–⑧) → ③ Sort where each voice goes by 3 criteria and votes on page 3 (boards⑨–⑬) → ④ Decide fixes and next questions, then report on page 4 (boards⑭–⑯)
1/4 Set goal and how to copy
① Last result and goal (start here)
| What to write | Number or date | |
|---|---|---|
| Last result | e.g. Fixed last time: printed and handed out the materials. e.g. Leave blank if this is your first time | e.g. Voices saying "I want handouts" went from 5 to 0 |
| This goal | e.g. Decide what to fix next session and report to the community center | e.g. Finish by Dec 6 |
| Answers and reader | e.g. The reader is the community center staff | e.g. 3 sessions from Sep to Nov, 33 attendees, 42 open comments |
② Steps to copy one voice per note
- List the answers Export the form or spreadsheet answers into a list, one row per person e.g. Put 3 sessions from Sep to Nov in one table (33 people)
- One voice, one note Copy one voice onto one sticky note, in the respondent's own words e.g. "The teacher spoke too fast and I could not follow the screen"
- Split two topics If one answer holds two topics, split it into two notes e.g. "The text is small. Also the room is cold" becomes two notes
- No boxes first Do not decide categories first. Put voices that feel alike close together e.g. Put "too fast" next to "I was left behind"
③ Questions to copy (blue: decided)
- e.g. Copy two questions, Q5 "Good things" and Q6 "Problems and next wishes"
- e.g. Skip the 5-point satisfaction rating; report only its average in ⑮
- e.g. If one person wrote the same thing in two questions, merge it into one note
- How to fill in: write the question numbers to copy and the ones to skip
④ Choose sticky note colors
- e.g. Problems and complaints are red
- e.g. Good voices are green
- e.g. Next wishes and ideas are gold
- How to fill in: colors are a cue while copying. Do not decide groups by color
⑤ Voices not to copy (blue: decided)
- e.g. Answers that only say "nothing" or "thanks" (4)
- e.g. If an answer has a name or phone number, erase that part and copy the rest
- e.g. Do not copy off-topic remarks, only count them (0 this time)
- How to fill in: write why you skip them and how many
2/4 Group similar voices
⑥ Voices (red=problem, green=good, gold=wish)
- Problem voice e.g. The teacher spoke too fast and I could not follow the screen
- Problem voice e.g. The handout text is too small to read even with glasses
- Good voice e.g. I could ask about anything I did not understand, as many times as I wanted
- Next wish e.g. Next I want to learn how to send photos on WhatsApp
⑦ Group headings, counts, sample voices
| Heading (1 sentence) | Count | Sample voice | |
|---|---|---|---|
| Group 1 | e.g. Handout and screen text is too small to see | e.g. 9 voices | e.g. "I can't read it even with glasses" |
| Group 2 | e.g. The pace is too fast to keep up | e.g. 11 voices | e.g. "I couldn't follow the screen" |
| Group 3 | e.g. Easy to ask questions on the spot | e.g. 8 voices | e.g. "I could ask as many times as I wanted" |
| Group 4 | e.g. There are things I want to learn next | e.g. 6 voices | e.g. "I want to send photos on WhatsApp" |
| Group 5 | e.g. The room is cold | e.g. 3 voices | e.g. "My hands were numb" |
⑧ Unplaced voices and must-keep voices
- Voices that fit nowhere e.g. 4 voices such as "The parking lot is small" and "The teacher's voice is easy to hear"
- A voice you must not miss, even if only one e.g. "I got a scam message and I am scared. I want to know how to spot one" (1 voice)
- Count check e.g. 37 in ⑦ plus 5 in ⑧ makes 42. It matches the 42 in ①, minus the 4 in ⑤, plus the 4 you split in two
3/4 Sort where voices go
⑨ Compare ⑦ headings (3 dots per person)
| Effort to fix | Meaning clear? | Reader wants it? | |
|---|---|---|---|
| Text too small | e.g. Small. Just enlarge the handout text | e.g. Clear | e.g. Wants to know |
| Pace too fast | e.g. Medium | e.g. Unclear (explanation or operation?) | e.g. Wants to know |
| Easy to ask | e.g. Nothing to fix | e.g. Clear | e.g. Wants to know |
| Things to learn | e.g. Large. Plan a new session | e.g. Unclear (which app?) | e.g. A little interested |
| Room is cold | e.g. Small. Ask for the heating | e.g. Clear | e.g. Barely interested |
⑩ Voices to report (gold)
- e.g. Easy to ask questions on the spot (8 voices)
- e.g. Text too small (9 voices) and what we fix from January
- e.g. Scam message worries (1 voice) and what we will talk about in January
- How to fill in: write headings the reader wants to know, with counts
⑪ Voices to fix now (red)
- e.g. Handout and screen text is too small (9 voices)
- e.g. The room is cold (3 voices)
- e.g. Scam message worries (1 voice, from ⑧)
- How to fill in: write headings you can fix before the next session
⑫ Voices to ask again (green)
- e.g. Pace is too fast (11 voices, unclear if the explanation or the operation is fast)
- e.g. Things to learn next (6 voices, unclear which app)
- e.g. The parking lot is small (1 voice, unclear if others are bothered)
- How to fill in: write unclear headings and what you do not know
⑬ Chosen and skipped headings, with reasons
- Chosen headings and reasons e.g. Text too small (4 dots) and room is cold (2 dots) get fixed now. They are cheap to fix and clear in meaning
- Skipped headings and reasons e.g. Things to learn next (1 dot) is not fixed this time, because we do not know which app
- Where skipped voices go e.g. Write it in ⑫ and turn it into a question in the January survey
4/4 Fix and report
⑭ Write fixes from ⑪ and questions from ⑫
- Fixes in ⑪ and questions in ⑫
- Enlarge handout text e.g. Print handouts at 18 pt and enlarge the screen when showing it
- Ask what was fast e.g. Let them pick one of "explanation", "operation", or "both"
- Ask for heating e.g. Ask the community center to turn the heating on 30 minutes before we start
- Ask which app to learn e.g. Let them pick up to two from WhatsApp, photos, and maps
- Scam message talk e.g. Spend the first 5 minutes of the January session on how to spot them
⑮ Decide the report from the ⑩ voices
- Reader and how to hand it over e.g. Hand one A4 sheet to the community center staff on Dec 10
- Order and length e.g. Good voices, then fixes and how, then what we will ask next, with up to 2 lines per heading
- Voices not to write e.g. Leave out voices that identify a person. Write counts exactly as in ⑦ and ⑧
⑯ Owner, deadline, and signal to continue
| Owner | Deadline | How to check | Signal and fallback | |
|---|---|---|---|---|
| Enlarge text | e.g. Instructor | e.g. The day before the January session | e.g. Count text-size voices in the January survey | e.g. Keep it if 0 voices, change it if 1-2, stop and go back to (board⑨) if 3 or more |
| Ask for heating | e.g. Staff A | e.g. Dec 20 | e.g. Write down the room temperature that day | e.g. Keep it if 0 cold voices, change it if 1-2, stop and go back to (board⑪) if 3 or more |
| Scam talk | e.g. Instructor | e.g. The January session | e.g. Count the questions after the talk | e.g. If 0 questions, stop and go back to (board⑧) |
| Add questions | e.g. Staff B | e.g. 3 days before the January session | e.g. Count how many people answered the new question | e.g. If fewer than half answered, change the question and go back to (board⑫) |
Task board contents
Not started 16 items
Set goal, copy rules
On page 1, write last time's result and this time's goal, and decide which questions to copy and how. Once the copying is settled, you can make sticky notes on page 2 without hesitating. Press Ctrl+F (⌘F on a Mac) and type "3/4" to jump to page 3.
Log result and goal
In the table of board①, write what you fixed last time and how many voices followed, this time's goal and deadline, and the number of answers and who will see the results. Done when all 3 rows are filled.
Read the copy steps
Read the 4 steps in board② and check that one voice goes on one note and that you do not decide categories first. Mark this task done once you have read them.
Decide what to copy
In boards③–⑤, write the question numbers to copy, how to color the notes, and the voices you will not copy with their count. Done when each of the 3 frames has a line.
Group similar voices
On page 2, group the voices you copied one by one by similarity, and give each group a heading and a count. These groups are the material you sort on page 3.
Copy voices to notes
Using the questions and colors from boards③–⑤, copy one voice per sticky note from the list of answers and place it in the frame of board⑥. Done when the number of notes matches the answers in the list, minus the voices you skip, plus the ones you split in two.
Add group headings
In board⑥, move similar voices close together and, in the table of board⑦, write a one-sentence heading, a count, and a sample voice for each group. Done when all 5 rows are filled.
Keep unplaced voices
Move voices that fit no group, and voices you must not miss even if only one, to board⑧ and write how many you kept. Done when the counts in ⑦ and ⑧ add up to the total.
Sort where voices go
On page 3, compare the headings from page 2 on 3 criteria, choose by votes, and sort them into voices to report, voices to fix now, and voices to ask again. The reasons you chose and skipped are kept, so you can review them later.
Compare and vote
In the table of board⑨, write the effort to fix, how clear the meaning is, and whether the reader wants to know for each heading in ⑦, and put each person's 3 dots on the heading rows. Done when everyone has placed 3 dots.
Split into 3 piles
Looking at the dots and the table, copy the headings with counts into boards⑩ (report), ⑪ (fix now), and ⑫ (ask again). Done when every heading in ⑦ and ⑧ is somewhere.
Write the reasons
In board⑬, write one line each for the chosen headings and reasons, the skipped headings and reasons, and where the skipped voices go. Done when all 3 lines are filled.
Fix and report
On page 4, decide how to fix the voices to fix now and the questions for next time, then write the report content with owners and deadlines. One round ends when you read the signals in the next survey and decide whether to continue.
Set fixes and owners
In the branches of board⑭, add the fixes from ⑪ and the questions from ⑫, and in the table of board⑯, write owner, deadline, and how to check. Done when owners and deadlines for all 4 rows are filled.
Plan the report
In board⑮, write who gets the report and how, the order and length, and the voices you leave out. Done when you make the report with that content and hand it over.
Decide by the signal
After the next survey, look at the "Signal and fallback" column of board⑯, decide to keep, change, or stop for each row, and write the result beside the column. If a row says stop, go back to the board frame it names and choose again.