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.

Stays in Google SheetsNo exporting, no copying answers into another tool. It works in the sheet your form already fills.
Hundreds of answers, quicklyTag an answer in one click, or tag every answer that mentions a word at once.
Results you can shareA summary sheet with counts, percentages, example quotes and a chart, ready for a report or a meeting.

How it works

  1. Pick your questionOpen the spreadsheet your Google Form fills, choose the column of written answers, and click Code this column.
  2. Make a few codesAdd short labels for the ideas you expect, such as homework load. Add more as new ideas appear.
  3. 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.
  4. Build your summaryOne click adds a summary sheet with how often each code came up, example quotes and a chart.
Your codes stay in your sheet

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
Year
What one thing would make school better?
Themely codes
Year 7
The lunch queue is so long I only get ten minutes to eat.
Lunch and food
Year 9
Less homework on the same night, sometimes I get four pieces at once.
Homework load
Year 10
I feel stressed about GCSEs and don't know who to talk to.
Wellbeing
Year 7
More clubs at lunchtime, especially art and coding.
ClubsLunch and food
Year 8
Bullying on the bus home, nobody does anything about it.
not coded yet

Your summary, in one click

CodeAnswersShareExample quote
Lunch and food930%Longer lunch so we can actually eat and see friends.
Homework load620%Homework deadlines all land on the same day.
Wellbeing517%Someone to talk to when exam stress gets bad.
Clubs413%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.

D

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
Department

£149 / year

Pro for up to 60 students and staff you name.

Whole university

£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.

Install freeTell us how it wenthello@survivelabs.co.uk