Google Sheets is a fantastic collaboration tool, but sometimes you need to share highly sensitive information—such as a company-wide salary directory, a proprietary client list, or a complex financial model—with people who should only be allowed to look at the data, not steal it.
By default, if you share a Google Sheet with someone and set their permissions to “Viewer,” they cannot edit the cells. However, they can still highlight all the data, press Ctrl+C, and paste it into their own spreadsheet. They can also go to File > Download and save a pristine Excel copy of your proprietary document directly to their personal hard drive.
To prevent data theft, Google Sheets includes an advanced, deeply hidden security setting that completely disables downloading, printing, and even basic copy-pasting for viewers and commenters.
Step 1: Open the Sharing Settings
You must be the Owner of the document (or have Editor privileges with sharing rights) to access this security feature.
- Open your Google Sheet.
- Click the large, blue Share button in the top right corner of the screen.
Step 2: Access Advanced Security Options
Most users only interact with the main sharing menu where you type in email addresses, completely ignoring the gear icon that controls global file security.
- In the top right corner of the “Share with people and groups” popup box, click the small Settings gear icon.
- This will open a new “Share settings” screen with two checkboxes.
Step 3: Disable the Download and Copy Hooks
We need to strip away the data extraction privileges.
- Look for the second checkbox labeled: “Viewers and commenters can see the option to download, print, and copy.”
- Uncheck this box.
- Click the back arrow to return to the main sharing menu, and click Done.
What the Restricted User Experiences
The security lockdown takes effect instantly for anyone who does not have “Editor” privileges.
- No Downloading: If a viewer clicks “File” in the top menu, the “Download,” “Make a copy,” and “Print” options will be completely grayed out and unclickable.
- No Copying: If the viewer highlights a block of cells and presses
Ctrl+C, absolutely nothing happens. The data is not copied to their clipboard. If they right-click the cells, the “Copy” option is missing entirely. - No Exporting: The user cannot even use Google Sheets’ internal export tools to push the data to a PDF.
Important Caveat: The “Screenshot” Loophole
It is crucial to understand that while this feature comprehensively blocks all programmatic and software-based data extraction, it cannot defeat the “analog hole.”
A restricted user can still physically take a screenshot of your data using their computer’s Snipping Tool, or literally pull out their iPhone and take a photograph of their monitor. For massive datasets containing thousands of rows, screenshots are too tedious to be a viable theft vector, but for small, highly sensitive lists (like a dozen VIP client phone numbers), you must understand that if it can be displayed on a screen, it can technically be captured.