You created a Google Form and you want to retrieve all your responses. This article explains where your data are displayed and how to open your responses spreadsheet.
How do you link a Google Sheet to your form to retrieve all responses?
You created a Google Form and your recipients submitted their responses. To read all the responses click ‘Responses’:
In the responses tab of your form, Google Form automatically creates a summary of all the responses.
You can also have all the data input in a Google Spreadsheet. To create a spreadsheet, click on the green spreadsheet icon:
If you never created a spreadsheet from your Google Form, you will see the following pop-up:
You can either create a completely new spreadsheet or you can select an existing spreadsheet (a new tab will be created at the bottom of your existing spreadsheet).
If you select an existing spreadsheet you can have several different forms linked to this specific spreadsheet separated by different tabs.
In our example, we created a new spreadsheet. To do so, select ‘Create a new spreadsheet’. Then, click ‘Create’:
How does your responses spreadsheet looks like?
Your spreadsheet opens in a new window:
The first column contains your 'Timestamp', which indicates the date and time the recipient submitted the form:
Then all the questions are displayed on the header (first row) of your spreadsheet (displayed in the same order as in your Google Form) and you can see how each recipient answered to your questions:
Why is your responses spreadsheet useful?
For several reasons, your responses spreadsheet can be used to:
- Create dynamic charts: You can use Advanced Summary by Awesome Table
- Easily compare your recipients’ answers
- Know when the recipients have submitted your form
- Have different forms linked in one Google Spreadsheet
- Make sure Form Publisher has generated attachments or added linked URL (depending on your configuration)
Note: If you want to transform any data into beautiful, dynamic and functional views from a data source Google Spreadsheet, we suggest you to use Awesome Table!