How do you revoke access to a Google Sheet?
Revoking access means removing a person or link from the share list so they can no longer open or edit the file. In Google Sheets you use the Share dialog to remove users, downgrade editors to viewers, or turn off anyone-with-the-link sharing. Revoke is essential when contractors finish, clients churn, or a link was posted publicly by mistake.
When to use it
Revoke when someone leaves the team, a project ends, or you discover a sensitive tab was shared too broadly. Pair revokes with a quick audit of linked forms, embedded charts, and copied files in other Drive folders.
When to skip it
Do not revoke the only owner without transferring ownership first. Also avoid mass revokes during an active deadline without warning collaborators who still need the file.
How it works
-
1
Open the spreadsheet and click Share in the top right to open the permissions panel.
-
2
Find the person or group to remove and click the dropdown next to their role, then choose Remove access.
-
3
If the risk is a leaked link, change General access from Anyone with the link to Restricted.
-
4
Review inherited access from shared Drive folders; folder permissions can re-grant access after a file revoke.
-
5
For service accounts or automation, confirm scripts still run under an account that retains editor access.
-
6
Document who was revoked and when on an internal log if compliance requires an access trail.
Examples in Google Sheets
Offboard a contractor
Remove their Google account from the share list and set the file to Restricted so old bookmarked links stop working.
Client project handoff
Transfer ownership to the client, then revoke your agency editors except one archive account if the contract allows.
Fix a public link mistake
Switch General access from Anyone on the web to Restricted, then re-share only with named emails on a need-to-know list.
Better Sheets resources
Common mistakes
-
Removing a user from the file but leaving them on the parent Shared drive with broad access.
-
Revoking the account that owns scheduled Apps Script triggers, which breaks automation silently.
-
Assuming revoke blocks screenshots or exports already downloaded; revoke stops future access only.
-
Forgetting embedded publish links still work until you unpublish or change publish settings separately.
-
Transferring ownership to a personal Gmail then losing company admin oversight of the asset.
Frequently asked questions
- Can removed users see version history?
- After revoke they cannot open the file. History remains for users who still have access.
- How do I revoke link sharing?
- In Share, set General access to Restricted. Only people explicitly added can open the file.
- Can editors revoke other editors?
- Only owners and some Workspace admins can remove other editors depending on admin policies.
- Does revoke affect copies?
- No. Someone who made a copy keeps their copy. Revoke only affects the original file permissions.
- How do I audit who has access?
- Open Share and scroll the list. Workspace admins can run Drive audit reports for broader files.
- Can I revoke access in bulk?
- Admin consoles and third-party tools help at scale. For one file, edit the Share list manually.
- What about comment-only users?
- Change their role or remove them like any other collaborator from the Share dialog.
- Should I duplicate before mass revoke?
- Yes if you need a snapshot for records. Copy the file to an archive folder before changing permissions.
Related Tutorials
Watch how revoke sheet access works
Announcing OnlySheets 2.0
Self Destructing Google Sheet
Can a Google Sheet have DRM?
Set Up OnlySheets with Gumroad
Check Your Google Sheets Add On Works
Uncheck Every Checkbox in Google Sheets
Related blog posts
Guides that explain revoke sheet access in more depth.
Related terms
protect sheets/ranges
Protection limits who can edit specific cells, ranges, or entire tabs while others keep view or comment access. It is how you let teammates update input columns without touching formula blocks, summary rows, or archived data. Protection is not encryption; owners and editors with rights can still adjust protections.
Read guide →publish Google Sheets
Publishing puts a read-only snapshot or live view of your sheet on the web at a public URL. File > Share > Publish to web lets you choose a tab and format (web page, CSV, TSV, PDF). Published links do not require Google login, which is powerful for embeds and data feeds but risky if you publish the wrong range.
Read guide →Google Sheets workflows
A workflow is the path work takes through your sheet: intake, review, approval, done. Good workflows use consistent columns, statuses everyone understands, and just enough automation to move tasks forward without hiding steps from the team.
Read guide →embed sheets
Embedding shows a spreadsheet, chart, or range inside a website, Notion page, or Google Site without sending visitors to the full Sheets UI. You usually publish to web or use an iframe with a link Google generates, combined with sharing permissions that match your audience.
Read guide →naming conventions
Naming conventions are agreed rules for files, tabs, columns, and named ranges so anyone can guess where data lives. Good names reduce VLOOKUP errors, make IMPORTRANGE links obvious, and stop duplicate Dashboard (2) tabs from spreading across your Drive.
Read guide →Done reading about revoke sheet access?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.