How to Unlock an Excel File Without the Password

First, Identify Which Lock You Are Facing

“Locked Excel file” covers three very different situations, and only the first two can be solved without the password:

If Excel asks for a password before showing any content, the file is encrypted (AES), and no tool can “just remove” that — anything claiming otherwise is guessing passwords. This guide covers the far more common case: files you can open but not edit.

How to Unlock a Protected Excel Sheet Online (No Password)

1. Open the free Excel password remover and drop in one or more .xlsx or .xlsm workbooks. Files are processed locally in your browser — nothing is uploaded.
2. Click Remove passwords. Sheet protection, workbook structure locks, read-only (“password to modify”) prompts, and protected ranges are stripped automatically.
3. Check the report — every file lists the sheets that were unlocked by name.
4. Download the result. A single file downloads directly; batches come back as a ZIP.

The whole pass takes seconds even for large workbooks, and there is no attempt to crack, guess, or brute-force anything — which is exactly why it is instant.

• Excel Password RemoverStrip sheet and workbook protection in the browser.

Why This Works Without the Password

An .xlsx workbook is a ZIP archive full of XML files. When an author protects a sheet, Excel does not encrypt the data — it writes a <sheetProtection> element (containing only a hash of the password) into that sheet’s XML, and then refuses edits while the element is present. Workbook structure locks use <workbookProtection>, and the “password to modify” prompt is stored as <fileSharing>.

The tool opens the archive in your browser, removes those elements, and repackages the workbook. Your data was never encrypted in the first place — the lock is simply taken off the door, not broken down.

How to Unprotect a Sheet in Excel With the Password (For Reference)

1. Open the workbook and go to the Review tab.
2. Click Unprotect Sheet (or Unprotect Workbook for structure locks).
3. Enter the password if prompted, and click OK.

If you are the file’s author and merely forgot whether you set a password, try blank first — Excel accepts an empty password for many older protection setups. Files saved in the legacy .xls 97-2003 format use much weaker protection than modern .xlsx, but this site’s tool handles .xlsx/.xlsm directly, so converting is unnecessary.

Is Removing Protection Legal?

Sheet protection is an anti-typo guard, not a security boundary — Microsoft’s own documentation describes it as preventing accidental changes. Removing it from files you own or are authorized to edit (your old templates, a colleague’s handover file, an inherited report) is a normal maintenance task. Unlocking someone else’s confidential file without authorization is not what this tool is for.

Before re-sharing an unlocked file, consider scrubbing the author metadata as well — the removed workbook may still contain the original author’s name, company, and revision history.

• Remove Metadata from ExcelStrip author, company, and revision info before sharing.