View and manage form responses
Once you’ve created your form and sent it to recipients, you’re able to view the responses you’ve received in three different ways: as a summary of responses, in a separate spreadsheet, or as a downloaded CSV. If you’d like a broad overview of how your group of respondents answered each question, viewing the summary is the way to go. If you’d prefer a fine-grained perspective on all the data you’ve collected with your form, you’ll likely want to view the responses in a spreadsheet or download a CSV with response data.
View the summary of responses
To quickly see how many users filled out a form and what their responses are, you can check out the response summary. From your form, click the Responses menu and select Summary of responses.
If you'd like respondents to be able to see this same summary of responses, check the box in the "Confirmation page" section of your form labeled Publish and show a link to the results of this form. When this box is checked, users who respond to your form will see a “See previous results” link, which they can click to view the response summary.
View form responses in a spreadsheet
To see a spreadsheet with responses to your form, click the View responses button in the toolbar. Learn more about storing responses in a spreadsheet.
Download responses as a CSV
To download all the responses your form has received, click the File menu, select Download as, and click Comma Separated Values.
Limit users to one response per form
If you want to keep users from submitting your form more than once, check the box next to "Limit to one response per user" in the "Form Settings" section at the top of the form.
Please note that while users will be asked to log in to their Google Account in order to access and fill out the form, their actual usernames will not be recorded.
Stop collecting form responses
To close your form to new responses, click the Accepting Responses button in the toolbar to toggle responses off. The toolbar button will then say "Not accepting responses." If you’d like to re-open your form to responses again later, you can click this button again to toggle responses back on.
If a form is no longer accepting responses, visitors to the form will see a message letting them know their responses won’t be collected. To customize this message, change the text that appears under the heading "This form has been turned off," which appears near the top of your form.
Copy a form or spreadsheet
You can copy any form or spreadsheet by clicking the File menu and selecting Make a copy. Copying a form will copy only the questions and layout, not the responses you’ve already received.
Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.