Wednesday, August 12, 2015

How to unlock password protected EXCEL file without any software used

In this blog, i want to share my some of tricks and experiences about  general hacking like unlocking password protected PDF, EXCEL, WORD, PPT etc.

Today i am going to teach you, how to editing and modify of any password protected .xlsx file.

First of all you have a password protected EXCEL file and after that apply the following step:

1) You have to change file extension. For example test.xlsx to test.zip
     i) there are two way to change the extension as follow:
        a) directly double click on the particular file.
        b) through command prompt.

 2) After changing the extension, open the .zip folder and find sheet1.xml file.
    i)     test.zip\xl\worksheets
    ii)    copy that sheet1.xml file.
    iii)   open in notepad and search "password" and delete in between the quotes "<sheetProtection password="C71F" sheet="1" objects="1" scenarios="1" selectLockedCells="1" selectUnlockedCells="1"/>".
    iv)   save the file and replace the original file into the zip folder.
    v)    rename .zip folder to .xlsx

3) Here you go the file is editable and unprotected.

4) Try it with the test.xlsx. Share it also.

if you have any query please let me know.

Important: This article is for educational purposes. Try this method for opening ONLY your own files.THANKS

No comments:

Post a Comment