Analyze form responses

Want to get more out of Google apps at work or school?  Sign up for a free Google Workspace trial

After you send out your form, you’ll see responses on the Responses tab. You can also get an email when new responses arrive.

In this section, you learn how to: See responses in Forms See responses in Sheets Download responses as a CSV file

See responses in Forms

You can see a summary of all responses or look at individual responses on the Response tab. You can also view the form questions by clicking on the Question tab. To switch between individual responses, click the individual’s email.

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. In Forms, on the Responses tab, click More Select response destination.
2. Select Create a new spreadsheet.
3. (Optional) To change the name, enter a new one.
4. Click Create.

Send responses to an existing spreadsheet:

1. In Forms, on the Responses tab, click More Select response destination.
2. Select Select existing spreadsheetSelect.
3. Select your spreadsheet and click Select.

To open your spreadsheet from Forms, next to More , 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. In Forms, on the Responses tab, click More Unlink form.
2. Click Unlink to confirm.

Download responses as a CSV file

To export responses for analysis in other programs, you can download them as a CSV file.

In Forms, on the Responses tab, click More Download responses (.csv).

Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.