Google Sheets doesn’t let you put a password on a spreadsheet. There’s no “encrypt with password” option like in Excel. Instead, a Google Sheet is protected by your Google Account and its sharing settings: if the file is set to Restricted and not shared, only you can open it. To stop people who do have access from changing certain data, use Data > Protect sheets and ranges. If you truly need a password, download the file as an Excel workbook and password-protect it in Microsoft Excel.
Here’s how each option works and which one to use.
Your options at a glance
| Goal | Best option | Password? |
|---|---|---|
| Keep the whole sheet private | Set General access to Restricted and remove people you don’t want | No, uses your Google sign-in |
| Let people view but not edit | Share as Viewer or Commenter | No |
| Lock certain cells, columns, or tabs | Protect sheets and ranges | No |
| Hide a tab from collaborators | Not possible securely. Move private data to a separate file. | No |
| Require a password to open | Download as .xlsx and encrypt it in Excel | Yes, but it’s no longer a Google Sheet |
| Keep your whole account safe | Turn on 2-Step Verification | Adds a second check to your Google password |
Option 1: Make the spreadsheet private
- Open the sheet and click Share in the top-right corner.
- Under General access, choose Restricted. Anyone with the link will no longer be able to open it.
- Under People with access, click the role next to anyone you want to remove and choose Remove access.
- Click Save or Done.
Want to go further? Click the Settings gear in the Share box and uncheck Editors can change permissions and share and Viewers and commenters can see the option to download, print, and copy.
Option 2: Protect sheets and ranges
This stops people with edit access from changing specific cells or tabs. It doesn’t hide the data.
- Select the cells you want to lock, or right-click a tab at the bottom.
- Click Data > Protect sheets and ranges. From a tab, choose Protect sheet.
- Click Add a sheet or range, then type a description.
- Choose the Range tab to lock cells, or the Sheet tab to lock a whole tab. You can check Except certain cells to leave some editable.
- Click Set permissions.
- Choose Restrict who can edit this range and pick Only you or Custom. Or choose Show a warning when editing this range for a softer reminder.
- Click Done.
The file owner can always edit protected ranges. For more detail, see how to lock cells in Google Sheets.
Option 3: Password-protect a copy in Excel
- In Google Sheets, click File > Download > Microsoft Excel (.xlsx).
- Open the file in Excel on Windows or Mac.
- On Windows, click File > Info > Protect Workbook > Encrypt with Password. On a Mac, click Review > Protect Workbook or File > Passwords.
- Enter a strong password, confirm it, and save.
Keep in mind that if you upload the protected file back to Google Drive, you can’t open or edit it in Google Sheets until the password is removed. Store the password somewhere safe, because Microsoft can’t recover it for you.
Another option is to put the downloaded file in a password-protected ZIP using a tool like 7-Zip. Choose AES-256 encryption for real protection.
Option 4: Client-side encryption (Google Workspace only)
Some Google Workspace editions, such as Enterprise Plus and certain Education plans, let admins turn on client-side encryption. Encrypted Sheets are unreadable to Google and to anyone without access to your organization’s encryption keys. This isn’t available on free personal accounts, and some features are limited in encrypted files. Ask your admin whether it’s set up.
Protect the Google Account itself
Because your Google password is what really protects your sheets, make it strong and turn on 2-Step Verification at myaccount.google.com > Security. Also review Your devices there and sign out of any you don’t recognize.
Frequently asked questions
Are there add-ons that password-protect Google Sheets?
Some add-ons and scripts claim to, but they usually just hide or scramble data inside a file that’s still shared normally. Anyone with edit access can often get around them. Be careful about giving add-ons access to your data.
Can I hide a tab so others can’t see it?
You can hide a tab with right-click > Hide sheet, but anyone with access can unhide it. Viewers can also see its data in some cases, like through formulas or a download. Keep sensitive data in a separate file.
Can people see who opened my sheet?
On Workspace and some personal accounts, the owner can see views in Tools > Activity dashboard, depending on settings.
Is a private Google Sheet secure?
Google encrypts files in transit and at rest. The weakest point is usually account access, so a strong password and 2-Step Verification matter most.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.