Unprotect Excel Sheet Online Free

Remove sheet and workbook protection from your Excel files in seconds, even when nobody remembers the password. Everything runs in your browser, so your file never leaves your computer.

How to unprotect an Excel sheet online

1. Add your file. Drop an .xlsx or .xlsm file into the box above, or click Choose files. You can add up to 10 files at once, up to 20 MB each.
2. Check the report. The tool lists every sheet, shows whether it is protected, what the protection was blocking, and any hidden or very hidden sheets.
3. Pick what to remove. Untick any sheet you want to keep locked. Choose whether to remove workbook structure protection and read-only settings, and whether to unhide hidden sheets.
4. Download. Click Unprotect & download. You get a new copy named yourfile_unprotected.xlsx. Your original file is not changed.

Want to lock it again once you have made your changes? Tick Protect again with a new password before you download. The tool uses the same SHA-512 password method as current versions of Excel, so the new password works in Excel exactly like one you set yourself.

What this tool removes (and what it can’t)

Excel has several different kinds of lock. Most of them only stop editing. One of them actually encrypts the file. Here is which is which.

Lock	How you can tell	Removed by this tool?
Sheet protection	Excel says “The cell or chart you’re trying to change is on a protected sheet.”	Yes, with or without the password
Protected ranges (Allow Edit Ranges)	Some cells ask for their own range password	Yes
Workbook structure protection	You can’t add, delete, rename, move, hide or unhide sheets	Yes
Read-only recommended	Excel asks whether to open the file as read-only	Yes
Password to modify	Excel asks for a password, or offers to open it as Read Only	Yes
Hidden and very hidden sheets	Sheets are missing from the tabs. Very hidden sheets are not even in the Unhide list.	Yes (optional)
Password to open (encryption)	Excel asks for a password before showing anything	No. Only the original password can open it.
VBA project password	The VBA editor asks for a password to view the code	No. Macros are left exactly as they are.

Is it safe to unprotect an Excel sheet?

Yes, for files you own or have permission to edit. Sheet protection was never designed to keep data secret. Microsoft’s own documentation says: “Worksheet level protection isn’t intended as a security feature. It simply prevents users from modifying locked cells within the worksheet.” The data on a protected sheet is stored as normal, readable content. The protection is just a setting that tells Excel to block edits.

Some online unlockers upload your file to their server. This one doesn’t. Your file is opened, changed and saved in your own browser, which makes it a sensible choice for budgets, payroll and client files you would rather not send anywhere.

Please only use it on files you are allowed to change.

How to unprotect an Excel sheet if you know the password

If you still have the password, Excel can remove the protection itself:

1. Open the workbook and go to the protected sheet.
2. On the Review tab, click Unprotect Sheet.
3. Enter the password and click OK.

This works the same way in Excel for Microsoft 365 on Windows and Mac, and in Excel for the web. On Windows you can also use File > Info > Protect > Unprotect Sheet.

To remove workbook structure protection, click Review > Protect Workbook, enter the password and click OK.

How to unprotect an Excel sheet without the password (manual method)

This is exactly what the tool does for you. If you would rather do it by hand, it works because an .xlsx file is really a ZIP folder full of XML files.

1. Make a copy of the workbook and work on the copy.
2. Rename the copy from .xlsx to .zip. If you can’t see file extensions, turn on File name extensions in File Explorer’s View menu.
3. Extract the ZIP file to a new folder.
4. Open the xl\worksheets folder and open the sheet’s XML file (sheet1.xml, sheet2.xml and so on) in Notepad. The numbers don’t always match the order of the tabs, so check each file.
5. Find the tag that starts with <sheetProtection and delete it, from <sheetProtection up to and including the closing />. Save the file.
6. Select all the extracted files and folders (not the folder that holds them) and compress them into a new ZIP file.
7. Rename the new ZIP file to .xlsx and open it in Excel.

For workbook structure protection, do the same in xl\workbook.xml and delete the <workbookProtection ... /> tag.

The two usual mistakes are zipping the outer folder instead of its contents, and deleting more than the one tag. Either one can stop the file from opening or trigger Excel’s repair message. The tool avoids both.

You may also find VBA macros online that “crack” sheet passwords. Those were written for the older protection method. Files protected in Excel 2013 or later use a SHA-512 password hash, which those macros can’t realistically get past. Removing the protection tag works on both.

How to unhide very hidden sheets

A sheet can be hidden in two ways. Normal hidden sheets appear in Excel’s Unhide list (right-click any sheet tab, then Unhide). Very hidden sheets don’t appear there at all. You can only bring them back from the VBA editor, or by ticking the Unhide option in the tool above.

To do it in Excel:

1. If the workbook structure is protected, unprotect it first (Review > Protect Workbook). Structure protection blocks unhiding.
2. Press Alt + F11 to open the VBA editor.
3. In the Project window, select the hidden sheet.
4. In the Properties window (press F4 if you can’t see it), change Visible to -1 - xlSheetVisible.
5. Close the VBA editor. The sheet now appears with the other tabs.

Still can’t edit the file? Common causes

• Excel asks for a password before the file opens. The file is encrypted. If you know the password, open it, go to File > Info > Protect Workbook > Encrypt with Password, delete the password and save.
• A yellow PROTECTED VIEW bar appears. This is Excel’s safety check for files from the internet or email, not protection. Click Enable Editing.
• A MARKED AS FINAL bar appears. The author marked the file as finished. Click Edit Anyway.
• Windows says the file is read-only. Right-click the file, choose Properties and untick Read-only.
• It’s an .xls or .xlsb file. Open it in Excel, choose File > Save As > Excel Workbook (.xlsx), then add the new file to the tool.

Practice challenge: find the very hidden sheet

Get the answer in seconds, then master it with practice. Click Download the locked sample in the tool above. It has two protected sheets, a locked workbook structure, and one sheet you won’t see at all. The password is excel.

1. Open the sample in Excel and try to type in the Budget sheet.
2. Unprotect the sheet and the workbook in Excel using the password.
3. Find the very hidden sheet using the VBA editor steps above. Its message tells you when you have found it.
4. Check your work: run the original sample through the tool with Unhide hidden and very hidden sheets ticked, and compare.

Frequently asked questions

Is this Excel unprotect tool free?

Yes. There is no signup and no limit on how often you use it. You can add up to 10 files at a time, up to 20 MB each.

Are my files uploaded to a server?

No. The tool runs in your browser. Your file is opened, changed and saved on your own device. The file itself is never sent anywhere.

Can I unprotect an Excel sheet without the password?

Yes. Sheet protection is a setting inside the file, not encryption, so the tool can remove it without knowing the password. It works for both older protection and the SHA-512 protection used by current versions of Excel.

Does it unprotect every sheet or just one?

You choose. Every protected sheet is ticked by default. Untick any sheet you want to keep locked before you download.

Can it remove the password needed to open a file?

No. A password that Excel asks for before it shows anything is real encryption. Only the original password can open that file. The tool detects encrypted files and tells you, instead of pretending to unlock them.

Will unprotecting change my data, formulas or macros?

No. Only the protection settings are removed. Cell values, formulas, formatting, charts and macros stay as they were. In our tests, the macro code in .xlsm files came out byte-for-byte identical, and the macros still ran in Excel.

Which file types are supported?

Excel workbooks (.xlsx), macro-enabled workbooks (.xlsm) and Excel templates (.xltx and .xltm). For older .xls files or binary .xlsb files, open them in Excel, save as .xlsx, then add the new file.

What is the difference between sheet protection and workbook protection?

Sheet protection stops changes to the cells on one sheet. Workbook structure protection stops people adding, deleting, renaming, moving, hiding or unhiding sheets. A file can have either one or both, and this tool can remove both.

Can I protect the sheet again after I make my changes?

Yes. Tick “Protect again with a new password” before you download, or protect it in Excel with Review > Protect Sheet. The tool uses the same SHA-512 password method as current Excel, so your new password works in Excel as normal.

Is it legal to unprotect an Excel sheet?

Removing protection from a file you own, or one you have permission to edit, is a normal task. Microsoft itself says sheet protection is not a security feature. Do not use the tool on files you are not allowed to change.

More free Excel tools

• Variance Calculator: sample or population variance with the matching Excel formula.
• Excel Sample Data Generator: create sample data to practise with in Excel.
• See all free Excel tools