When responders fill out your form, you can choose if you want to find the responses in a linked Google Sheet.
Choose where to store responses
- Open a form in Google Forms.
- At the top, under “Responses,” click Summary.
- At the top right, click More Select destination for responses.
- Select an option:
- Create a new spreadsheet: Creates a spreadsheet for responses in Google Sheets.
- When you use your Google Forms data to create a new sheet, Google Sheets automatically puts your data in a table, bringing format and structure to your data. Learn how to use tables in Google Sheets.
- Select existing spreadsheet: To store responses, select from your existing spreadsheets in Google Sheets.
- Create a new spreadsheet: Creates a spreadsheet for responses in Google Sheets.
- Click Create or Select.
Important: If you’ve shared a form with a collaborator, they may also have access to the form’s linked spreadsheet. If you want to remove a collaborator, you'll have to remove them from the form and the spreadsheet separately.
Tip: You can find the response spreadsheet in the Google Sheets homescreen, the Google Sheets app, or in Google Drive.
Unlink a spreadsheet from your form
- Open a form in Google Forms.
- At the top, under “Responses,” click Summary.
- At the top right, click More Unlink form .
- Click Unlink.
Delete a form or responses
Tip: If you keep responses in a spreadsheet, you have a separate file in Google Drive. You can delete the spreadsheet or the form without deleting the other connected file. If you delete any responses in a form, it can't be undone.
Delete all responses from a form
- Open a form in Google Forms.
- At the top, under “Responses,” click Summary.
- At the top right, click More Delete all responses .
- Click OK.
Delete individual responses
- Open a form in Google Forms.
- At the top, under “Responses,” click Individual.
- To find the response you want to delete, click Previous or Next .
- Click Delete YES.
Tip: If you store responses in Google Sheets, deleting a response from the form or sheet will not affect the other.