How to Share Google Sheets With Someone Step by Step

To share a Google Sheet, open it in a web browser, select Share in the upper-right corner, enter the person’s email address, choose their access level, and select Send. You can also let people open the file with a link, but check who can use that link before you share it. You’ll need access to the spreadsheet and, for email sharing, the recipient’s email address.

What You’ll Need

A Google account with permission to share the spreadsheet. If you are not its owner, the owner may have limited your ability to change sharing settings.
The Google Sheet you want to share, open in a desktop or mobile web browser. The instructions below use the browser version of Google Sheets.
The email address of each person you want to invite, or a decision about whether link access is appropriate.
A moment to decide what recipients should be allowed to do: view, comment, or edit.

Step-by-Step

Open the spreadsheet. Go to sheets.google.com and sign in to the Google account that can access the file. Open the spreadsheet from the home screen, or find it in Google Drive and open it. Check the file name at the top so you do not accidentally share a similarly named sheet. If the file is in a shared drive or belongs to an organization, its administrator may control which people can be invited or whether external sharing is allowed.
Open the sharing dialog. Select the Share button near the upper-right corner of the spreadsheet. If a prompt asks you to name the file first, give it a clear name and continue. The dialog shows the people who already have access and provides a field for adding people, groups, or calendar events. Sharing applies to the spreadsheet file as a whole, not just the tab currently on screen.
Enter the recipient. In the field for adding people, groups, and calendar events, type the recipient’s email address. Select the matching suggestion if one appears, then add another address if you are inviting more than one person. Double-check spelling and the selected account, especially when someone has personal and work addresses. If you enter a Google Group address, the group’s members may receive access according to the permission you set, subject to your organization’s policies.
Choose the right role. Before sending, open the role menu beside the recipient and select Viewer, Commenter, or Editor. A Viewer can read the sheet but cannot change it. A Commenter can leave comments and suggestions where supported but cannot directly edit cell contents. An Editor can change the spreadsheet and may be able to share it with others, depending on the owner’s settings. Give people the least access they need; you can change permissions later.
Add a note and send the invitation. If the option to notify people is selected, Google sends an email with a link to the spreadsheet. You can include a short message explaining what the file contains, which tab or cells to review, or when you need feedback. If you turn off the notification option, the person may not receive an invitation email, so you will need to send them the link separately. Select Send to apply the invitation.
Choose link access if you need it. In the same sharing dialog, find General access. It is usually set to Restricted, meaning only people who have been granted access can open the file. Select the current setting to see the available choices. Depending on the account, you may be able to choose an option such as your organization or Anyone with the link. Pick the narrowest option that works. Link access is convenient for a class, team, or event, but anyone who gets a usable link may be able to open the sheet.
Set the link role and copy the link. If you change general access, choose whether link users are Viewers, Commenters, or Editors. Then select Copy link and share it through the channel you intend to use, such as email or a work chat. The link does not override the role: a person with a Viewer link cannot edit the sheet unless they receive a separate Editor permission. If the sharing dialog still says Restricted, copying the link alone does not grant access to new people.
Confirm the access you granted. Reopen Share and review the people listed under access, along with the general access setting. Check that each recipient has the intended role and that link access is not broader than you meant. If appropriate, ask the recipient to open the invitation and confirm they can see the file. For sensitive information, avoid sending a public or broadly accessible link and remove access when it is no longer needed.

On a phone or tablet, the Google Sheets app may show a person-shaped sharing icon or a Share option in its menu. The labels and layout can differ from the browser, but the same decisions apply: choose the recipient, role, and general access carefully. For the clearest view of every sharing setting, use Sheets in a web browser.

Common Mistakes

Assuming a copied link gives everyone access. If general access is Restricted, a person who was not invited may see a request-access screen. Either add that person by email or change general access to an allowed link option.

Giving Editor access when viewing is enough. Editors can change data, formulas, formatting, and sometimes sharing settings. For someone who only needs to read a report, choose Viewer. For feedback without direct changes, Commenter is often a better fit.

Sharing the wrong account or address. A recipient might have more than one Google account, or an email address may contain a typo. Check the address in the sharing dialog and ask the recipient which account they are signed into if access fails.

Thinking a hidden tab is private. Hiding a sheet tab, filtering rows, or protecting cells does not make that information confidential from people who can access the file. Share a separate file with only the information that person should see.

Forgetting that access can be inherited. A file inside a shared folder or shared drive may be accessible to people through the parent location. Review the file’s access list and the folder or drive permissions if someone appears to have access you did not grant directly.

Tips

Use descriptive file names and a short message so recipients understand what the spreadsheet is for and what you expect them to do.
Invite named people by email when the sheet contains private or work-related information. This makes it easier to identify and remove a specific person’s access later.
Use link sharing only when its convenience is worth the wider access. Before posting a link in a public forum or large group, consider whether anyone who sees it should be able to open the data.
Keep a clean original or make a copy before giving editing access to a large group. Editors can alter content, so agree on who is responsible for maintaining the source data.
Review permissions after a project, class, or event ends. In the sharing dialog, you can usually change a person’s role or remove their access using the controls beside their name.
Remember that Google Sheets and Microsoft Excel use different sharing systems. In Excel, sharing commonly relies on a file stored in OneDrive or SharePoint; the Google Sheets sharing dialog described here does not apply.

Troubleshooting

The recipient says they cannot open the sheet. Ask them to open the link while signed in to the Google account you invited. In Share, check that you entered the correct address and that the person is listed. If the recipient is using a different account, invite that address too, or have them switch accounts. If the file is Restricted, a link by itself will not grant access.

The sharing option is unavailable or an invitation is blocked. You may not be the owner, or the file may inherit restrictions from a shared folder, shared drive, school, or workplace. Ask the owner or your Google Workspace administrator to allow the specific person or change the policy if appropriate. You cannot bypass an organization’s sharing rules from the spreadsheet.

The person sees a request-access page. This usually means they are not signed into an account with permission, or the file is still Restricted. Check the recipient’s account and the General access setting. If the request is legitimate, the owner can review the request and grant the appropriate role rather than enabling broad link access.

The recipient can view but cannot edit. Look at the role beside their name in the sharing dialog. If it says Viewer or Commenter, change it to Editor only if editing is intended. A protected sheet or protected range may still prevent edits to particular cells even when the recipient is an Editor; the owner can review protected ranges from Data > Protect sheets and ranges.

The invitation email did not arrive. Confirm that the address is correct, check spam or junk folders, and verify that the person is looking in the invited account’s inbox. If the notification was turned off, send the copied link yourself. The link will work only if the recipient’s account has access or the general access setting allows it.

You shared too broadly by mistake. Open Share, change General access back to Restricted if appropriate, and remove people who should no longer have access. If someone may already have downloaded or copied information, changing permissions cannot retrieve those copies. For sensitive data, follow your organization’s incident-reporting process.

Frequently Asked Questions

Can I share a Google Sheet with someone who does not have a Gmail address?
Often, yes, if the address can be used with a Google Account and your sharing settings allow it. Some Google Workspace organizations also support visitor access for people without Google Accounts, but availability depends on the organization’s settings. If the person cannot sign in or open the invitation, ask the owner or administrator which access methods are permitted.

Can I share only one tab in a Google Sheet?
Standard sharing permissions apply to the entire spreadsheet file. Hiding a tab or protecting it is not a reliable way to keep its contents secret from other people who have access. To share only selected information, create a separate spreadsheet containing just the permitted data and share that file instead.

What is the difference between Viewer, Commenter, and Editor?
A Viewer can read the spreadsheet, a Commenter can add comments without directly editing cell contents, and an Editor can make changes. Choose based on what the person needs to do, and remember that protected ranges can restrict editing in specific parts of a file.

Can I stop sharing a sheet after I send the link?
Yes. Open Share and change General access to Restricted, or remove an individual from the access list. People who lose access should no longer be able to open the live file, but they may still have copies or information they downloaded earlier.

Will someone know if I share a sheet with them?
If email notifications are enabled, Google normally sends an invitation that identifies the file and links to it. If you turn notifications off, the person may not receive that email; you will need to tell them how to find the file or send the link yourself.

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.