themely for Sheets
Your surveyanswers,sorted.
Got a Google Form full of written answers? Themely for Sheets shows them one at a time. Give each one a short label, like homework load or lunch queue (researchers call this coding), and Themely counts the themes, picks example quotes and draws the chart for you.
Free for 50 answers per spreadsheet. Dissertation Pass: £9 for 6 months. Interview transcripts instead? Use Themely for Docs.
How it works
- Pick your questionOpen the spreadsheet your Google Form fills, choose the column of written answers, and click Code this column.
- Make a few codesAdd short labels for the ideas you expect, such as homework load. Add more as new ideas appear.
- Tag each answerThemely shows one answer at a time. Click a code, or press 1 to 9, and it jumps to the next answer you haven't coded.
- Build your summaryOne click adds a summary sheet with how often each code came up, example quotes and a chart.
See every answer and its theme.
Themely adds a column next to your answers with each one's codes, and shades the answer in its code's colour. Filter it, sort it or share it like any other column.
- An answer can have more than one code
- Jump straight to the next answer you haven't coded
- Find every answer that mentions a word and tag them all at once
- Group codes into themes as patterns appear
Your summary, in one click
| Code | Answers | Share | Example quote |
|---|---|---|---|
| Lunch and food | 9 | 30% | Longer lunch so we can actually eat and see friends. |
| Homework load | 6 | 20% | Homework deadlines all land on the same day. |
| Wellbeing | 5 | 17% | Someone to talk to when exam stress gets bad. |
| Clubs | 4 | 13% | Drama club and a school show. |
An example from a made-up student voice survey of 30 answers.
Compare groups (Pro)
See which codes come up most in each group, such as year groups, departments or sites.
Try it first
Not ready with your own data? Try it on a built-in sample survey.
Only this spreadsheet
Themely can only open the spreadsheet you use it in. Your answers stay in your Google account.
Interviews too
Coding interviews instead? Themely for Google Docs works the same way.
Who it's for
Schools
Student voice, parent and staff surveys. Turn a hundred comments into a clear picture for SLT or governors.
Students and researchers
Open-ended questionnaire answers for a dissertation or project, coded in a way you can explain in your methods.
Teams and charities
Customer feedback, event forms and staff pulse surveys, sorted into themes without a pricey survey platform.
Pricing
Free
£0
- Up to 10 codes
- Up to 50 coded answers per spreadsheet
- Summary sheet and chart
Dissertation Pass
£9 / 6 months
- Everything unlimited
- Compare groups
- One-off payment
Pro
£19 / 12 months
- Everything unlimited
- Compare groups
- One-off payment
For universities and departments
Give every student and researcher Themely Pro, in Google Docs and Google Sheets. Pay by card or invoice.
Email us to set it up£149 / year
Pro for up to 60 students and staff you name.
£499 / year
Pro for everyone with your university email address.
One purchase unlocks Themely in both Google Sheets and Google Docs. One-off payments: nothing renews automatically. Full refund within 14 days if it isn't for you.
Questions
What does Themely for Sheets do?
It helps you sort written survey answers into themes. You give each answer a short label (a code), such as “homework load” or “lunch queue”, and Themely counts how often each one comes up, with example quotes and a chart.
Does it work with Google Forms?
Yes. Open the spreadsheet your Google Form sends its responses to, pick the question column, and start coding. It works on any column of text in Google Sheets.
What can Themely see in my Google account?
Only the spreadsheet you open it in. It can't see your other files, and your answers stay in your own Google account.
Is there a free version?
Yes. The free version gives you up to 10 codes and 50 coded answers per spreadsheet. Pro removes the limits and adds group comparisons.
Do I need to pay again if I already have Themely for Docs?
No. One Themely Pro or Dissertation Pass purchase unlocks Themely in both Google Docs and Google Sheets.
Anything else?
Email hello@survivelabs.co.uk. Read our guide: how to analyse open-ended survey answers in Google Sheets.
Install it and try it on your survey
Themely for Sheets is now on the Google Workspace Marketplace. Install it, open any spreadsheet and choose Extensions › Themely for Sheets. There's a sample survey to try first.
Using it on a real survey? Tell us honestly how it went and we'll give you Themely Pro free for a year.