Board view
Viewer link emailed to directors who lack Google Workspace accounts on your domain.
What does "Anyone with the link" mean in Google Sheets?
Anyone with the link is a sharing option in Google Drive that lets whoever has the URL open the spreadsheet without you adding their email. You still pick a role: viewer, commenter, or editor. It is fast for teams but risky for master templates if you choose editor by mistake.
When to use it
Use it for internal prototypes, view-only dashboards, or public read copies when your org allows link sharing.
When to skip it
Avoid editor + anyone with the link on master templates, PII-heavy workbooks, or files with script secrets.
How it works
-
1
Click Share in the sheet.
-
2
Change General access to Anyone with the link.
-
3
Pick viewer unless editors truly need the whole file.
-
4
Audit link quarterly and rotate if leaked.
-
5
Prefer named users for client confidential data.
-
6
Combine with protected ranges if some editors should not touch formulas.
Examples in Google Sheets
Leaked template
Editor link posted to Reddit; seller rotates file ID and switches to copy-only delivery.
Build this without starting from a blank cell
Use a Better Sheets tool for Anyone with the link, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Editor link on master seller file.
- Assuming link sharing equals password protection.
- Forgotten public links after employee offboarding.
Frequently asked questions
- Anyone with link vs specific people?
- Named people need Google accounts on the ACL. Link sharing skips naming if policy allows.
- Search engines?
- Sheets are generally not indexed like public HTML, but treat editor links as secrets anyway.
- Revoke?
- Change sharing back to restricted or duplicate file to new ID.
Related Tutorials
Watch how Anyone with the link works
How do I prevent people from sharing my spreadsheets by making a copy?
LinkTree in a Google Sheet
How Do I Make a CSV File? And give a link to someone instead of the csv.
Ali Abdaal's Google Sheet | Year at a Glance
Announcing OnlySheets 2.0
Protect Your Spreadsheet IP
Related blog posts
Guides that explain Anyone with the link in more depth.
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →/Copy URL Trick
Discover a faster way to share Google Sheets using the /Copy URL Trick. Automate url editing, save time and promote effortless collaboration.
Read post →When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa
Esa is a beginner at Google Sheets. I discover the moment he discovered the deepest secrets of Google Sheets. And we wax poetic about AI in sheets, and data flow.
Read post →Related glossary terms
sharing Google Sheets
Sharing controls who can open a spreadsheet and what they can do inside it. The Share button invites people by email or link with roles like viewer, commenter, or editor. This is different from publishing a read-only web feed or locking cells with protection rules.
Read guide →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 →make a copy link
A make a copy link is a URL pattern that prompts viewers to duplicate your spreadsheet into their Google Drive instead of editing your original. Template sellers use it so each buyer owns a separate file while the master stays protected.
Read guide →revoke sheet access
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.
Read guide →Done reading about Anyone with the link?
Membership unlocks 636+ 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.