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.
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.
- Open a form in Google Forms.
- At the top, click Responses
Summary.
- At the top right, click More
Select destination for responses.
- 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.
- 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
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.