QuickMergeUnprotect an Excel Sheet
Get editing access back to your own .xlsx workbook by clearing the sheet-protection flag it carries. The file is opened and rewritten in this browser tab and is never uploaded.
How do I unprotect an Excel sheet?
Drag your .xlsx workbook here
or click to browse — the file is read in this tab and never uploaded
What this does and does not do. It clears Excel’s sheet protection flag — the setting that stops cells being edited. It does not open encrypted workbooks, and it does not recover, reveal or crack passwords. If your file asks for a password before it will open at all, that is encryption, and nothing on this page will help with it.
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
- Drop in the .xlsx file. It is opened in this tab and each worksheet is inspected.
- 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.
- 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.
- Download. The workbook saves with
-unprotectedin 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 put protection back on afterwards — or to protect a workbook of your own for the first time — use the Excel protection tool. If the sheet needs to go out as a read-only document nobody can edit at all, exporting it to PDF and encrypting that is a stronger answer than any spreadsheet flag.
Frequently asked questions
If you have the password, use Excel: Review → Unprotect Sheet. If the password is gone and the file is yours, drop the .xlsx above, confirm it is your file, and download the copy with the protection flag removed. Everything happens in your browser.
No. No password is guessed, revealed or brute-forced. Sheet protection is a flag in the worksheet XML rather than encryption, and this tool removes the flag. If you need the original password itself, this cannot give it to you.
No. That is file encryption — a different feature from sheet protection, using AES, and stored in a completely different container. The tool will report that it cannot read the file. Without the password those contents cannot be recovered here or anywhere else.
For your own files, or files you are authorised to edit, this is ordinary maintenance. For someone else’s file it may breach your employer’s policy or the law depending on where you are and what the document is. The confirmation checkbox is there in earnest — this tool is offered on that condition.
Usually something other than sheet protection: the file may be marked as final or flagged read-only by the operating system, it may have opened in Protected View after being downloaded (choose Enable Editing), or somebody else may have it open on a shared drive.
No. Only the protection element is removed from the XML. Values, formulas, formatting, charts and sheet order are untouched, and the download is a new file with -unprotected in its name, so your original is left exactly as it was.
No. An .xlsx is a ZIP of XML files; this page opens it with JSZip, edits the worksheet XML and repackages it, all inside this browser tab. A file someone needs to unlock is usually real business data, and uploading it to have an attribute deleted would be a bigger risk than the problem.
Use the Excel protection tool to set a new password, or do it in Excel with Review → Protect Sheet. Note the new password down somewhere — neither Excel nor this site can recover it later.