Choose where to save form responses

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

1. Open a form in Google Forms.
2. At the top, under “Responses,” click Summary.
3. At the top right, click More Select destination for responses.
4. 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.
5. 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

1. Open a form in Google Forms.
2. At the top, under “Responses,” click Summary.
3. At the top right, click More Unlink form .
4. 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

1. Open a form in Google Forms.
2. At the top, under “Responses,” click Summary.
3. At the top right, click More Delete all responses .
4. Click OK.

Delete individual responses 

1. Open a form in Google Forms.
2. At the top, under “Responses,” click Individual.
3. To find the response you want to delete, click Previous or Next .
4. Click Delete YES.

Tip: If you store responses in Google Sheets, deleting a response from the form or sheet will not affect the other.