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 an entirely new spreadsheet, or you can select an existing one (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 look 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
- Quickly 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 URLs (depending on your configuration)
Note: If you want to transform any data into beautiful, dynamic and functional apps from a data source Google Spreadsheet, we suggest you to use Awesome Table!
Comments
7 comments
Thanks for the summary. Is there a good place to see who responded or who didn't? If I send the survey to 10 people and only have 4 responses, is there any way to identify the missing six responses? Either by email address or some other name?
It's pretty easy to remember with a five member test survey, but I'm likely going to do a 30+ member survey and was just hoping to have a list of the non-responses as well (so I might ask in person, etc). Thanks for any ideas.
This wont show approval status though.
Hi Raymond,
If you have enabled the workflow approval then yes, it should display the approval status of the submission.
Thanks
Rémi - Form Publisher Support Team
Hi,
I have done the above steps, but what if I want to add these responses to a new form? Is this possible? I have spent hours looking for an answer.
Or when I duplicate a form, I want to have the answers copied as well.
help, please!
Hi Mike,
Thanks for your message.
Your questions go beyond the scope of Form Publisher.
I would suggest checking Google Form's documentation for that.
If you need assistance from us, you can always reach us here.
Have a good one,
Carlos - Form Publisher Support team
Hi Some of my colleague accidentally deleted the responses from Google forms and its showing empty, how we can retrieve the data back?
Hi Asad Zeeshan,
I've looked this up on the web and it appears this action is non-reversible. This is something that is outside of Form Publisher and is completely within your Google Form. I tested this locally and it says something like:
"Are you sure that you want to delete all form responses? This action cannot be undone. Responses already sent to a spreadsheet will not be deleted."
The responses in your responses spreadsheet will still be present but the deleted responses in your Google form appear to be unrecoverable.
I hope this answers your question.
Many Thanks!
Jhong - Form Publisher Support Team
Please sign in to leave a comment.