Search
Clear search
Close search
Google apps
Main menu
Docs editors Help
Docs editorsHelp forumForum

Choose where to save form responses

Collect form responses

When you send a form, you can gather the responses inside the form or separately in Google Sheets.

To see a video tutorial about sorting Google Forms responses into different tabs in Google Sheets, visit our Help Forum.

Choose where to store responses
  1. Open a form in Google Forms.
  2. At the top, click RESPONSES.
  3. Below, click More More.
  4. Click Select response destination.
  5. Choose from these options:
    • Create a new spreadsheet: Creates a spreadsheet for responses in Google Sheets
    • Select existing spreadsheet: Choose from your existing spreadsheets in Google Sheets to store responses
  6. Click Create or Select.

You can find the response spreadsheet in the Google Sheets homescreen, the Google Sheets apps, or in Google Drive.

Change where you store responses

If you store your form responses in a spreadsheet, you can change the location at any time.

  1. Open a form in Google Forms.
  2. At the top, click RESPONSES.
  3. Below, click More More.
  4. Select Select response destination.
  5. Choose whether to create a new spreadsheet or use an existing spreadsheet.
  6. Click Create or Select.
Unlink a spreadsheet from your form

If you don’t want any more responses to go to a spreadsheet, you can unlink your form at any time.

  1. Open a form in Google Forms.
  2. At the top, click RESPONSES.
  3. Below, click More More.
  4. Select Unlink Form.

Delete a form or responses

If you keep responses in a spreadsheet, you will have a separate file in Google Drive. You can delete the spreadsheet or the form without deleting the other connected file.

Delete all responses from a form
  1. Open a form in Google Forms.
  2. At the top, click RESPONSES.
  3. Below, click More More.
  4. Click Delete all responses.
Delete individual responses
  1. Open a form in Google Forms.
  2. At the top, click RESPONSES.
  3. Click INDIVIDUAL.
  4. Click Previous Previousor Next Next to find the response you want to delete.
  5. Click Delete Delete.

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

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?