Unprotect an Excel Sheet

Getting back into your own spreadsheet

The situation this page exists for is a common and genuinely annoying one. A workbook you own will not let you edit it: a template you built last year and protected, a sheet inherited when a colleague left, a report from a system that protects its output by default, or a file you locked and whose password you have long since forgotten. The data is yours and visible on screen, but Excel refuses every keystroke.

Sheet protection is not encryption, and it is important to be straight about why that means this works. It is a flag stored in the worksheet's XML — an instruction to spreadsheet software saying “do not let people edit this”. Microsoft designed it to prevent accidental changes to formulas and formatting, and documents it in exactly those terms rather than as a security control. The tool above clears that flag. It is not defeating encryption, because there is no encryption involved.

How to remove the protection

1. Drop in the .xlsx file. It is opened in this tab and each worksheet is inspected.
2. Check what was found. The tool lists which sheets carry a protection flag and whether the workbook structure is locked, so you can see what is actually there before changing anything.
3. Confirm the file is yours. The button stays disabled until you do. That checkbox is not decoration — it is the condition on which this tool is offered.
4. Download. The workbook saves with -unprotected in its name, so your original is left exactly as it was.

Open the result and the cells accept typing again. Everything else — values, formulas, formatting, charts, sheet order — is untouched, because only the protection element is removed.

The route through Excel, if you know the password

If you have the password, you do not need this page at all. In Excel it is Review → Unprotect Sheet, and for structure, Review → Protect Workbook toggled off. Do it that way when you can: it is one dialog, it needs no download, and it leaves no second copy of a file that may be confidential. This tool is for the case where the password is genuinely gone and the file is genuinely yours.

What this tool will not do

It does not open encrypted workbooks. If Excel asks for a password before it will show you anything, the file is encrypted with AES rather than protected with a flag, and it is not an ordinary .xlsx internally — it is a completely different container. The tool above will tell you it cannot read the file, which is the truthful answer. Without that password the contents cannot be recovered by this page, by any other browser tool, or by us.

It does not recover or reveal passwords. No password is displayed, guessed or brute-forced at any point. The protection element is removed, not decoded. If you need the original password itself — because other files share it, say — this will not give it to you.

It is not for other people's files. Removing protection from a workbook you have no right to edit is not made acceptable by being easy, and depending on where you are and what the file is, it may breach your employer's policy or the law. The confirmation checkbox is where that line is drawn, and it is drawn in earnest.

When the sheet is not protected but still will not edit

If the tool reports no protection and Excel still refuses your edits, one of these is usually the cause, and none of them is sheet protection:

The file is read-only or marked final. Check File → Info for “Mark as Final”, and check the file's own read-only attribute in Windows Explorer or Finder — a file copied from a CD, a locked network share or an email attachment often arrives read-only.

It opened in Protected View. Files downloaded from the internet or opened from email land in a sandboxed read-only mode with a yellow bar across the top. Choose Enable Editing.

Somebody else has it open. On a shared drive or SharePoint, a workbook already open elsewhere opens read-only for you.

Specific cells are locked but the sheet is not protected. The locked attribute on cells only takes effect while the sheet is protected, so this alone should not block you — but it is worth knowing the two settings are separate, which is why a sheet can look locked and not be.

Nothing is uploaded

An .xlsx file is a ZIP archive of XML documents. This page opens the archive with JSZip, removes the protection element from the worksheet XML, and repackages it — inside this browser tab, on your device. That matters especially here: a workbook somebody needs to unlock is usually a real business file with real data in it, and uploading it to an unknown service to have an XML attribute deleted would be a much larger risk than the problem being solved. Nothing is sent and no copy is kept. Check it in your browser's network panel.

The guide to locking and unlocking documents covers this same distinction for PDFs, where the gap between a permissions flag and real encryption causes exactly the same confusion. To restore an editing lock, use Excel’s Review → Protect Sheet command. To require a password before the workbook can be opened, use the Excel encryption tool. If the sheet needs to go out as a read-only document, exporting it to PDF and encrypting that is often a better fit.

Next steps