All tools

Analyze Google Forms responses

The Google Forms summary shows one chart per question with every answer together. To see results by department, location or group you have to build pivot tables in Sheets. Here you upload the responses file and see it in seconds: percentages, scale averages, calculated NPS and every question compared by the groups you choose.

Upload your responses file

CSV or Excel downloaded from Google Forms, Microsoft Forms or a spreadsheet with one column per question.

Your file is analyzed in your browser. It is never stored or sent to a server.

How to use it

In Google Forms, open the Responses tab, click the three dots and choose "Download responses (.csv)". The Excel of the linked sheet works too: in Sheets, File > Download > Microsoft Excel.

Upload the file here. Each column is a question: choice questions show percentages, scales their average, 0 to 10 questions with "recommend" in the title their NPS, and open questions a few examples.

Pick a question in "Compare by" (department, location, age, course…) and every other question is split by those groups, with how many responses each has.

It also works with exports from Microsoft Forms, Typeform or any spreadsheet with one row per response and one column per question.

How to read the results

  • For checkbox questions (several answers), percentages add up to more than 100%: each one is the share of people who ticked that option.
  • When comparing groups, look at each group’s n. With fewer than 30 responses per group, a gap of a few points can be chance.
  • NPS goes from −100 to 100: the share of promoters (9 and 10) minus the share of detractors (0 to 6).
  • If an agreement scale shows no average, its options were not recognized as a scale. In SurvIQ you can set the value of each option.
Step-by-step guideHow to analyze Google Forms responses beyond the summaryAnalyze Google Forms responses: averages, comparison by group, filters and charts by department, in Google Sheets or by importing the CSV into SurvIQ.

Frequently asked questions

Are my responses uploaded to a server?
No. The file is read and analyzed in your browser. It is not stored or sent to SurvIQ or anyone else.
Do I need an account?
Not to see the analysis. To save it, filter by several questions, group comments with AI or export to PowerPoint, create a free account and import the same file.
How do I download Google Forms responses?
In the form, Responses tab, three-dot menu, "Download responses (.csv)". If responses are linked to a spreadsheet, you can also download that sheet as Excel.
Why did a question show up as text?
If almost every answer is different (comments, for example), it is shown as an open question with a few examples.
How many responses can it read?
Up to a 15 MB file, which is usually tens of thousands of responses. Very large files can take a few seconds.

Know what you want to ask?

Build the survey in SurvIQ, share it by link, WhatsApp or QR code, and watch results come in live. The Free plan is free forever.

Create a free survey

More tools