How to Remove Password from Excel

Excel is fantastic! We all love it. It's a great tool for data analysis, calculations, and many more. But what happens when you forget the password of your Excel file? It can be a real headache to deal with. I have been in such a situation and felt stuck with no way out. But after some research and experimentation, I finally found a way to remove the password from Excel files. So, if you're in the same boat as I was, then read on! I'm going to share with you how to remove password from Excel files in a few simple steps.

Step 1: Open the Excel file

The first step is to open the protected Excel file. You will need to enter the password to open the file. Once you're in, move on to the next step.

Step 2: Go to File

Click on 'File' in the top-left corner of the spreadsheet. This will open a drop-down menu. Next, click on 'Save As'.

Step 3: Save As and choose XML Spreadsheet

In the 'Save As' window, click on the 'Save As Type' drop-down menu and select 'XML Spreadsheet'. It's important to select this file type to remove the password.

Step 4: Open Windows Explorer

Now it's time to go to Windows Explorer. A quick way to get there is by holding the 'Windows Key' and 'E' on your keyboard. Alternatively, you can open Windows Explorer by clicking on the Windows icon in the bottom-left corner of your screen and selecting 'File Explorer'.

Step 5: Rename the file extension

Find the XML file you saved earlier and right-click on it. Select 'Rename' and remove the '.xml' extension at the end of the file name. So if the file was named 'excel_file.xml', rename it to 'excel_file'.

Step 6: Open the XML file

Right-click on the renamed file and open it with a text editor. Notepad is a great option that is available on almost all Windows systems.

Step 7: Find and delete the tag

Now search for the tag <workbookProtection workbookPassword="yourpassword">. This tag contains the password protection of your Excel file. Delete the entire tag that contains the password from start to finish. Once you've deleted it, save the file and exit the text editor.

Step 8: Verify that password has been removed

Go back to the Windows Explorer and double-click on the renamed file. This will open the Excel file without requesting any password. Congratulations! You have successfully removed the password from the Excel file. Save the changes, close the file, and you're done.

So, there you go! Follow these steps, and you can easily remove the password from any Excel file. No more headaches and frustrations with lost or forgotten passwords!

Wrapping it up

I hope you found this article useful and learned how to remove a password from an Excel file. Remember, always keep a copy of your spreadsheet without a password for emergencies. If you're interested in more Excel tips and tricks, be sure to check out our blog for more great content! Now, go out there, remove your passwords, and excel!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.