How to Decrypt Excel File Quickly

Excel files are important to us because we use them for various personal and official projects. We don't want our important files to get damaged, altered or edited by anyone else. So setting a password for an Excel file becomes a necessary thing to do sometimes. But the main problem starts when you forget the password of your Excel file. If you are reading this article, you won't have to worry at all. You will find the best solutions to learn how to decrypt Excel password easily. Also sometimes you want to decrypt an Excel file for personal reasons. You have come to the right place for your problem!

Option 1: Decrypt Excel File When You Know Password

If you know the password of the Excel file you want to decrypt, then you won't have to do much. For different versions of Microsoft Excel the options may be slightly different, but the main thing is still the same. Just follow the below steps to learn how to decrypt Excel file.

For Excel 2010 and above:

Step 1. Open the encrypted Microsoft Excel workbook and type the correct password.

new blank excel 2010

Step 2. Go to "File" from the top left corner of the menu, click on "Info" and then click on "Protect Workbook" option from the "Permissions" option.

Step 3. You will see a dropdown menu like below and now click on "Encrypt with Password".

secure excel workbook file 2010

Step 4. Now remove the password and press "OK".

remove password excel 2010

Step 5. Save the file.

For Excel 2003 and above:

Step 1. Open the encrypted Microsoft Excel workbook and type the right password.

new blank excel 2003

Step 2. Go to "Tools" option from the menu bar and then select "Options…".

tools option excel 2003

Step 3. Now you will see a new window and you will have to go to the "Security" option from the 13 options presented before you.

security advanced excel 2003

Step 4. Remove the password from the "Password to open" box and click on "OK".

Step 5. Save the file.

Option 2: Decrypt Excel File When You Lost Password

If you don't know the password of the Excel file you want to decrypt, then you will have to use proper methods to solve your problem. Follow these steps to learn how to decrypt Excel file password.

Solution 1 – Use PassFab for Excel

The best way to recover your lost Excel password is to use PassFab for Excel tool. This program is able to retrieve your lost Excel password in almost no time. Just follow these below steps to help yourself out with this useful software.

Step 1. Install the Excel password recovery software on your PC and launch it to start the process. Choose "Recover Excel Open Password" and continue.

excel password recovery

Step 2. Add the Excel file and select one decryption method in this Excel password recovery program that matches your situation.

import file

Step 3. Click on "Recover" and wait till the software decrypts the password. It may take some time depending on your password.

recovering password

Step 4. You will see a pop up window with your password in this software. Use the password to brute force Excel password.

show password

Solution 2 – Use Zip Software

If you can't edit a worksheet and the structure of a workbook/worksheet is locked, then you can use this method. If your file is password protected, then you can unlock it by following Solution 1. In this method, you will have to use a zip software to decrypt the Excel file. Follow these steps to learn how to decrypt Excel password by using a zip software.

Step 1. First you will change the file extension of the Excel file from ".xlsx" to ".zip". You will be able to see the file extension after the file name of your Excel file.

rename file

Step 2. Now you will have to extract the zip file by using any zip extractor like "7zip" or "WinRAR". Right click on the zip file and choose "Open archive". You will open it with your zip extractor.

zip file extraction

Step 3. Now open the "xl" folder and also "worksheets" folder which will give you all the sheets of the document file. Each sheet will be named as, "sheet1.xml".

sheets xml

Step 4. Choose "Edit" by right clicking on the locked worksheet, it will open the file in notepad.

edit sheet

Step 5. Now, tap on "Ctrl+F" button from the keyboard to find "sheetProtection" in the file. You will find the information of the algorithm that is used to lock this sheet. Delete all the information inside the brackets and also the word "sheetProtection" and save the file.

sheets notepad

Step 6. This time go to the folder where you have saved the edited worksheet. Open the "xl" folder. Your "workbook.xml" file will be in the "xl" folder.

zip file

Step 8. Right click the workbook.xml and choose "Edit", you will see a Notepad. Remove <WorkbookPotection.../> and save the file.

workbook eml edit workbook xml notepad

Step 9. Rename ".zip" to ".xlsx". Open the Excel file, you will see that you can edit the file without the password now!

excel file

Summary

Many people want to decrypt Excel password but they fail miserably because they don't follow proper steps or use proper methods. Reading this article will help you understand that decrypting an Excel password is easy with PassFab for Excel, you can also use it to unprotect Excel sheet.

Updated on / Posted by Shirley Howard to Excel Tips / Follow @Shirley Howard

Comment

Product-related questions? Speak directly to our Support Team >>