Choose where to save form responses

This article is for form creators and it explains where you can save your form responses.

When responders fill out your form, you can find a summary of the responses in the form or you can store the responses in a linked Google Sheet.

Find responses to your form

1. Open a form in Google Forms.
2. At the top, click Responses.
3. In the “Summary” tab, you can find the list of people who responded to your form.

Tip: The “Summary” tab displays on a form only when there’s one or more responses.

Choose where to store responses

If you store your responses in a spreadsheet, Google Sheets automatically puts your data in a table. It gives your data format and structure. Learn how to use tables in Google Sheets.

1. Open a form in Google Forms.
2. At the top, click Responses Summary.
3. At the top right, click More Select destination for responses.
4. Select an option:
   • Create a new spreadsheet: Creates a spreadsheet in Google Sheets.
   • Select existing spreadsheet: Select the existing spreadsheet that you want to store the responses in.
5. Click Create or Select.

Tips:

• 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 have to remove them from the form and the spreadsheet separately.
• You can find the response spreadsheet in:
  • The home screen of Google Sheets
  • The Google Sheets app
  • Google Drive

Unlink a spreadsheet from your form

To stop the collection of responses in a spreadsheet, you can unlink it from your form. New responses won’t be sent to the spreadsheet, but your current data remains intact. You can use "Select destination for responses" to reconnect a spreadsheet later.

1. Open a form in Google Forms.
2. At the top, click Responses Summary.
3. At the top right, click More Unlink form .
4. Click Unlink.

Delete a form or responses

If you store responses in a spreadsheet, you have a separate file in Google Drive. You can delete the spreadsheet and not delete the form, or you can delete the form and not delete the spreadsheet.

If you delete any responses in a form, it can't be undone.

Important: If you are responding to a form, find how to save and delete your responses: Auto-save your response progress on a Google form.

Delete all responses from a form

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

Tip: The “Summary” tab displays on a form only when there’s one or more responses.

Delete individual responses 

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

Related resources

• View & manage form responses
• Auto-save your response progress on a Google form