To see the spreadsheet with the form responses, click See responses at the top-right of the form and select Spreadsheet. It's a good idea to use the same name for the form and the spreadsheet, so you can quickly find both of them in your Docs list.
To quickly see how many users filled out a form and what their responses are, you can check the response summary. From your spreadsheet, go to Form > Show summary to view it.
The response summary page opens in a new window.
Note: As you're reviewing the responses, keep in mind that you can't prevent users from submitting a form more than once, so the same person may have submitted multiple responses. If you use Google Apps, however, you can choose to record the email addresses of people who fill out your form, and then easily identify any duplicate responses.
You can allow those who filled out your form to see a summary of the responses. Select the option 'Let everyone see response summary' in the 'Edit confirmation' window to make the summary viewable to everyone.
If you'd like to print your form responses summary, open your browser's Print menu.
Editing the spreadsheet with the responses
Here are some changes you can make to the spreadsheet:
- Insert columns to add your own content, such as calculations, notes, or lookups, next to form responses.
- Insert rows at the top, below the column headers and above the area where data is collected. The form responses will always be inserted in the first available row.
- Insert new sheets or move sheets. Responses will continue to be automatically entered in the same sheet.