Which Excel protections can be removed — and which cannot
Excel has two very different kinds of password. This tool removes sheet protection and workbook-structure protection from .xlsx files in your browser. It cannot open a file that is encrypted with a password-to-open, and it tells you when that is the case.
The two kinds of Excel password
| Sheet / workbook protection | Password to open (encryption) | |
|---|---|---|
| What you see | The file opens, but cells or sheet tabs are locked | Excel asks for a password before showing anything |
| How it works | A flag and a short hash stored in the file's XML | The whole file is encrypted |
| Removable here | Yes | No — the data cannot be read without the password |
What the tool does
- Opens the .xlsx (which is a ZIP of XML files) in your browser.
- Lists which sheets are protected and whether the workbook structure is locked.
- Removes the sheetProtection, protectedRanges and workbookProtection entries, leaving data, formulas and formatting untouched.
- Gives you an unlocked copy to download; the original file is unchanged.
Legitimate use
Use it on your own files or files you are authorised to edit — for example a template whose author left the company, or a sheet you protected years ago and forgot the password to.
Troubleshooting
- Older .xls (Excel 97–2003) files: save as .xlsx in Excel or LibreOffice first.
- "Encrypted" message: the file has a password-to-open; only the original password can open it.
- To add protection back afterwards, use Excel Password Protector.
