Google Forms is great for collecting info from lots of people, but sometimes, seeing all that data within the form itself can get a bit messy. It can be hard to analyze when you’ve got tons of responses piling up. That’s where linking to a Google Sheet comes in handy - it organizes everything nicely in rows and columns.
Viewing responses within Google Forms
If you want a quick look at responses, just click the Responses tab in your Google Form.
You’ll see all the entries, but they’re grouped vertically by question. This means you might find it hard to work with the data when you have lots of people answering.
Linking your Google Form to Google Sheets
To make things easier, link your form responses to a Google Sheet.
- Click the spreadsheet icon labeled View responses in Sheets. It’s the green icon – easy to spot!
- A dialog box will appear. You can create a new spreadsheet or use an existing one. A new spreadsheet will have the same name as your form by default, but you can change it. Then, click Create.
- Google Sheets will now generate a spreadsheet. The questions from your form are column headers, and there’s an extra column called Timestamp, showing when each submission was received. This makes it simple to sort, filter, and really get to grips with your data.
By linking to a Google Sheet, you gain a much more organized way to handle all the responses you get from Google Forms.