How to find answers on Google Forms in 3 different formats, as well as in Google Sheets
- You can find answers on Google Forms as a creator after sending one out and receiving feedback.
- You can view respondents' answers in three different ways: as a summary, by question, or by individual respondent.
- You can also view answers via Google Sheets if you prefer.
If you've sent out a Google Form and begun to collect responses, you'll want to be able to see what people answered. Fortunately, Google Forms makes the whole process easy to understand.
Here's how to find respondents' answers on your Google Forms.
How to find answers on Google Forms
1. Open your Google Form.
2. Click on "Responses."
3. After you've opened the Responses tab, you will be able to view answers in three different ways: "Summary," "Question," and "Individual."
4. Click on the "Summary" tab to view a summary of all answers submitted to your Google Form. These may appear as charts and graphs, or in other formats.
Note: If one of your questions requires respondents to submit a file, the file names will be listed, but you will need to click "View folder" to see thumbnails for all of the submitted files.
5. Click on the "Question" tab to view collection data for specific questions on your form. The responses you are viewing will be for the specific question listed in the drop-down menu.
Note: To select the question you wish to view, click on the drop-down menu and then click on the desired question. You can also click on the arrow icons next to the drop-down menu to navigate through the questions.
7. Click on the "Individual" tab to view specific respondents' answers to each question. To navigate between respondents, click on the arrows in the top banner.
How to find answers on Google Sheets
You can also view answers to your Google Form via a spreadsheet that is automatically saved when creating a Google Form. First, open the Google Form within Google Drive.
1. Click on the Responses Tab.
2. Select the Google Sheets icon in the top right corner.
3. You should now see the responses displayed in a spreadsheet.
To turn on email notifications after respondents fill out your form, all you have to do is click the three-dot icon under the same Responses tab and select "Get email notifications for new responses."
Related coverage from Tech Reference:
What are Google Forms? Everything you need to know about Google Workspace's online form builder
How to embed Google Forms to share surveys on your website
How to upload a file on Google Forms or let respondents upload their own files
Are Google Forms anonymous? Here's how to enable anonymous responses and know whether yours is
How to create a chart or graph in Google Sheets to get a visual display of your data