back arrowAll articles

How to Share Google Forms Responses (6 Steps)

Last Updated: Fri Aug 16 2024

In 6 simple steps, this guide will show you how to share Google Forms responses.

We'll cover methods using Google Sheets to ensure you share your responses efficiently.

So let’s dive in and share your Google Forms responses!

Steps:

  • Open Your Google Form
  • Go to the Responses Tab
  • Click the Google Sheets Icon
  • Select Destination for Responses
  • Share the Google Sheets
  • Send the Invitation

Step 1: Open Your Google Form

To begin, open your Google Form. Navigate to Google Forms and select the form whose responses you want to share.

red rectangle highlights the existing form in google forms

Step 2: Click on The Responses Tab Located at The Top

Once your form is open, click on the Responses tab located at the top of the page next to the Questions and Settings tabs.

Here, you can view all the submissions to your form.

red arrow pointing to ‘Responses’ tab

Step 3: Click on the Google Sheets Icon

In the Responses tab, click on the green Google Sheets icon in the top right.

red arrow pointing to google sheet link icon

This will open a window where you can select where your responses will be stored.

pop up window to choose the destination for responses

Step 4: Select Destination for Responses

You have two options:

Create a new spreadsheet: Select this option to create a new Google Sheets document for your responses. Name the spreadsheet and click Create.

Select existing spreadsheet: Choose this option if you want to store responses in an already existing spreadsheet. Select the spreadsheet and a new tab will be added to it.

After confirming your option click on ‘Create’.

red arrow pointing to ‘Create’

A google sheet will open in a new window.

google form responses in google sheet

Step 5: Click on the Top Right Share Button to Share the Google Sheet

Once your responses are added to a spreadsheet, you can share it with others. Click on the Share button on the top-right corner of Google Sheets.

red arrow pointing to ‘Share’ button

Step 6: Add People With Whom You Want to Share and Click ‘Send’

If you want to share with a specific person, add their email and click the send button. In this case, make sure that "Notify people" is checked.

red arrow pointing to ‘Send’ button

If you want to share with numerous people whose emails you don't have, in that case, turn on the "Anyone with the link" option.

Then, set the mode to view/comment/edit, depending on how you want to share the file.

Copy the link and share wherever you want. Anyone with the link will be able to access your sheet.

red arrow pointing to “Copy link”

By following this guide, you can ensure that your Google Forms responses are easily accessible to your intended audience without compromising your data’s integrity.

Back

Finished!

Vector