Skip to main content

Breaking Excel password protection

If you came across an excel sheet asking for password for allowing to make any changes into it, you may want to unprotect it.
All we need to do is to edit the xml file which comes intrinsically packaged with Excel 2007 or 2010. But what about Excel 2003? For that, open the Excel 2003 file within Excel 2007, save it as xlsx file. So, keep in mind all the Excel files below 2007 version, you need to convert them as Excel 2007 with extension .xlsx.
Now here are the steps for doing that:
1. Open the Excel 2003 file (e.g. Secret.xlsx) and save it as .xlsx (Excel 2007) format. If you already have Excel 2007 file, then no need for any conversion.

2. Now change the extension of the above file to .zip and extract the zipped file. Browse through the file in the extracted folder and go to:
<LocalPath>\Secret\xl\worksheets.
 
3. Now open the sheet/ sheets you want to remove protection in any xml editor. Look for keywords such as 'sheetProtection' or 'workbookProtection' in the xml file.
Remove such lines entirely from the xml files above. Do this for all the sheets you want to remove the protection.

4. Now, copy all these edited and saved xml files to the original zip file under the same path. Now change the extension back to .xlsx from .zip. You are done!

Comments

Anonymous said…
I tried your suggestion. But it did not work. After saving it as an xlsx file, I rename the file to a zip extenstion.

That is where I start having a problem. The file fails to extract stating its an invalid file.
May 16, 2012 at 12:17 AM
Nilesh Kumar said…
@ Anonymous,
Seems you file is an Excel 2003 file.
As I have mentioned in the blog, this only works for Excel 2007 or 2010 with .xlsx extension. If the file is Excel 2003, you need to open it with Excel 2007 and save it with .xlsx extension.So, keep in mind all the Excel files below 2007 version, you need to convert them as Excel 2007 with extension .xlsx.
Let me know if that helps.
Thanks,
Nilesh
May 16, 2012 at 8:43 PM
Anonymous said…
How can you open a password protected Excel 2003 file with Excel 2007 and save it with .xlsx???? If a file has a password, you can't open it!!!!!!!!
June 25, 2012 at 3:27 PM
shekhar said…
i have a file in excel 2007 password protected i cant open beacuse forget password i am very thankful if u help me in open i send u a file on your email id

regards
shekhar
January 21, 2013 at 10:07 PM
Anonymous said…
Dear I have an excel 2003 sheet which is password protected and I can not open it. I have tried the brute forcing software but it takes hell lot of time. is there some simple way to remove the password
April 6, 2013 at 12:30 PM
Anonymous said…
That worked very well. Hard to believe that the "protection" was that easy to crack. Why in the heck would anyone use a code cracker to try and guess the password when this method took me all of 10 minutes from start to finish, and that includes the time it took to download a zip file program? Thanks for the tip.
April 15, 2013 at 11:57 PM
FGSouza said…
The method works to unprotect a spreadsheet. However how can I, (after have unprotected the sheet and made my modifications), return the protection with the same password that was before? Any ideas?
May 29, 2013 at 2:29 AM
Abhishek said…
Thanks a lot Nilesh. I tried and it worked.
May 31, 2013 at 1:28 PM
Anonymous said…
didn't work for me. Is there a 2006 version of Excel? I think that's what mine is
July 8, 2013 at 10:02 PM
René Jensen said…
Works fine
Can you get the password to?
November 6, 2014 at 4:16 AM
Post a Comment

Popular posts from this blog

File Upload through Null Byte Injection

Sometimes, during file upload we come across situation wherein there would be check on the file extension at the client side as well as server side too. If the application does allow only .jpeg extension to be uploaded, the client side java script checks for the extension of the file before passing the request. We all know that how easily this can be defeated. Some applications, checks for the extension at the server side also. That's not easy to bypass. However there are some ways with which it still can be bypassed. Most of server side scripts are written in high level languages such as Php, Java etc who still use some C/C++ libraries to read the file name and contents. That leads to the problem. In C/C++ a line ends with /00 or which is called Null Byte. So whenever the interpreter sees a null byte at the end of the a string, it stops reading thinking it has reached at the end of the string. This can be used for the bypass. It works for many servers, specially php servers. T...
1 comment
Read more

'Information Leakage-Improper Error Handling' dropped

From Owasp Top 10 2010 List, the issue 'Information Leakage-Improper Error Handling' has been dropped. But it's not the final list,its child release actually. Bu I feel it shouldn't be set aside because its still the one of the prevalent issues these days. That's why I mailed to Dave Wicher: Hi Dave, Excellent work, Congrats! Just one little query- Don't you think that Information Leakage & Improper Error Handling still deserves to be in Top 10? Dave replied: This topic is clearly a very prevalent issue that deserves attention by most organizations. However, the typical impact of such a flaw is usually very low. Therefore, the overall risk of this type of flaw is lower than the other items in the top 10, which is why it was replaced in this update with one of the 2 new items. Regarding dropping Info Leak/Error handling - It is incredibly prevalent, no question. But their impact is typically very low, so the overall risk is low, which is why it fell out of t...
3 comments
Read more

jtool - an alternative to otool

jtool comes with a capability of running on Linux environment. Some ipa scanning tools are created to run on Linux environment where mac environment is not available. In such cases tools such as otool and class-dump-z will not work. So jtool can be an alternative to otool. For more information on jtool please refer to http://www.newosxbook.com/tools/jtool.html . It lists down various commands which have same output as otool or a equivalent. There are several commands mentioned in link. But for our customized requirements and basis checks I have listed down the below ones after running on many binaries. The outputs are similar or equivalent to otool and class-dump-z: Commands for checking PIE flag (ASLR) in jTool jtool -d -v -arch | grep stack ·           Automatic Reference Counting (ARC) protection: jtool -d -v -arch | grep _objc_release ·           To check if the devic...
1 comment
Read more