Form Responses

Store Form Responses in a Google Sheet

Once you've created the form, you don't need to do anything extra to store respondents' answers in Google Forms.

By default, it'll save each answer in the Responses tab, showing summary graphs and lists of answers. An individual response view shows the live form along with the results from each respondent.


That's great for quick form results, but for more tools to analyze answers, you can link your form to a Google Sheet spreadsheet too!

Click the Green Sheets icon in the Responses tab or click Select Response Destination within the menu, then create a new spreadsheet or select an existing one to store the answers.

Screenshot of a Google Sheets response window. In the top left, there is header text that reads 0 responses. In the top right, there is an icon of a green sheet and an icon with three horizontal dots. Below that is text that reads Create Spreadsheet. There was also text below that that says Accepting Responses (with a toggle next to it).
When using educational technology tools, be FERPA aware. To learn more, visit the Registrar's FERPA Guidelines site.