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

New Google Forms (No "File" menu at top)
  1. Open the form.
  2. At the top, click the Responses tab
  3. Click the More icon .
  4. Select Choose a response destination.
  5. Choose from the following destinations:
    • New spreadsheet: Creates a new spreadsheet in Google Sheets for responses
    • Enter in an existing spreadsheet: Choose from your existing spreadsheets in Google Sheets to store responses
  6. Click Create.

You can find the response spreadsheet in the Sheets homescreen (sheets.google.com), the Sheets Android and iOS mobile apps, or in your Google Drive (drive.google.com).

Old Google Forms ("File" menu visible at top)
  1. Open your form.
  2. Choose an option based on whether you're editing or sending the form:
    • 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 asked to choose a destination.
  3. Choose from the following destinations:
    • New spreadsheet: Creates a new spreadsheet in Google Sheets for responses
    • New sheet in an existing spreadsheet: Choose from your existing spreadsheets in Google Sheets to store responses
    • Keep responses only in Forms: View a summary of responses or download a .csv file of individual responses

You can find your response spreadsheet in the Sheets homescreen (sheets.google.com), the Sheets Android and iOS mobile apps, or in your Google Drive (drive.google.com).

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.

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.

New Google Forms (No "File" menu at top)
  1. Open your form.
  2. At the top, click the Responses tab.
  3. Click the More icon .
  4. Select Change response destination.
  5. Choose whether to create a new spreadsheet for your responses or send them to an existing spreadsheet.
  6. Click Create.
Old Google Forms ("File" menu visible at top)
  1. Open the 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.

New Google Forms (No "File" menu at top)
  1. Open the form.
  2. At the top, click the Responses tab.
  3. Click the More icon .
  4. Select Unlink Form.
Old Google Forms ("File" menu visible at top)
  1. Open the 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?