Home › Remove Excel sheet protection manually (the ZIP method)

Remove Excel sheet protection manually (the ZIP method)

What you are about to do

An .xlsx file is just a ZIP archive of XML files. Sheet protection is a single self‑closing tag, <sheetProtection .../>, inside each protected worksheet's XML. Delete that tag, put the archive back together, and the sheet is editable again. No password, no software beyond your file manager and a text editor. This works because the protection is an edit lock, not encryption — the data was never scrambled.

Step by step

Copy the file first. Always keep an untouched original in case a step goes wrong.
Show file extensions in your OS (Windows: View → File name extensions; macOS: Finder → Settings → Advanced → Show all filename extensions).
Rename Book.xlsx to Book.zip. Confirm the change when prompted.
Open the ZIP and navigate to xl/worksheets/. You will see sheet1.xml, sheet2.xml, and so on — one per tab.
Extract the sheet you need to unlock (e.g. sheet1.xml) and open it in a plain text editor.
Find and delete the whole <sheetProtection ... /> tag. It is one self‑closing element, usually near the top; remove everything from <sheetProtection through the closing />. Do not touch anything else.
Save the file, then put it back into the ZIP at the same path (xl/worksheets/sheet1.xml), replacing the original. Repeat for any other protected sheets.
Rename the archive back to Book.xlsx and open it in Excel — the sheet is now editable.

Pitfalls to avoid

Keep the folder structure. When you put the edited XML back, it must stay at xl/worksheets/sheet1.xml. If your zip tool nests the file inside an extra folder, Excel will report the workbook as corrupt.

Re‑zip the contents, not the parent folder. If you fully extracted the archive, select the inner files and folders ([Content_Types].xml, _rels, xl, docProps) and zip those — not a wrapping folder.

This is edit protection only. If Excel asks for a password to open the file, that is AES encryption; the sheetProtection tag will not even be readable, and this method cannot help.

Unlock it in seconds instead

The manual route works, but our free in‑browser tool does the same thing in one drop — nothing is uploaded, everything runs on your device.

Unlock your file now →

Frequently asked

Which sheetN.xml maps to which tab?

The numbering follows the order the sheets were created, not necessarily the tab order. If unsure, open each and remove the sheetProtection tag from any that contain one.

Excel says the file is corrupt after re-zipping. Why?

Almost always the folder structure changed. The XML parts must sit at their original paths inside the archive — do not wrap them in an extra folder when re-zipping.

Is this safe for my data?

Yes, as long as you only delete the sheetProtection tag and keep a backup copy. The cell data lives in other XML parts you never touch.