- Online assessments
- Collecting data for science experiments
- Brainstorming ideas in class
- Completing a reading log
- Surveying parents
- Accepting technology help tickets
- And much more…
Now the new version of Google Forms does let you view each response one at a time, which is a definite step forward (click “Responses” then click “Individual”) but it is still not an easy way to view all the responses at once in an easy to read format.
One of the best solutions to this problem is an add-on for Sheets called “Save as Doc”. See below for detailed directions on how to use “Save as Doc” to take responses from a Google Form and put them in a readable format as a Google Doc.
“Save as Doc” is a useful and easy add-on for Google Sheets. What it does is take one row at a time, where the data normally goes from left to right cell by cell, and creates a Google Doc where the same data is displayed vertically one line at a time, in question / answer format, making it much easier to read.
- From Google Sheets click “Add-ons” then “Get add-ons”.
- Scroll down to find “Save as Doc” or search for “Save as Doc”.
- Alternately you can just go to this link: Save as Doc add-on link
- Click the “+ FREE” button to install the add-on.
Once you have “Save as Doc” add-on installed you can use it on any spreadsheet. Most often you may find it useful for the Google Sheet that holds the responses from a Google Form, especially one with long answers.
- Start by selecting the rows and columns of data you wish to turn into a Google Doc.
- Simply click, hold down your mouse button, and drag to highlight the desired data in your Google Sheet.
- Now click “Add-ons” then “Save as Doc” then “Start”.
- This will open a panel on the right side of the Sheet.
- For “Save Doc file” type in a name for the new document that will hold the data.
- Check “Include Headings” if you would like the column headings to appear above each item in the Doc. This can be useful so you remember what question each answer goes with.
- If you chose to include headings, you can specify where the headings are found in the “Headings Location” drop down menu.
- You can also select the size for the headings in the Doc from “Heading 1” (large) to “Heading 5” (small).
- Check the box for “Add a pagebreak after each row” to start a new page in the Google Doc for each row in the spreadsheet. This will put all the answers from each person who filled out the form on a different page of the Doc.
- Finally click the “Save as Doc” button.
- When done you can click the “Open the Doc” link to view your new document.
- You now will have all of the responses to your Google Form in an easy to read Google Document.
- The answers from each person will be on their own page, listed vertically in question / answer format.
- As usual you can now share this document with others who may need to review the responses as well.
Certainly there are other options for reformatting the responses to a Google Form. For example, you could use the "autoCrat" add-on for Sheets to do merge the responses into separate Google Docs. Although I love autoCrat and use it extensively it is more complicated, and more powerful, tahn what may be needed in this case..
When you need a quick and easy way to make Form responses easier to read, the “Save as Doc” add-on is a perfect match.
Post by Eric Curts. Bring me to your school, organization, or conference with over 50 PD sessions to choose from. Connect with me on Twitter at twitter.com/ericcurts and on Google+ at plus.google.com/+EricCurts1