4 Ways to Share Google Form Responses With Others

Mehvish Mushtaq is a computer engineer by degree. Her love for Android and gadgets led her to develop the first Android app for Kashmir. Known as Dial Kashmir, she won the prestigious Nari Shakti award from the President of India. She has been writing about technology for 6+ years and her favorite categories include how-to guides, explainers, tips and tricks for Android, iOS/iPadOS, social media, and web apps. Learn about our Tech Review Board

Afam has been a content writer with Guiding Tech Media since August 2023. However, his experience in tech writing dates back to 2018, when he worked as a freelance writer for Make Tech Easier. Over the years, he has grown a reputation for publishing quality guides, reviews, tips, and explainer articles. His work is featured on top websites, including Technical Ustad, Windows Report, and Next of Windows. He has training as a Microsoft Certified Professional and has covered more Microsoft-related guides on these platforms. Learn about our Tech Review Board

• When you share the linked response sheet for a Google Form, people will have real-time access to responses as they populate.
• You can share responses as PDFs, but those you share with cannot edit the file.

Method 1: By Linking Google Forms to Google Sheets and Sharing It

If you want others to check answers on your Google Forms, you may have to link it to Google Sheets and share that Sheet. Follow the steps below.

Step 1: In your Google Form, click on the Responses tab.

Step 2: Click the Link to Sheets option with the Google Sheets icon at the top-right corner.

Note: If you have already linked a sheet, you will see the View in Sheets button. Click on that and go to Step 4.

Step 3: A pop-up will appear. Select Create a new spreadsheet to store responses in a new spreadsheet and click on Create.

Step 4: The linked Google Sheet containing your form responses will open. Click on the Share button at the top.

Step 5: Enter the email ID with whom you want to share the Google Form responses and hit Send.

Note: By default, users will have the edit permissions for the sheets. That means they can edit the responses. But you can change that by clicking on the Editor box > choosing Viewer (can only view) or Commentor (can comment). You can change these permissions later, too.

The benefit of using this method is that the new responses will show automatically in the linked spreadsheet. And the user also won’t have editing permission for your actual form.

Tip: Learn how to edit Google Forms like a pro

Method 2: By Adding a Collaborator

Another easy way to share your Google Form responses with someone else is by adding them as a collaborator on your form. However, note that they can see the responses as you do and edit your form. If you are okay with that, follow these steps:

Step 1: Open your Google Form on a computer.

Step 2: Click the three-dot icon at the top > select Add Collaborators from the menu.

Step 3: Enter the user’s email address in the Add people and groups text box and click Done.

The recipient will receive an email giving them access to view Google Form responses.

This method’s advantage is that the recipient can view a summary of responses like the original creator. However, the drawback is that the recipient can also edit the form.

Method 3: By Sharing CSV File

Another way to share Google Form responses with someone else is by sending them a CSV file containing the responses to your form. Google Forms offers a native feature to create an offline CSV file of responses, as shown below:

Step 1: Open your Google Form and go to the Responses tab.

Step 2: Click on the three-dot icon in the Responses panel.

Step 3: Select Download responses (.csv) from the menu.

Step 4: Select the location to download the CSV file. It might be downloaded in the ZIP format.

Step 5: Once downloaded, send the ZIP or the extracted CSV file to the recipient via email or any other sharing method.

This method works offline, and its best use case is when form responses have been closed. On the other hand, the drawback is that the responses will not be updated automatically. You must download and share the CSV file again if a new response arises.

Method 4: By Sharing as a PDF

You can also share Google Form responses with others in PDF format. First, you must create and download a PDF file of the responses. Then, you can send it to someone else. Here are step-by-step instructions to create and share a PDF file with Google Form responses:

Step 1: Go to your Google Form and click the Responses tab.

Step 2: Click the three-dot icon next to the Send button and select Print.

Step 3: The responses will open in a new tab. Use the Ctrl + P keyboard shortcut to open the Print preview window.

Step 4: Click the drop-down box next to Destination and select Save as PDF. Then, click the Save button to download the PDF.

Step 5: Email the PDF file with the responses or share it in instant messaging apps like WhatsApp, Slack, etc.

Like the above method, this method works offline. So, the responses will not update automatically.