How to find answers on Google Forms in 3 different formats, as well as in Google Sheets (2023)

  • 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.

(Video) Use Google Forms to Auto Fill Google Sheets with Data

How to find answers on Google Forms

1.Open your Google Form.

How to find answers on Google Forms in 3 different formats, as well as in Google Sheets (1)

Chrissy Montelli/Business Insider

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."

How to find answers on Google Forms in 3 different formats, as well as in Google Sheets (2)

Chrissy Montelli/Business Insider

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.

How to find answers on Google Forms in 3 different formats, as well as in Google Sheets (3)

(Video) Pre-fill Google Forms with Answers from Google Sheets

Chrissy Montelli/Business Insider

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.

How to find answers on Google Forms in 3 different formats, as well as in Google Sheets (4)

Chrissy Montelli/Business Insider

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.

(Video) Sort Responses from Google Forms to Google Sheets Tabs

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 fromTech Reference:

Chrissy Montelli

(Video) Using conditional formatting in a Google Form response spreadsheet

Chrissy Montelli is a writer and content creator originally from Long Island, NY. She is the author of two poetry chapbooks,Heart Float(Bottlecap Press) andGoing to Ithaca(Ghost City Press), as well as various online publications. Read more from her atchrissymontelli.wordpress.com.

NOW WATCH: Worst tech of the decade

How to find answers on Google Forms in 3 different formats, as well as in Google Sheets (5)

FAQs

How do I see multiple responses in Google Forms? ›

The multiple-choice option you see asks one question and gives a list of possible answers. Instead, what we want is a number of questions that all have the same answer options. You can create that by clicking the dropdown in the upper right-hand corner of the form that currently displays Multiple choice.

How do you select 3 options in Google Forms? ›

Here is how it works.
  1. Open you Google Forms.
  2. Create a Multiple choice grid question, and type your question in.
  3. In Rows, add first choice, second choice, third choice and so on.
  4. In Columns, add choices from which you want respondents to choose.
  5. Turn on Require a response in each row.
Aug 2, 2020

How do I get answers from Google Sheets? ›

On your computer, open a spreadsheet in Google Sheets. If you want to ask questions about data that's on a different sheet, at the top right click Edit and make your changes. Under "Answers," enter your question in the box and press Enter. To find answers, click the question under the text box.

What are the three types of ways to view Google form responses? ›

At the top of the form, click the Responses tab. Note that you can see the number of responses you've received right on that tab. You can then view your responses in different ways using the three tabs at the top for Summary, Question, and Individual.

Can Google form responses go to multiple sheets? ›

Just click the green Sheets icon in the Responses tab or click Select response destination in the menu, then create a new spreadsheet or select an existing one to store the answers. Note: You can store results from multiple forms in one spreadsheet; each form's responses will be saved to a separate sheet.

Can Google Forms detect multiple tabs? ›

All Replies (3)

No the teacher will not be informed. As Google Form has no such functionality.

Videos

1. Automatically moving and sorting Form Response Data
(JAMIE DYRA)
2. Collect Data into Google Sheets | Forms, Quizzes, Surveys
(Prolific Oaktree)
3. Google Forms - Create Dropdown Lists and Multiple-Choice Questions from Google Sheets
(Digital Inspiration)
4. Accept Multiple Answers in a Short Answer Question in Google Forms
(Kimberly Mattina)
5. Have Multiple Forms feed information to a Single Sheet
(Flipped Classroom Tutorials)
6. How to Add Multiple Answers at Once into Google Form Questions
(Journey Bytes)
Top Articles
Latest Posts
Article information

Author: Zonia Mosciski DO

Last Updated: 03/31/2023

Views: 6265

Rating: 4 / 5 (71 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Zonia Mosciski DO

Birthday: 1996-05-16

Address: Suite 228 919 Deana Ford, Lake Meridithberg, NE 60017-4257

Phone: +2613987384138

Job: Chief Retail Officer

Hobby: Tai chi, Dowsing, Poi, Letterboxing, Watching movies, Video gaming, Singing

Introduction: My name is Zonia Mosciski DO, I am a enchanting, joyous, lovely, successful, hilarious, tender, outstanding person who loves writing and wants to share my knowledge and understanding with you.