Once data starts coming in on your Google Forms, it can be hard to decipher all of the answers through the Forms results alone. Luckily, there is an option for Forms to create its own Google Sheets document, separating the data out and allowing users to sort, filter, and more. Follow these steps to create a Google Sheets document from your Google Forms:
- Open the Google Forms document you wish to review. and click on Responses at the top center of your form.
- Click on the Google Sheets icon in the top right corner of the Responses screen.
- In the pop-up window, choose whether you would like to open the information in a new Google Sheets document (you may rename it) or if you want to add it to an existing document (select the document you would like), then click Create.
- Once you have decided, the document will open. The sheet will update itself anytime more answers are submitted.
Note: You can still follow these steps, even if no results have been submitted.