How to Open A Password-Protected Excel File If You Forgot Password

Posted by Vicky Tiffany on

Protecting any kind of document with a password is absolutely recommended by every computer expert. The sole reason of password-protecting a computer is to keep it safe from hackers and intruders that may steal the information from those documents. Excel sheets are often used to create databases which stores the most valuable information about any aspect. So, considering the importance of these documents, one must absolutely password-protect them.

But the real issue arises if we forget password of excel sheet and unable to open password protected Excel file when we need it urgently. Now, resetting excel file passwords are not similar to resetting email or computer password since excel sheets are documents that are stored in database format. In this tutorial, we will teach you how to open a password protected excel files so that you can regain the access to your document and retrieve the data from the file.

Method #1: View/Open Protected Excel by Modifying the File Extension

This method is perfectly working with Microsoft Office 2010 or previous versions. Please keep in mind, this may or may now work with the latest Microsoft office versions. But if you are using an older version of MS office then feel free to apply the following steps to unlock your excel file.

Step 1. First, create a backup of the excel file that is password-protected.

Step 2. Next, right-click on the excel sheet and hit the rename button.

Step 3. Change the file extension to ".zip" from ".csv" or ".xls"

Change the file extension

Step 4. Unzip the content from the zip file now.

Step 5. Look for the file that ends with ".xml" format.

Step 6. Now, double-click on the XML file and open it with XML editor.

Step 7. Press "Ctrl + F" and find the word "SheetProtection". Search for the line that begins with " <sheetProtection algorithmName="SHA-512″ hashValue=".

It will look something like:

open protected Excel

modify Excel file

Step 8. Remove that word from the file and save it.

Step 9. Now change the ".zip" file to ".csv" or ".xls" and hit enter. Now, all of yourworksheets will be uprotected and you can be able to open your protected Excel file without tying password. Then you can view your Excel content.

open and view Excel



Also read: How to password protect your Excel file

Method 2. Open Password-Protected Excel File Using Excel Password Recovery

If you are looking for a guaranteed way to open and view password protected Excel then it is recommended to use an Office Password Recovery tool. Honestly speaking, using this tool will save countless time on recovering lost Excel password without distorting the original data and it provides the highest password recovery success rate in this industry. It uses the most powerful algorithms to crack down your password in minimum time. Compared with other tools, it is the most effective and smartest Excel password recovery tool available online as It offers 4 ways to recover lost Excel password including brute-force, mask, dictionary and smart attacks.

The user interface of this Excel password recovery tool is very simple and it doesn’t require to have any technical skills to operate this program. You can customize the tool settings as much as you can and the more precise information you feed in, the faster this program will crack the password. Moreover, it is not limited to Microsoft office 2003/2007, it is even supported in Microsoft office 2017/2016/2013/2010 and old versions as well.


1Install and Run Excel Password Recovery Tool

Download the program and run the executable file on your PC. Once the installation is finished, you will be able to see the main UI of this program. Click on "Open" icon and select the Excel file from your computer's local drive.

startup of excel password recovery


2Add Password Protected Excel to the Program

From the main screen, select File-> Open File, then an Open File Dialog pops up. Locate the password protected Excel file and click Open to load the file into the program.


3Choose the Type of Attack

Choose the type of attack from the given options and at this point, it will be better to select the most appropriate option to fasten the password cracking process. Customize the settings as accurately as you can. It will be helpful for the program to know the password length, strength and all other information that you could provide.

brute force recovery


4 Star Recovering Password from Microsoft Excel File

Finally, click on the "Start" button and let the program find the password of your file. The progress indicator will be shown in real time and once the password is cracked it will be displayed on the screen of the program. You can click on "Copy" and paste it on a textbook then use it to open the excel file again.

word password recovered

Please remember that it is not easy to crack excel passwords but yet Office Password Recovery makes it extremely easier to open password protected Excel file even if you forget it. Also, it is recommended to keep a backup of your passwords on a cloud server or e-mail account so that you can retrieve it whenever you forget them. Also, it is better to write down the passwords on a piece of paper or text file so that you can recover the password whenever it is needed.


Related Articles & Tips

Office Password
Office Tips