To share a Google Sheet, open it and select Share. Add specific people for named access, or change General access to Anyone with the link to share a link. To stop sharing, remove a person’s access or change general access back to Restricted.
Share a Google Sheet with specific people
- Open the spreadsheet and select Share. You must own the file or have permission to edit it.
- Enter the email addresses of the people you want to invite, or add a Google group.
- Choose a role: Viewer can view, Commenter can comment, and Editor can make changes.
- Select the option to send the invitation.
On My Drive files, editors may also be able to share the file unless the owner or applicable settings restrict that ability. Available controls can vary by account and organization policy. Google’s Drive sharing guidance explains roles and sharing controls.
![Google Workspace Guide: Unlock Every Google App – Elevate Efficiency with Exclusive Tips, Time-Savers & Step-by-Step Screenshots for Quick Mastery [II EDITION]](https://m.media-amazon.com/images/I/41CX0AjJhAL._SL160_.jpg)
As an Amazon Associate I earn from qualifying purchases.
Get and share a link to a Google Sheet
- Open the file and select Share.
- Under General access, choose the audience. Restricted means only people who already have access can open the file. Anyone with the link allows people with the direct link to open it.
- Set the role recipients should have, such as Viewer, Commenter, or Editor.
- Select Copy link, then paste the link into a message or wherever you want to share it.
Having the link does not automatically grant editing rights: people receive the role configured for the file. Work or school administrators can limit broad sharing, so the option you want may not be available. For private or sensitive spreadsheets, use named access and the least-permissive role that meets the need. See Google’s explanation of general access and sharing permissions.
Recommended Free Tools
Unshare a Google Sheet or disable link access
Remove one person
- Open Share and find the person in the access list.
- Choose Remove access and save the change if prompted.
Turn off access for anyone with the link
- Open Share and find General access.
- Change the setting to Restricted and confirm or save the change if prompted.
These controls address different access routes. When securing a file, check both the named people list and General access. Google says new Docs, Sheets, and Slides files are Restricted by default. Google Workspace Learning Center instructions cover removing a collaborator and restricting access.
#1 Best Overall
- hole punched
- high quality card stock
- 4 pages
- made in USA
- keyboard shortcuts
What link sharing does—and does not—mean
Anyone with the link is not the same as making a file publicly searchable. Google says search engines do not crawl or index a document shared this way unless its link is published on a publicly searchable webpage. Anyone who obtains the direct link can still use the spreadsheet according to its assigned role, so share the link only with the intended audience. Read Google’s privacy guidance for Docs, Sheets, Slides, and Vids.
Quick Recap
Rank #4
![The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite](https://m.media-amazon.com/images/I/41AWmhmGFuL._SL160_.jpg)
- The Google Workspace Bible: [14 in 1] The Ultimate All in One Guide from Beginner to Advanced Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite
- ABIS BOOK
Rank #2
- Mastering Google Sheets: A Step by Step Handbook for Beginners to Simplify Data Analysis, Boost Productivity, and Unlock Your Full Spreadsheet Potential
- ABIS BOOK
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
