Choose a form response destination

When you send out a form to others, you can collect the responses in a spreadsheet or within the form itself.

Choose where to store responses

Store in a new spreadsheet

You can create a new spreadsheet for form responses.

  1. Open your form.
  2. Choose a destination for your responses:
    • If you’re editing the form, click View responses in the toolbar.
    • If you’re sending the form, click Send form in the top right and follow the directions until prompted to choose a destination.
  3. Choose New spreadsheet.
  4. Click Create.

Click the View responses button in the toolbar to see individual responses or find the spreadsheet in Google Drive.

Always collect responses in a new spreadsheet

If you’d like all of your forms to collect responses in a new spreadsheet, check the box next to “Always create a new spreadsheet” when you choose a destination in a form.

Store in an existing spreadsheet

You can choose to store responses to your form in an existing spreadsheet. If you choose this option, it will create a new page in the spreadsheet.

  1. Open your form.
  2. Choose a destination for your responses:
    • If you’re editing the form, click View responses in the toolbar.
    • If you’re sending the form, click Send form in the top right and follow the directions until prompted to choose a destination.
  3. Choose New sheet in an existing spreadsheet.
  4. Click Choose.

Click the View responses button in the toolbar to see individual responses or find the spreadsheet in Google Drive.

Keep responses in the form

You can choose to keep responses to your form in the form itself. If you choose this option, you can either view a summary of the responses or download a CSV file with individual responses.

  1. Open your form.
  2. Choose a destination for your responses:
    • If you’re editing the form, click View responses in the toolbar.
    • If you’re sending the form, click Send form in the top right and follow the directions until prompted to choose a destination.
  3. Click Keep responses only in Forms.

To see a summary of your responses, click the Responses menu > Summary of responses. You can also download a copy of the individual responses by clicking the File menu > Download as > Comma separated values.

More options

Change where you store responses

If you've chosen to store your form responses in a spreadsheet, you can change this destination at any time.

  1. Open your form.
  2. Click the Responses menu.
  3. Select Change response destination.
  4. Choose whether to create a new spreadsheet for your responses or send them to an existing spreadsheet.
  5. Click Create (or Choose for an existing spreadsheet).
Unlink a response spreadsheet

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

  1. Open your form.
  2. Click the Responses menu.
  3. Select Unlink form.

The spreadsheet will no longer receive new responses, but responses will continue to be stored in Forms, available as a real-time summary or as a CSV file. You can re-link your form to a spreadsheet by clicking View responses in the toolbar.

Related topics

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

Was this article helpful?