How to Print Responses from Google Forms

This wikiHow teaches you how to print off the answers submitted on a Google Form that you created. You can print off all responses in their original form layout, which shows each individual's full form. If you prefer to see all the submitted data in a table, you can export the responses to a Google Sheets or MS Excel document and print that off instead.

Method 1
Method 1 of 3:

Printing a Form Layout

  1. Image titled Print Responses from Google Forms Step 1
    1
    Go to https://docs.google.com/forms on your computer. If you're not already signed in, follow the on-screen instructions to sign in now. Make sure you use the same login info you used to create the form.
    • You can also access Forms from the Google Docs home page by clicking on the 3 horizontal lines in the top left and selecting Forms.
  2. Image titled Print Responses from Google Forms Step 2
    2
    Click on your Google form. Look for it under "Recent forms", or select from a folder that you created.
    Advertisement
  3. Image titled Print Responses from Google Forms Step 3
    3
    Click Responses. This is at the top next to "Questions".
  4. Image titled Print Responses from Google Forms Step 4
    4
    Click on the 3 dots in the top right. This is the options menu in the first section that displays the number of responses.
  5. Image titled Print Responses from Google Forms Step 5
    5
    Select Print all responses. This will launch a preview in a new browser tab or window, and a print window will automatically pop up.
  6. Image titled Print Responses from Google Forms Step 6
    6
    Change any desired print settings. Make sure the right printer is specified at the top and change any color or copies settings if required.
  7. Image titled Print Responses from Google Forms Step 7
    7
    Click Print. The document will be sent to your printer.
    8. Advertisement
Method 2
Method 2 of 3:

Printing a Table from Google Sheets

  1. Image titled Print Responses from Google Forms Step 8
    1
    Go to https://docs.google.com/forms on your computer. If you're not already signed in, follow the on-screen instructions to sign in now. Make sure you use the same login info you used to create the form.
    • Make sure to sign in with the same Google account that you used to create the form.
  2. Image titled Print Responses from Google Forms Step 9
    2
    Click on your Google form. Look for it under "Recent forms", or select from a folder that you created.
  3. Image titled Print Responses from Google Forms Step 10
    3
    Click Responses. This is at the top next to "Questions".
  4. Image titled Print Responses from Google Forms Step 11
    4
    Click on the Google Sheets icon in the top right. This is a green icon with 2 intersecting white lines.
    • This opens Google Sheets in a new browser tab or window.
  5. Image titled Print Responses from Google Forms Step 12
    5
    Format the table if desired. Use the settings at the top to change the way that your table looks.
    • For instance, you can change the font style, font color, or draw borders around the table.
  6. Image titled Print Responses from Google Forms Step 13
    6
    Click on the print
    Android 7 Print
    icon.     It's in the top-left area next to the redo button.
    • You can also hit Ctrl+P or ⌘ Command+P to print.
  7. Image titled Print Responses from Google Forms Step 14
    7
    Edit any desired settings. For instance, change the scale to "Fit to width" to fit all columns on the page, or select "Normal" to view it larger.
  8. Image titled Print Responses from Google Forms Step 15
    8
    Click Next. This is a blue button in the top right corner.
  9. Image titled Print Responses from Google Forms Step 16
    9
    Select a printer option and click Print. This will send the document to your printer.
    10. Advertisement
Method 3
Method 3 of 3:

Printing a Table from Excel

  1. Image titled Print Responses from Google Forms Step 17
    1
    Go to https://docs.google.com/forms on your computer. If you're not already signed in, follow the on-screen instructions to sign in now. Make sure you use the same login info you used to create the form.
  2. Image titled Print Responses from Google Forms Step 18
    2
    Click on your Google form. Look for it under "Recent forms", or select from a folder that you created.
  3. Image titled Print Responses from Google Forms Step 19
    3
    Click Responses. This is at the top next to "Questions".
  4. Image titled Print Responses from Google Forms Step 20
    4
    Click on the 3 dots in the top right. This is the options menu in the first section that displays the number of responses.
  5. Image titled Print Responses from Google Forms Step 21
    5
    Select Download responses. This will download the table as a CSV file, which is readable by Excel.
  6. Image titled Print Responses from Google Forms Step 22
    6
    Open the ZIP file. If using Chrome, click the download that appears at the bottom of the screen. If using Firefox or Safari, click the down arrow in the top right corner, then click the file to open.
  7. Image titled Print Responses from Google Forms Step 23
    7
    Double-click on the CSV to open it. This will launch the file in Microsoft Excel.
  8. Image titled Print Responses from Google Forms Step 24
    8
    Format the table if desired. Use the settings at the top to change the way that your table looks.
    • For instance, you can change the font style, font color, or draw borders around the table.
    • Select the table and click Format as table in the Home tab to choose a preset table design.
  9. Image titled Print Responses from Google Forms Step 25
    9
    Hit Ctrl+P or ⌘ Command+P to print the document. You can also go to File > Print.
  10. Image titled Print Responses from Google Forms Step 26
    10
    Change any desired print settings. Make sure the right printer is specified at the top and change any color or copies settings if required.
  11. Image titled Print Responses from Google Forms Step 27
    11
    Click Print. The document will be sent to your printer.
    • If you want to save the newly formatted table, you have to save the file as an .xls or .xlsx file instead of a CSV, since CSV files do not preserve formatting. Go to File > Save as and choose a location. In the file type drop-down, change CSV to Excel Workbook.
    12. Advertisement

You Might Also Like

Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Restore Google AuthenticatorHow to Restore Google Authenticator if You Lost or Reset Your Phone
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
Write a Review on Google2 Ways to Write a Review on Google
Turn Off Google Ads
How to
Turn Off Google Ads
Make a Time Slot Sign Up Sheet on Google FormsHow to Make a Sign Up Sheet with Time Slots in Google Forms
Get a Google Voice Phone NumberHow to Sign Up for a New Google Voice Phone Number
Search by Image on GoogleReverse Image Search in Google Lens: Android, iPhone, & Desktop
Do Google GravityHow to Do the Google Gravity Trick in Your Browser
Make a Google Account5 Easy Steps to Create a Google Account on Any Device
Create a Website Using Google Sites
How to
Create a Website Using Google Sites
Delete a YouTube Account
How to
Delete a YouTube Account
Advertisement

About This Article

KD
Written by:
Katie Double
Tech Specialist
This article was written by Katie Double. Katie Double is a Technology Writer and Editor for wikiHow. She has over five years of experience in technical support, IT process analysis, and quantitative research. Katie loves exploring the application of various technological tools, from data analysis and visualization to music production and performance. Though originally from Denver, Colorado, she currently resides in New Zealand. She has a BA in Psychology from the University of Colorado Boulder. This article has been viewed 39,745 times.
How helpful is this?
Co-authors: 3
Updated: June 8, 2020
Views: 39,745
Categories: Google Applications
Article SummaryX

1. Open the Google Form on a browser.
2. Click Responses.
3. Click the 3 dots in the top right under "Responses".
4. Click Print all responses.
5. Set your print options and click Print.

Did this summary help you?
Advertisement