How to Share Google Forms Responses with Others

Updated 9 November 2026 · Standard formula, shown below

Sharing Google Forms responses lets collaborators review submissions, or lets you send respondents a summary of results. Before you begin, decide whether people need access to the live response data or only a copy of results, and check that the information is appropriate to share.

What You’ll Need

Access to the Google account that owns or can edit the form.
The email addresses of anyone who needs access, or a destination such as a Google Sheets spreadsheet.
A clear choice about whether recipients should see individual responses, an aggregated summary, or an exported copy.

Step-by-Step

Open the form and review its responses. Go to Google Forms and open the form. Select the Responses tab. You can review the summary charts, individual submissions, and response count here. If the form is still collecting submissions, check that before sharing; you can stop accepting responses using the response-collection control on the Responses tab.
Choose the right kind of access. For ongoing access to submitted data, share the form or its linked spreadsheet with specific collaborators. For a quick overview, share the response summary if that option is available. If recipients only need a snapshot, export or copy the data and share that file instead. These methods differ: a live link can show later submissions, while an exported file will not update automatically.
Link responses to Google Sheets if needed. In the Responses tab, select the green Sheets icon to create a spreadsheet or choose an existing one, if offered. Confirm the destination. The spreadsheet provides a row-based view of submissions and is useful for sorting, filtering, and analysis. Keep in mind that people with spreadsheet access may be able to see individual answers, not just charts.
Share the spreadsheet with named people. Open the linked spreadsheet and select Share. Enter each recipient’s email address, then choose an appropriate role: Viewer for read-only access, Commenter for comments, or Editor only when they need to change the spreadsheet. Check the recipient list and send the invitation. For sensitive responses, avoid broad link access and share only with people who need it.
Give someone access to edit the form. If a person needs to manage the form or view responses through its owner interface, open the form and use the form’s sharing or collaborator controls. Add their email address and grant the access level shown. Google Forms’ layout and labels can vary; make sure you are adding them as a form collaborator, rather than merely sharing the form’s respondent link. A collaborator may be able to edit questions and settings as well as view responses.
Share a response summary when appropriate. In the Responses tab, look for the option to share a summary of results. If available, enable it and copy the displayed link, then send it to the intended audience. The summary is a view of response results, not a private per-person invitation. Anyone who can use that link may be able to see the summary, so do not use it for confidential or identifying data. Turn the option off if you no longer want the summary link to work.
Share results with respondents after submission, if that is your goal. Open the form’s settings and review the response receipt or respondent-access options. Available choices depend on the form and account settings. A response receipt generally helps a respondent keep a copy of their own submission; it is not the same as granting access to everyone else’s answers. If you want respondents to see an overall summary, use the summary-sharing option instead and consider whether all responses are suitable for them to view.
Check access from the recipient’s perspective. Ask a recipient to open the invitation or link while signed in to the intended account. Confirm they can see only what you meant to share, and that they can open the file without requesting extra access. If the information should not remain available, remove the recipient or disable the link when it is no longer needed.

Common Mistakes

Sending the responder link instead of a results link. The form’s public or respondent link is for submitting answers; it does not normally provide access to existing responses.
Sharing the whole form when only the spreadsheet is needed. Form collaborators can often change questions or settings. Share the response spreadsheet with Viewer access if recipients only need to read its contents.
Using “anyone with the link” without checking the data. A convenient link can expose results beyond the intended group. Prefer named recipients for personal or confidential information.
Assuming a summary hides every detail. Summary charts may reveal small groups or sensitive information, and the linked spreadsheet can reveal individual answers. Review both before sharing.
Forgetting that an exported copy is static. A downloaded spreadsheet or file will not include new submissions automatically. Share the live linked spreadsheet when updates are required.

Tips

Use the least access needed: Viewer rather than Editor when read-only access is enough.
Test a link in a private browsing window or with a separate account, but do not use that test to bypass an organization’s access restrictions.
Remove access when a project ends, and periodically review the Share dialog for unfamiliar or outdated recipients.
If sharing outside a school or workplace, your organization may restrict external sharing. Ask its administrator about approved options rather than copying sensitive data to an unapproved account.
For analysis, preserve the original response data and do calculations in a separate sheet or copy, so edits do not accidentally alter the source data.

Troubleshooting

A recipient sees “You need access.” Confirm the email address they are signed in with, then reopen the Share settings for the exact form or spreadsheet and add that account. If the account is outside your organization, an administrator may have blocked external access.

The recipient can open the form but cannot see responses. They may have the respondent link rather than collaborator access, spreadsheet access, or a response-summary link. Share the correct destination and verify the role assigned.

The Sheets icon is missing or the spreadsheet has no new rows. Check that you are on the form’s Responses tab and that responses have been submitted. Confirm that the form is linked to the spreadsheet you expect. A spreadsheet can be disconnected or replaced, so verify the destination before sending its link.

The summary-sharing option is unavailable. Options can vary with account type, form settings, or organizational controls. Use a restricted spreadsheet share or make a carefully reviewed copy of the summary instead. Do not turn on public access just to work around a policy restriction.

You shared with the wrong person. Open Share for the form or spreadsheet, remove that person or change their role, and turn off any link access that is no longer appropriate. If the recipient may already have downloaded or copied the information, removing access cannot retract those copies.

Frequently Asked Questions

Can I share Google Forms responses without sharing the form?
Yes. You can share the linked response spreadsheet or, where available, a response-summary link without giving someone the respondent link. Choose carefully because the spreadsheet may contain individual answers.

Can people see new responses after I share a spreadsheet?
Usually, a linked spreadsheet reflects ongoing form responses. Recipients need permission to open it, and a downloaded or separately copied file will not update automatically.

Can respondents see everyone else’s answers?
Not by default. Respondents generally see their own submission or receipt, if enabled. Sharing a response summary can expose aggregated results, so review the summary and its access settings first.

Can I share responses with someone who does not have a Google account?
It depends on the file’s sharing settings and any organization restrictions. If allowed, link access may work, but it can be less controlled. For private results, use named accounts and ask the recipient to use an approved account.

How do I stop sharing responses?
Open the form or spreadsheet’s Share settings, remove specific people, or restrict general link access. If you shared a response-summary link, disable summary sharing in the form’s Responses area when that option is available.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.