In this tutorial, you will learn how to connect google forms to Google Sheets.
Google Forms is a great tool for collecting survey responses, but when it comes to working with the collected data, it leaves something to be desired. Fortunately, it’s very easy to connect a Google Form to Google Sheets so all form responses are saved to Google Sheets, giving users more powerful tools to analyze response data
Connecting Your Form
You can connect a brand new form with no responses submitted, or an existing form with responses already submitted. Just be sure the questions don’t change after you connect your form, otherwise any calculations or charts in your Google Sheet might not get messed up.
Here’s how to connect a form to Google Sheets
Open the form you want to connect in edit mode, then click on the Responses tab above the questions
In the responses tab, click on the green Google Sheets icon
Decide if you want to create a new spreadsheet, or save form responses to an existing spreadsheet, then click the Create or Select button in the upper-right corner
A new Google Sheets file will be generated with a tab populated with any form responses that have already been submitted. Any new form responses submitted will immediately appear in the spreadsheet as long as the form is connected
Note that sheets containing form responses are easy to spot because there is a purple form icon beside the sheet name
Working with Responses
Once you have your form responses in a spreadsheet, you can use them in calculations to analyze form responses. Note however that it’s best not to directly edit the Form Responses tab while the form is still connected as this can confuse things
A good strategy is to reference form responses in another tab. For example, with the form shown in the above screenshots, you could use the following formula to determine how many drink names have been submitted in the final question: “=COUNTUNIQUE(‘Form Responses 1’!D2:D)”
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to connect google forms to Google Sheets. Want more? Check out all the Google Sheets Tutorials.