Embedded Files
Prefer to print this page? (opens in a new window)
Store Form Responses in a Google Sheet
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.
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.
When using educational technology tools, be FERPA aware. To learn more, visit the Registrar's FERPA Guidelines site.
Page updated
Report abuse