How can I remove password protection from excel file in Windows 11?

If Excel asks for a password before the file opens, that is file-level encryption. If the file opens but certain sheets cannot be edited, that is worksheet/workbook protection. If you have a backup, that is the safest option.

Or you can try copying the visible cells into a new workbook, as long as Excel allows the cells to be selected and copied.

But this does not remove the original protection password; it only copies accessible content. Hidden sheets, locked ranges, formulas, formatting, macros, or data validation may not transfer completely.

Rename as zip and remove the tag from the xml file.

isn't there any simple apps or feature to do that?

Dr..Excel has a built-in feature for removing password protection from an Excel file.

Checking metadata for hidden credentials is a simple native method to remove password from excel file in windows 11, yet this trick only works on a tiny subset of spreadsheets since few Excel versions store access credentials inside file metadata, and while it lets you view embedded credential text without downloading third-party cracking software, the vast majority of encrypted workbooks do not store this data, which means you often cannot remove password from excel file in windows 11 through this metadata check alone.

Instructions: Locate your password-protected Excel file, right-click the file icon, and select Properties from the menu. Switch to the Details tab at the top of the pop-up window.

Carefully check all the listed property fields for labels containing the words password or protected.

If a matching value appears in a field, copy that text—it may be the file’s unlock password.

Advantages include: it works entirely offline, requires no uploading of sensitive Excel content to the internet, and uses only basic right-click file operations built into Windows 11.

Disadvantages include: an extremely low success rate for standard password-protected Excel files; inability to remove strong workbook/worksheet encryption even if the metadata is empty; and complete ineffectiveness against Excel files protected by an open password or modification restrictions.

This method allows you to quickly check for plaintext passwords hidden in file metadata on Windows 11 devices. It is suitable for testing older Excel documents with lower protection levels created by outdated Office versions, and serves as a quick preliminary step before using dedicated Excel password removal tools.

You can use Python, but it does not support remove password protection from excel, as it is designed solely to remove password protection from worksheets in .xlsx files built using OpenPyXL.

It allows you to unlock all worksheets at once in a batch, but using this feature requires installing additional Python libraries on your Windows device, and you must run a custom script to fully complete the process of remove password protection from excel.

First, download the software and open the Command Prompt.

Run the installation command:

pip install openpyxl.

Create a blank text file and rename it to unprotect.py, then paste the code into that file:

from openpyxl import load_workbook

wb = load_workbook(‘yourfile.xlsx’)

sheet = wb.active

sheet.protection.password = None

sheet.protection.sheet = False

wb.save(‘unprotected.xlsx’)

Replace the target filename with the name of your protected Excel document. Run the script via CMD. Once completed, the tool will automatically generate a new, unlocked Excel file.

After the script runs successfully, you can open the generated output file. At this point, editing restrictions on all worksheets have been removed.

It cannot be used to remove the workbook-level open password from an Excel file, so it is only suitable for users who simply need to unlock a protected worksheet for editing.

If you don't want to use an online cloud tool or desktop office software, you can try this method. It requires basic programming knowledge, so please think carefully before proceeding.

PowerShell is a native Windows command-line tool that delivers a script-based method to remove password protection from excel. It leverages Excel’s COM component to programmatically lift sheet locks without third-party apps, you just need to modify the file path and password in the script to finish unlocking worksheets locally.

How to Remove password protection from Excel

1. Search PowerShell in the Start Menu, right-click it and select Run as Administrator.

2. Copy the below script, replace the file path and sheet password with your real information:

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open("C:\path\to\yourfile.xlsx")
$worksheet = $workbook.Worksheets.Item(1)
$worksheet.Unprotect("password_here")
$workbook.Save()
$workbook.Close()
$excel.Quit()

3. Paste the edited script into the PowerShell window and press Enter to run.

4. The target worksheet’s password protection will be removed automatically once the script finishes executing.

Disadvantages

• Microsoft Excel must be installed on the device; otherwise, COM component calls will fail.
• Command-line operations are not user-friendly for users without basic scripting knowledge.

This local scripting solution uses only Windows' built-in tools and is suitable for tech-savvy users who already know the worksheet password and prefer not to use cloud-based upload tools.

ps

• Replace the path C:\path\to\yourfile.xlsx with the actual full path where your Excel file is stored.
• Replace password_here with the actual password for the locked worksheet.
• This method only removes edit protection from the worksheet; it does not bypass the workbook’s full open password.
• Keep the PowerShell window open until the process is complete to prevent file corruption.

If you've forgotten the password and just want to remove password protection from Excel without installing any sketchy software, this is one of the easiest and safest workarounds out there.

Here's how it goes down:

1. Open your browser and head to Google Drive (you'll need a free Google account if you don't already have one).

2. Click "New" → "File upload" and select your protected Excel file.

3. Once it's uploaded, right-click the file and choose "Open with" → "Google Sheets".

4. Google Sheets will automatically try to convert and open the file. Most of the time, it completely ignores worksheet-level protection — no password needed, no questions asked.

5. Once it's open, you can edit, copy, or modify anything you need.

6. To save it back as an Excel file, go to File → Download → Microsoft Excel (.xlsx).

Boom - With just a browser and a free account, you can successfully remove password protection from Excel. No need to download, no need for terminal commands, and no worries about damaging the file with a hexadecimal editor.

If you are working with a file that contains multiple protected worksheets, Google Sheets usually removes the password protection of Excel at once - this is undoubtedly a nice additional advantage.

Ah, use "unlock_excel" to reopen your locked files. This is a rather ingenious little tool. It is a simple and straightforward command-line utility specifically designed to remove password from Excel file in Windows 11 (and other systems).

Here's the deal with what it actually does:

It's for VBA protection, not the main file password. This is the most important thing to remember. unlock_excel works on .xlsm, .xlsb, and old .xls files to remove password from Excel file in Windows 11 that protects the VBA (Visual Basic for Applications) code or macros. It's not meant to get you past the password you see when you first try to open the file.

It's a command-line tool. There's no fancy window to click around in. You'll have to open your command prompt or PowerShell and type in commands, which is something to keep in mind if you're not super comfortable with that.

As I mentioned, if you're stuck because you forgot the password to just open the file, unlock_excel can't help you remove the password from that Excel file in Windows 11. The method for cracking that kind of modern .xlsx encryption is totally different and much more complex.

OpenOffice Calc is an open-source spreadsheet editor that offers a way to remove password from excel file in windows 11. Its core feature for bypassing Excel worksheet locks eliminates the need for tedious manual XML editing; you can simply re-export the file to remove worksheet restrictions without having to manually modify the XML code.

How to Remove Password from Excel File in Windows 11

Step 1: Download and install the software from the official website.

Step 2: Launch the software—specifically, the spreadsheet application included in the software package.

Step 3: Click File → Open, then select your password-protected Excel file in XLSX format.

Step 4: If only the worksheet is protected, the software will immediately grant full editing permissions.

Step 5: You can freely edit the worksheet content, or you can keep the original data unchanged without making any modifications.

Step 6: Click File → Save As, and set the output format to Microsoft Excel 2007–2021 (.xlsx).

Finally, confirm to save the new file; the worksheet protection restrictions will be completely removed.

This offline open-source tool is a user-friendly alternative to the ZIP XML method, ideal for Windows 11 users who want to unlock protected Excel worksheets without changing the file extensions on their system.

Pros

• Runs completely offline; no internet connection is required to remove passwords.
• Features a graphical user interface, significantly reducing the likelihood of errors compared to manually editing ZIP codes.

Cons

• Can only bypass worksheet protection; it does not work on Excel files that require an open password and display a prompt upon launch.
• Requires downloading and installing the full office suite, which takes up additional hard drive space.