How to View Google Form Responses: A Comprehensive Guide
Google Forms is a versatile tool that allows you to create surveys, collect data, and even conduct polls. Once you've received responses, you'll naturally want to view and analyze them. This guide will walk you through the process of viewing Google Form responses, ensuring you make the most of your collected data.
Accessing Your Google Form Responses
Before you can view your responses, you need to access the Google Form. Here's how:
- Open your Google Drive.
- Locate the folder containing your Google Form.
- Click on the form to open it.
Viewing Responses in the Google Form Interface
Google Forms provides a simple way to view responses directly within the form interface.

- Open your Google Form as described above.
- Click on the three vertical dots (⋮) in the top-right corner.
- Select "View responses" from the dropdown menu.
This will open a new tab with a summary of responses. Here, you can see the number of responses, the response rate, and a summary of answers for each question.
Analyzing Responses in Detail
While the summary view is helpful, you might want to analyze responses in more detail. Google Forms allows you to do this in two ways: using the built-in response view or exporting the data to Google Sheets.
Using the Built-in Response View
To view individual responses:

- Follow steps 1-3 from the previous section to open the response summary.
- Click on the three vertical dots (⋮) in the top-right corner of the response summary.
- Select "Show question by question" to view individual responses.
Here, you can see each response as a separate row, with columns for each question. You can also sort and filter responses based on specific questions or answers.
Exporting Responses to Google Sheets
For more advanced analysis, you can export your responses to Google Sheets.
- Open your Google Form and follow steps 1-3 from the first section to open the response summary.
- Click on the three vertical dots (⋮) in the top-right corner of the response summary.
- Select "Select response destination" from the dropdown menu.
- Choose "Create a new spreadsheet" or "Select existing spreadsheet".
- Click "Create" or "Select" depending on your choice.
Your responses will now be exported to a Google Sheet, where you can perform more complex analysis using tools like pivot tables, charts, and add-ons.
Sharing and Collaborating on Responses
Google Forms allows you to share and collaborate on responses with others. Here's how:
- Open your Google Form and follow steps 1-3 from the first section to open the response summary.
- Click on the three vertical dots (⋮) in the top-right corner of the response summary.
- Select "Share" from the dropdown menu.
- Enter the email addresses of the people you want to share the responses with.
- Choose the level of access you want to grant (view, comment, or edit).
- Click "Done".
Now, the people you've shared the responses with can view, comment on, or edit the data, depending on the access level you've granted.
Conclusion
Viewing and analyzing Google Form responses is a crucial step in understanding and acting on the data you've collected. Whether you're using the built-in response view or exporting data to Google Sheets, Google Forms provides a range of tools to help you make the most of your responses. Happy analyzing!