To create a the Responses spreadsheet, click on the green spreadsheet icon in the Responses tab. How do you link a Google Sheet to your form to retrieve all responses? You can also use the responses spreadsheet to more easily compare differences between respondents' answers to questions. In the responses spreadsheet, a column represents a question in your Google form, and a row represents all replies to all form questions given by a single form respondent. If you have responses in your current Google form, creating a responses spreadsheet opens a brand new Google spreadsheet which contains all responses data gathered so far. You can create a Google form responses spreadsheet manually by clicking the Create Spreadsheet button in the Responses tab. Google Forms does not create and link a responses spreadsheet automatically. In the Individual subtab, you can review how each individual respondent answered all of the questions.įor each Google form, you can store responses in a spreadsheet, also called the responses spreadsheet. You switch between questions with the paging buttons at the top. In the Question subtab, you can review how all respondents replied to a question. For example, for multiple choice questions you can review the percentages of people who selected one answer or another. In the Summary subtab, you can review all replies submitted to each question in the form.įor different types of questions, you can see a graphical breakdown of the replies. The Responses tab contains 3 subtabs: Summary, Question, and Individual. Google Forms counts a single form submission as one response.ĭata from all responses is available immediately after each form submission in the Responses tab. Responses in Google FormsĪ response in a Google form includes the replies to all questions made by a form respondent when they submitted the form. Warning Be careful! Your responses spreadsheet is different from your Google Sheets template.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |