Updated 17 November 2026.
The classic method (thematic coding)
- Read a sample. Read 50 to 100 responses and note the topics that keep coming up.
- Build a theme list. Turn those notes into 6 to 12 themes, each with a one-line description. Add "Other".
- Tag every comment. In a new column, give each response a theme. Add a second column for positive, negative or mixed.
- Count and compare. Use a pivot table to count themes and feelings, and compare groups, such as promoters and detractors.
- Pull quotes. Pick two or three real quotes for each theme to bring the numbers to life.
Done by hand, this takes about an hour per few hundred responses, and it's easy to drift as you go.
The fast way
Drop your export into Naina and use the Themes task. It reads a sample to learn your themes, tags every comment with a theme, a feeling and urgency, counts the results and writes the story, with quotes. Personal details are hidden on your device first. Then ask follow-up questions in the chat.
Questions
How many themes should I use?
Usually 6 to 12. Fewer is easier to act on.
Should I tag comments with more than one theme?
It's more accurate but harder to count. Start with one main theme per comment.
Can I check the AI's work?
Yes. Naina shows counts and real quotes for every theme, and you can download every tagged comment as a CSV.
Try Naına
A private AI analyst for your spreadsheets, customer comments and documents, with personal details hidden on your device first. £19.99 a month, cancel any time.