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.
- Open a form in Google Forms.
- At the top, click Responses.
- Below, click More
.
- Click Select response destination.
- 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
- Click Create or Select.
You can find the response spreadsheet in the Google Sheets homescreen, the Google Sheets apps, or in Google Drive.
If you store your form responses in a spreadsheet, you can change the location at any time.
- Open a form in Google Forms.
- At the top, click Responses.
- Below, click More
.
- Select Select response destination.
- Choose whether to create a new spreadsheet or use an existing spreadsheet.
- Click Create or Select.
If you don’t want any more responses to go to a spreadsheet, you can unlink your form at any time.
- Open a form in Google Forms.
- At the top, click Responses.
- Below, click More
.
- 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.
- Open a form in Google Forms.
- At the top, click Responses.
- Below, click More
.
- Click Delete all responses.
- Open a form in Google Forms.
- At the top, click Responses.
- Click Individual.
- Click Previous
or Next
to find the response you want to delete.
- Click Delete
.
Note: If you store responses in Google Sheets, deleting a response from the form or sheet will not affect the other.