April Tip #2: Google Sheet AddOn: Save as Doc

Google Sheet AddOn: Save as Doc

This week’s tidbit is another AddOn for Google Sheets. We recently did a survey using Google forms. As we were looking over the survey results in the Google sheet it was hard to read all of the input scrolling through the sheet. The perfect answer to read through the results was the AddOn for Google sheets called Save as Doc. To add this AddOn

• Open your Sheet of Form Results (This would also work on a regular Google sheet not connected to a form as well)
• Click on AddOns - Get Addons
• Search for Save as Doc and add it to your Google sheet.
• Click on AddOns - Save as Doc - Start
• An information box appears on the right hand side of your screen
• In the top box, type in the name you want for your created Google document
• Click the box to include your headings
• Leave the default selection stating that the first row of the sheet contains your headings or select the alternate choice of first row of selection contains your headings
• Next, pick your heading style (Note: All headings appear in the Google doc using this heading style with individual answers under the heading)
• Check the box to add a page break after each row (This puts each line of information in the Google sheet on its own page
• Then click the box that says Select All Data
• Once you click that box, text should appear below that says “All data has been selected!”
• Click Save as Doc
• The Google doc will generate
• Click at the bottom to Open your Document

Here is a sample Google sheet as well as the sample result from the Save as Doc AddOn. This worked on survey results, but it’s also a great way to print out student answers to a Google form as well.