Google Docs and Excel Sheets: How Password Protection Works

Google Docs and Google Sheets do not offer a password you can set to lock an individual file before it opens. To limit access, change the file’s Google Drive sharing permissions; to require a password to open a spreadsheet, download it as an Excel workbook and use Excel’s encryption feature.

What password protection means

The phrase password protect can describe different safeguards, and choosing the right one matters. A password to open a file is a gate in front of the document itself. In Excel, encryption with a password can prevent someone without the password from opening the workbook. By contrast, a password or restriction that only limits editing does not necessarily hide the contents.

Google’s controls are based primarily on account identity and sharing permissions. You decide which Google accounts can view, comment on, or edit a file. A person who is not granted access generally needs to sign in to an authorized account. That is different from giving anyone a file and asking them to type a shared password.

Need to restrict who can see a Google file? Set its Drive access to Restricted and grant access only to the intended accounts.
Need to limit editing within a spreadsheet? Protect a sheet or range, while remembering that this is not a confidentiality barrier.
Need an open password for an Excel file? Use Excel desktop to encrypt the workbook with a password.

How Google Drive access controls work

In Google Drive, select the file and choose Share. Under General access, choose Restricted if you do not want access granted through a broadly shared link. Then add the people or groups who need access and select an appropriate role, such as Viewer, Commenter, or Editor. The names and options can vary slightly with account type or an organization’s administrator settings.

Restricted access is usually the closest match to what people mean when they ask how to put a password on a Google Doc or Sheet. It avoids relying on a password that several people might forward or reuse: access is associated with the invited account, and the owner can change or revoke permission. If a link is set to anyone with the link, however, the link itself can be passed to other people. Use that setting only when its broader access is acceptable.

For sensitive work, check the sharing dialog rather than assuming a file is private because it is hard to find. Review who has access, remove people who no longer need it, and confirm that General access is not set more broadly than intended. In a work or school account, an administrator may also set policies that affect sharing or external access.

Protecting a sheet or range is not a file password

Google Sheets includes controls for limiting edits to particular sheets or cell ranges. In a browser, open the spreadsheet and choose Data > Protect sheets and ranges. Select a sheet or range, then set permissions for who can edit it. You can also use a warning instead of restricting editors, depending on the protection option you choose.

This feature is useful for preventing accidental changes to formulas, headers, or approved input cells. For example, a team could leave a monthly input range editable while restricting edits to cells containing calculated totals. But sheet and range protection does not encrypt the spreadsheet or hide its data from someone who can view the file. It is an editing control, not a way to keep confidential values secret from other viewers or editors.

Use Drive sharing to control who can see the file, and use sheet or range protection to help control who can change parts of it. Those safeguards solve different problems. If the file contains information that a collaborator should not be able to see at all, do not put that information in a file shared with that collaborator.

How to password-encrypt an Excel workbook

If you need a password before a spreadsheet can be opened, use the desktop version of Excel for Microsoft 365 on Windows. Open the workbook, then choose File > Info > Protect Workbook > Encrypt with Password. Enter a strong password, confirm it when prompted, and save the workbook. Close it and reopen it to check that Excel asks for the password.

This is different from choosing a general Protect Workbook option that may protect the workbook’s structure. Read the menu item carefully and select Encrypt with Password when your goal is to require a password to open the file. Excel passwords are case-sensitive. Keep the password somewhere secure and accessible to the people who are supposed to open the workbook.

On Excel for Mac, the route differs: open the workbook and choose File > Passwords, then set a password in the Password to open field and confirm it. Labels and available options can vary by Excel version. Excel for the web is not the right place to set or change an open password; use the desktop app for file encryption. Web support for other workbook protection features is also not the same as encrypting a file against opening.

To remove an open password in desktop Excel, open the workbook with its current password and return to the encryption setting. Clear the password, confirm the change if prompted, and save the file. Test the saved copy before distributing it. If you have forgotten the password, Microsoft does not provide a way to recover the contents simply by verifying that you own the workbook, so a backup or password manager may be essential.

Moving a Google Sheet into Excel

A Google Sheet can be downloaded in Excel format, but conversion does not make it password-protected automatically. In Google Sheets, choose File > Download > Microsoft Excel (.xlsx). Open the downloaded workbook in desktop Excel, apply Encrypt with Password, and save it. The result is an Excel file that requires its password to open.

Check the converted workbook before relying on it. Formatting, formulas, charts, or other features may not transfer exactly between products, especially if the spreadsheet uses features specific to one of them. Confirm that the important cells and calculations look right, and keep an unencrypted backup in an appropriately secure location if you need one for recovery.

An encrypted Excel file is not a way to keep working collaboratively in Google Sheets while also requiring a password for every viewer. If you upload the encrypted workbook to Drive, people will still need permission to access the Drive file, and they will also need the Excel password to open the workbook. Google Sheets may not be able to open an encrypted workbook directly; remove the open password in Excel before converting or editing it as a Google Sheet.

Choosing the right option

Choose the safeguard that matches the actual risk, rather than treating every kind of protection as interchangeable. For ordinary collaboration, Google Drive sharing is often more convenient because access can be tied to named accounts and revoked. For a spreadsheet that must be sent as a file and should not open without a password, Excel’s encryption is the relevant feature.

Collaborating in Google Docs or Sheets: use Restricted sharing and grant each collaborator the least access they need.
Protecting formulas from accidental edits: use protected sheets or ranges in Sheets, or sheet protection in Excel, while understanding that these controls are not file encryption.
Sending a file that should require a password to open: encrypt the Excel workbook in desktop Excel and share the password through a separate, suitable channel.
Keeping information from a particular viewer: remove that person’s access or create a separate file that does not contain the information.

Sending a password in the same email as an attachment weakens the practical value of using a password. If the email account or message is exposed, both the file and its password may be exposed together. For a sensitive handoff, use a separate channel for the password and confirm that the recipient is the intended person.

Common problems and safety limits

A frequent source of confusion is the word protection in an app menu. Protecting a sheet, restricting edits, hiding a tab, or limiting access to a range does not necessarily encrypt the workbook. Those features can deter accidental changes, but they should not be used to store secrets where an authorized viewer must not see them.

Another common issue is losing an Excel open password. There is no standard password-reset link for a locally encrypted workbook. If nobody can supply the password, the practical solution may be to find an earlier unprotected copy or a backup. Before applying encryption, make a separate backup and verify that the password is recorded securely. Do not rely on memory alone for a file that must remain available.

Also consider whether the people who need the spreadsheet can use the chosen format. An Excel password-protected workbook may be less convenient for browser-based collaboration, and recipients need compatible software and the password. Google Drive permissions can be simpler for a group that already works in Google Workspace, but they do not turn a file into a password-encrypted attachment.

Frequently Asked Questions

Can I put a password on a Google Doc or Google Sheet?
No. Google Docs and Sheets do not provide an individual-file password-to-open setting. Use Google Drive sharing permissions to restrict access to selected accounts. If you need a password before opening a spreadsheet file, download it as an Excel workbook and encrypt it in desktop Excel.

Does Protect sheets and ranges hide data in Google Sheets?
No. It limits editing of selected cells or sheets; it is not a privacy or encryption feature. People who can view the spreadsheet may still be able to see its contents. Remove sensitive information or do not share the file with people who should not see it.

Can I password-protect an Excel file in Excel for the web?
Use Excel desktop to set or change a password required to open a workbook. Excel for the web has some workbook and sheet protection capabilities, but those are not a substitute for setting an open password with desktop Excel.

Is an Excel sheet password the same as an open password?
No. Sheet protection is intended to limit changes to a worksheet, while Encrypt with Password requires a password to open the workbook. If confidentiality is the goal, use the open-password encryption feature, not sheet protection alone.

What if I forget the Excel password?
There is no ordinary password reset that unlocks an encrypted workbook. Check a password manager, secure records, or an unprotected backup. Store future passwords safely and confirm that you can reopen the file before relying on it.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.