Google Forms collects survey results and presents a summary of results by displaying a table of all survey results in one view. However, for some surveys, particularly those with long form answers, they are easier to present when all of the results are displayed on a single page per form entry. This document explains how to use Microsoft Word to create a document that will display all your form results for easy presentation.
- Export Google spreadsheet as an Excel file: File > Download As > Microsoft Excel 97-2003 (.xls)
- Open Microsoft Word and select the Mailings Tab
- Click on the Select Recipients button and choose Use Existing… then navigate to the file you downloaded in step 1.
- Under the “Insert Merge Field” button you should now see the header names (which are your truncated questions from the Google form). You can drag these into the Word document and they will be replaced by each person’s response. You also can type your own text into the document which will be the same on each page. It is a good idea to put the questions into the document above each response.
- You can click the Preview Results button to see how your form responses will look in the document.
- When you are done you can merge to a new document or to a printer to get each entry displayed in a single document (use save to PDF from the print dialogue to get a PDF output suitable for emailing or archiving).
- Save the Word file when you are done.
- If you get more results later, you can download a new Excel spreadsheet and replace the old one. Your Word document will automatically use the new Excel file.
For questions, contact the CIT HelpDesk by calling (585) 245-5588, or visiting our online service desk.