7.4 Analyze form responses

See responses in Sheets

To analyze your responses further, you can send them to a spreadsheet. The spreadsheet is linked to your form, so responses appear in real time.

Send responses to a new spreadsheet:

• 1. On the Responses tab, click More Select response destination.

  2. Click Create a new spreadsheet.

  3. (Optional) To change the name, enter a new one.

  4. Click Create.

Send responses to an existing spreadsheet:

• 1. On the Responses tab, click More Select response destination.

  2. Click Select existing spreadsheet.

  3. Click Select.

  4. Select your spreadsheet and click Select.

To open your spreadsheet from Forms, click View responses in Sheets . The spreadsheet opens in a new window. To go back to Forms, click FormShow summary of responses or go back to the Forms window.

Stop sending responses to a spreadsheet:

• 1. On the Responses tab, click More Unlink form.

  2. Click Unlink to confirm.