How to Unprotect an Excel Sheet Without the Password
If a worksheet is locked and you don't have the password, you can still remove the protection — because Excel's sheet protection was never designed as real security. Here are the three methods that work, from fastest to most manual.
On this page
Why this is possible without the password
An .xlsx file is really a ZIP archive containing XML. When you "Protect Sheet" in Excel, it writes a single line into that XML — a <sheetProtection> element — that tells Excel to refuse edits. Even when you set a password, Excel only stores a hash of it, used to compare against what you type later. The data itself is never encrypted or scrambled.
That means removing protection doesn't require cracking or guessing anything. Delete the <sheetProtection> line and the lock is simply gone. This is why every method below works regardless of how strong the original password was.
This applies to sheet and workbook protection (the password prompt appears only when you try to edit). It does not apply to a file that asks for a password before it opens — that's AES encryption, covered at the end.
Method 1: Use a browser tool (fastest)
The manual method below works, but it's fiddly and easy to get wrong on workbooks with many sheets. A dedicated tool automates the exact same XML edit in one step.
Unprotect your sheet in your browser
No upload, no signup. Your file is processed locally and never leaves your computer.
Open the free unlocker →- Open the unlocker tool.
- Drag your
.xlsxor.xlsmfile onto the drop zone. - An unprotected copy downloads automatically — your original is left untouched.
Because the work happens entirely in your browser, the file is never sent anywhere. For payroll, financial, or client spreadsheets, that matters: most other "online" unlockers upload your file to their server.
Method 2: The manual ZIP method
If you'd rather not use any tool, you can do the edit by hand. This is the method Google often shows in its featured snippet, and it's genuinely reliable — just slower.
- Make a copy of your workbook first, so you always have the original.
- Change the copy's extension from
.xlsxto.zip. (On Windows you may need to enable "File name extensions" in File Explorer's View menu first.) - Open the ZIP and navigate to
xl/worksheets/. You'll seesheet1.xml,sheet2.xml, and so on — one per worksheet. - Open the relevant sheet's XML in a text editor and find the tag that begins
<sheetProtection. It runs until the next/>. - Delete that entire
<sheetProtection ... />tag, then save. - Rename the file's extension back from
.zipto.xlsx. The sheet is now unprotected.
If you delete too much (past the closing />) or break the XML, Excel will report the file is corrupt. Repeat for every protected sheet. On a workbook with 20 tabs, this is where the manual method becomes tedious — and why unprotecting all sheets at once is worth reading.
Method 3: LibreOffice or Google Sheets
Two pieces of free software handle sheet protection differently from Excel and can sidestep it:
- Google Sheets: Upload the file to Google Drive and open it with Google Sheets. Sheets doesn't honor Excel's worksheet-protection lock, so you can edit freely, then download as
.xlsxagain. The trade-off: complex formatting, macros, and some formulas can shift in the round-trip. - LibreOffice Calc: Open the file, go to Tools → Protect Sheet, and toggle protection off — LibreOffice doesn't enforce the password the way Excel does. Save back to
.xlsx.
Both are good fallbacks if you already use them, but the conversion risk makes them less safe for intricate workbooks than a direct XML edit.
When none of these will work
There's exactly one case where you cannot remove the lock without the password: full file encryption. If Excel asks for a password the moment you double-click the file — before showing you any content — the workbook was secured with File → Info → Protect Workbook → Encrypt with Password. That uses real AES encryption, and the data is genuinely unreadable without the key.
No tool, including ours, can remove that, and you should be wary of any site that claims otherwise. To understand the difference in full, see sheet protection vs encryption.
Remove protection only from files you own or are authorized to edit — a workbook you created, or one a colleague has asked you to update. See is it safe and legal to remove Excel protection.