How to Share a Google Sheets Document Safely

To share a Google Sheets document, open it in a web browser, select Share in the top-right corner, and either invite specific people by email or change general access to allow anyone with the link. Choose whether recipients can view, comment, or edit before you send or copy the link. You’ll need access to the spreadsheet and, for private sharing, the recipients’ email addresses.

What You’ll Need

A Google Sheets spreadsheet stored in Google Drive. Sheets saves changes to Drive automatically while you work online.
A Google account with permission to share the file. If it belongs to a workplace or school, the organization may limit who can access it or whether links can be shared outside the organization.
For direct invitations, the email addresses of the people or Google Groups you want to share with. For link sharing, a way to send the copied link through email, chat, or another channel.
A decision about the access each person needs: Viewer, Commenter, or Editor. Giving someone the least access needed helps reduce accidental changes or unwanted disclosure.

Step-by-Step

Open the spreadsheet in Google Sheets. In a desktop browser, go to Google Sheets or Google Drive and open the document you want to share. Check the file name at the top of the page so you do not invite people to the wrong spreadsheet. If you cannot open the file, ask its owner for access first; you cannot grant other people access that you do not have permission to grant.
Open the sharing controls. Click the Share button near the top-right corner. A dialog appears with a field for adding people, groups, and calendar events, plus a section called General access. If you do not see the button, your browser window may be narrow; widen it or look for the sharing control in the toolbar. If the owner or organization restricts sharing, some controls may be unavailable.
Invite specific people for controlled access. In the field for adding people or groups, enter an email address or a Google Group name. Select the matching suggestion if one appears, and repeat for other recipients. Adding named people is usually the safer choice for a document with personal, financial, work, or otherwise sensitive information because access is tied to the invited accounts rather than to a link that can be forwarded.
Choose each recipient’s role. Use the role menu beside the invited person or group to select Viewer, Commenter, or Editor. Viewers can read the spreadsheet but cannot change its contents. Commenters can read and leave comments or suggestions without editing cell values directly. Editors can change spreadsheet content and may be able to share it with others, depending on the file’s sharing settings. If the recipient only needs to check figures, Viewer is generally enough; use Editor only when they need to make changes.
Review the notification options, then send the invitation. Google Sheets normally offers to notify people when you share with them. Leave the notification option on if you want them to receive an email with access information, and add a short message if useful—for example, explain which tab to review or when you need comments. If you turn off the notification, the person may have permission but will not receive that invitation email, so you will need to tell them another way. Select Send to finish. If Google asks you to confirm sharing outside your organization, check the recipient and follow your organization’s rules before continuing.
Or make a shareable link. In the same dialog, find General access, which commonly starts as Restricted. Select the access menu and choose Anyone with the link if that option is available. Then choose a role—Viewer, Commenter, or Editor—from the role menu. This setting means that people who obtain the link can access the file at the selected level; it does not limit access to the particular person you send it to. Use it only when that broader access is appropriate. If you do not see the option, your school or workplace administrator may have disabled it.
Copy and distribute the link carefully. Select Copy link, then select Done if the dialog remains open. Paste the link into the email, message, or team channel intended for the recipients. Before sending it, confirm that the link is for the correct spreadsheet and that its general-access role is no broader than necessary. A link sent to one person can be forwarded, so avoid placing a link with Editor access in a public post or a large group chat.
Check that the right people can open the file. Reopen Share and review the people listed and the General access setting. For a named invitation, ask the recipient to open the file using the account associated with the invited address. For link sharing, ask someone who should have access to try the link. If the file contains several tabs, remember that sharing applies to the spreadsheet file as a whole, not just the tab you currently have open.

Common Mistakes

Choosing Editor when Viewer would do. Editors can alter data, formulas, formatting, and sometimes the structure of a spreadsheet. A well-intentioned edit can overwrite a formula or remove a row. Give editing access only to people who genuinely need to make changes, and consider keeping a backup of important information.

Assuming Restricted means the recipient is already invited. Restricted access means only people who have been granted permission can open the file. If you leave the setting as Restricted but never add the recipient’s email, sending them the URL alone will not give them access. Conversely, choosing Anyone with the link changes who can access the file, not merely how the link is delivered.

Sharing a link without checking its role. A link with Editor access lets link holders change the spreadsheet. Before copying or reusing an old link, check both the general-access audience and the role in the Share dialog. If you are unsure, use Restricted and invite people individually.

Thinking a tab is private because it is hidden or protected. Sharing a Google Sheets file generally gives access to the file, including its tabs. Hiding a tab or protecting a sheet or range can help prevent accidental changes, but it is not a reliable way to keep its information confidential from people who can access the spreadsheet. Put information that should not be visible in a separate file and share that file only with the appropriate people.

Inviting the wrong email address or account. A person may have several accounts, such as a personal Gmail address and a work address. If they open the link while signed into an account that has not been granted access, they may see an access request screen. Check the address in the Share dialog and tell the recipient which account to use.

Tips

Use named invitations when you need to know exactly who can access a document. This is especially helpful for team budgets, class records, project plans, and files containing information that should not be passed along. Use link sharing for convenience only when the intended audience is broad enough for the selected access level. “Anyone with the link” does not mean the link is automatically published online, but anyone who receives or is forwarded the link may be able to use it.

Match permissions to the task. A manager who needs to review figures may need Commenter access, while a teammate who must update the figures needs Editor access. If people only need a final copy, consider sharing a separate version with Viewer access rather than leaving editing permissions open after the work is complete. Explain what you expect recipients to do so they do not have to guess whether they should edit cells or leave comments.

Review access again when a project ends or a team changes. In the Share dialog, find the person whose access should change, open the role menu, and choose a less permissive role or remove access if that option is available. For general link access, change Anyone with the link back to Restricted when the link is no longer needed. If access comes from a shared folder or a group, you may need to change permissions on that folder or group rather than only on the spreadsheet.

For collaboration, agree on a simple editing routine. For example, ask collaborators to use comments when they are proposing a change, reserve one tab for incoming data, or tell them not to overwrite cells containing formulas. Google Sheets can show edits and comments, but a clear process makes it less likely that people will change the wrong information. Google Sheets sharing is managed through Google Drive; Excel’s sharing workflow is different and commonly relies on a file stored in OneDrive or SharePoint, so the Google Sheets menu names above do not apply to Excel.

Troubleshooting

The recipient sees “You need access.” First check that the invitation was sent to the address they are using. Ask them to switch to that account in their browser, then reopen the link. If you intended to share with anyone using a link, open Share and check that General access is actually set to Anyone with the link, rather than Restricted. If that option is missing or the person still cannot get in, the file owner or a workplace or school administrator may have limited external sharing.

The invitation email did not arrive. Check for a spelling error in the address and ask the recipient to look in spam or junk mail. If you disabled the notification option, send the link or file details separately. Do not switch to broad link access just to avoid a missed email unless that is acceptable for the file. The recipient can also try opening the spreadsheet while signed into the account you invited.

You cannot change sharing settings. You may be a Viewer or Commenter rather than the owner, or the owner may have limited who can share the file. Ask the owner to update permissions or share it with the intended people. In an organization account, administrators can block external invitations or link access; use an approved account or request help from the organization’s administrator instead of trying to bypass the restriction.

The wrong person has access, or a link was shared too widely. Open the Share dialog and remove the person or change their role. If the spreadsheet is set to Anyone with the link, change General access to Restricted to stop general link access, then invite only the people who should retain access. Remember that someone may already have viewed, copied, or downloaded information while access was available, so changing permissions cannot undo that exposure.

A collaborator can open the file but cannot edit it. Check that their role is Editor, not Viewer or Commenter, and that they opened the correct account. Also check whether the relevant sheet or range is protected; protection can limit editing even when a person has Editor access to the file. Ask the owner or an authorized editor to review the protection settings if the collaborator needs to change those cells.

Frequently Asked Questions

Do people need a Google account to view a shared spreadsheet?
It depends on how the file is shared and on the owner’s account or organization settings. A named invitation may require the recipient to sign in with the invited account. If link access is allowed, some files can be opened by people who are not signed in, but an organization may require sign-in or block outside access. Check the settings and ask the recipient to follow the sign-in prompt.

Can I share just one tab in a Google Sheets document?
Not as a private-access boundary: the Share button grants access to the spreadsheet file, not only the tab currently displayed. Hiding a tab does not make its contents confidential from file collaborators. If someone should see only part of the information, create a separate spreadsheet containing only that information and share the separate file.

What is the difference between Viewer, Commenter, and Editor?
A Viewer can read the spreadsheet, a Commenter can add comments or suggestions, and an Editor can make changes to the spreadsheet. These roles apply to the file, though protected sheets or ranges can add editing restrictions. Choose the lowest role that lets the recipient complete their task.

Can I stop sharing a spreadsheet later?
Yes. Open Share, find a named person, and use the role menu to remove their access where available. To stop general link access, change Anyone with the link to Restricted. Permissions inherited from a shared folder or group may need to be changed at that level too.

Why is “Anyone with the link” unavailable?
The file may be owned by a work or school account whose administrator has disabled external or public-link sharing. You may also lack permission to change the file’s access settings. Ask the owner or administrator to approve an appropriate sharing method; do not move sensitive information to another account to evade an organization’s policy.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.