Google Sheets: How to Share With Others

To share a Google Sheet, open it in a web browser, click Share in the top-right corner, add people by email or change General access to create a link, choose Viewer, Commenter, or Editor, then send the invitation or copy the link. Check the access level before sharing: it determines whether recipients can only read the spreadsheet, leave comments, or change its contents.

How Google Sheets sharing works

Sharing grants access to a particular spreadsheet through a Google account, a Google Group, or—in some circumstances—a link. The owner and people with sufficient permission can decide who gets access and what those people can do. Access is not the same as sending someone a separate copy: collaborators generally work in the same live file, so changes can appear for others as they are made.

There are two common ways to invite people:

Share with specific people: Enter email addresses or a Google Group address. This is usually the better choice when you know who should have access and want to keep the file restricted.
Share by link: Change General access from Restricted to an available link-access option, then copy and send the link. Anyone who meets that setting’s conditions may be able to open the file.

A link is not automatically public. If General access says Restricted, only people who have been granted access can open it, even if someone forwards them the URL. Google Workspace administrators may also limit which sharing options are available.

Share a spreadsheet with specific people

For a controlled invitation in Sheets on the web, use these steps:

Open the spreadsheet and click Share.
In the sharing dialog, enter the email address of each person or group. Check that the suggested recipient is the intended person, especially when names are similar.
Use the role menu beside the recipient field to choose Viewer, Commenter, or Editor. If you are inviting several people, review each person’s access before sending.
Optionally add a message. Leave Notify people selected to send an email invitation; if you turn it off, the person may not receive the usual notification, so share the file link with them separately.
Click Send or the corresponding confirmation button in the dialog. The recipient can then open the spreadsheet using the account that was granted access.

If someone says the invitation is missing, ask them to check the inbox for the exact email address you shared with, along with spam or junk mail. Sharing to a work address does not necessarily grant access to a different personal Google account the person happens to be signed into.

Choose the right permission level

Google Sheets offers three everyday roles for collaborators. Give each person the least access they need; it is easy to raise someone’s permission later if their work requires it.

Viewer: Can open and read the spreadsheet but cannot edit its cells. Use this for people who only need to consult figures, schedules, or reports.
Commenter: Can read the file and add comments, but cannot directly change cell contents. This works well for review—for example, asking a manager to comment on a draft budget without letting them change the numbers.
Editor: Can make changes to the spreadsheet, such as entering data, editing formulas, or changing formatting. Editors may also have permission to share the file, depending on the sharing settings.

These roles apply to the file, not just one tab or a selected range. If a colleague should edit one section but not another, consider whether protected sheets or ranges can prevent accidental changes. Protection is not a substitute for sharing restrictions: it does not make other parts of the spreadsheet private from someone who can already view the file.

Share a link and control who can use it

To create a link, click Share and look under General access. Choose an option offered in the dialog. For a restricted file, change Restricted to an available link setting, such as Anyone with the link, then select the role and copy the link. Send it through the channel your recipients use. If you do not see an open link option, your account or organization may not allow it.

Anyone-with-the-link access is convenient for a class handout or a status sheet shared with a large team, but a forwarded link can reach people beyond the original recipients. Choose Viewer when people only need to read it. Use Editor only if link recipients should be able to make changes; otherwise, unexpected edits may affect everyone using the same spreadsheet. For a small or sensitive group, invite named accounts instead.

To stop link access, return to Share, change General access back to Restricted, and save the change if prompted. To remove a named person, use the sharing dialog to change their role or remove their access. Removing access does not recall copies, screenshots, or information a person already viewed.

Collaborate without losing track of changes

When people have access to the same sheet, they can work in the shared file rather than emailing different versions back and forth. Editors can enter data or update formulas, while commenters can make suggestions without directly changing cells. Comments are useful for questions that need a decision; a cell note is more appropriate for a brief explanation attached to a value. Google Sheets also shows collaborators and their activity in the file, though what is visible can depend on the account and context.

For example, a team collecting event registrations could give organizers Editor access, let a reviewer use Commenter access to flag incomplete entries, and give other staff Viewer access to check the final schedule. If multiple editors work in the sheet, agree on who maintains formulas, column headings, and data validation. Sharing permission does not prevent someone with Editor access from making a mistake, so consider keeping a clean backup or using version history to review earlier changes.

Sharing a file stored in a shared folder

A spreadsheet in Google Drive may get access from its containing folder as well as from direct invitations to the file. This means a person can sometimes open a sheet because they already have permission to its parent folder. Conversely, folder-level rules or organization policies can affect what you are able to share. If you cannot remove someone’s access from the sheet, check whether their permission comes from the folder or a group.

When sharing a folder, remember that the permission can apply to other files inside it, not just the one spreadsheet you have in mind. For a one-off collaboration, sharing the individual file may be more appropriate. For a team that needs ongoing access to a set of documents, a shared folder or a Google Group can make administration easier, but confirm which people and files are included before granting access.

Privacy and security considerations

Before sharing, check whether the sheet contains personal details, customer information, internal figures, or hidden tabs that are not intended for every recipient. Hidden rows, columns, and sheets should not be treated as confidential: a person with sufficient access may be able to reveal them, and people with view access can still see the data in the file. Remove information that recipients should not see, or create a separate spreadsheet containing only the material they need.

For a more controlled share, invite specific accounts, choose the narrowest role that works, and review access again when a project ends. In the Share dialog, available settings may let owners restrict whether editors can change permissions or share the file, and whether viewers or commenters can download, print, or copy it. These controls vary by account and administrator policy; they cannot prevent someone from taking a screenshot or manually recording information they can see.

Google Sheets also has Data > Protect sheets and ranges, which can limit editing of selected cells or tabs. Use it to reduce accidental edits, not to conceal data or replace careful access management. For workplace or school accounts, ask an administrator if a sharing choice is missing or blocked rather than trying to work around the organization’s rules.

Common sharing problems and fixes

The recipient sees an access request: Check that you shared with the account they are currently using. If the file is restricted, forwarding its link alone will not grant access; approve the request or add the correct email address.
The link does not work for other people: Reopen Share and inspect General access. It may still be Restricted, or your organization may limit link sharing. Confirm that you copied the link for the correct spreadsheet.
A person can view but not edit: Their role may be Viewer or Commenter. Change it to Editor only if editing is intended, and check whether an administrator or protected range prevents the specific change.
You cannot share outside your organization: A work or school administrator may restrict external recipients or public links. Contact the administrator or use an approved method for the intended audience.
Someone still has access after you remove a direct invitation: They may have access through a shared folder, group, or another account. Review the file’s access details and the relevant folder or group permissions.

Sharing versus publishing or making a copy

Sharing a spreadsheet is different from publishing it to the web. Sharing gives selected people or link recipients a role on the file. Publishing is a separate way to make spreadsheet content available for viewing on a web page or through a published link; it is not the right choice when you want collaborators to edit the original file. Review the publishing options carefully because their audience and exposure can differ from restricted sharing.

Sharing is also different from making a copy. If recipients need an independent version they can change without affecting your original, they can make or receive a copy where their access and account settings permit it. A copy will not automatically stay synchronized with the original. In Microsoft Excel, collaboration is commonly managed through a workbook stored in OneDrive or SharePoint, and its sharing controls and interface differ from Google Sheets; a Sheets link and an Excel sharing invitation are not interchangeable.

Frequently Asked Questions

Can I share a Google Sheet with someone who does not have a Google account?
It depends on the sharing setup. An available Anyone with the link setting may let a recipient open a file without a Google sign-in, but organization policies can block that option. Some eligible Google Workspace accounts support visitor sharing for external people, with identity verification requirements. If you need to invite a named person, check the options available in your account rather than assuming every non-Google address will work.

Can I share only one tab in a Google Sheet?
Ordinary file sharing grants access to the spreadsheet, not just one tab. Hiding or protecting other tabs does not make their contents private from a collaborator who can access the file. If someone should see only a specific section, create a separate spreadsheet with only the information they are permitted to view.

How do I change someone from Viewer to Editor?
Click Share, find the person in the access list, open the role menu beside their name, and choose Editor. If the option is unavailable, the file’s owner, a folder permission, or an organization policy may control the access.

Can I stop an Editor from sharing the sheet?
Sometimes. In the Share dialog, open the settings controls and look for the option governing whether editors can change permissions or share. The setting may not be available to every account, and administrators can enforce their own rules. If it is available, turn it off when you want to limit further sharing.

Will people be notified when I share a sheet?
When you invite named people, the Notify people option generally sends an email invitation. If you turn off notifications, share the link or otherwise tell them how to reach the file. Changing General access to allow a link does not necessarily send an invitation to each person who might receive that link.

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.