If you're here, you must have forgotten your Excel password and looking for ways on how to remove Excel password quickly. Then you have come to the right place! We have tested popular Excel password recovery methods and after comparing them, we are here to recommend the 5 best Excel password removal methods. Even if you are a technology newbie, after reading this post you will definitely unlock your Excel password!
Top 5 Best Excel Password Removal Methods for 2023:
Method 1: Remove Excel Password with iCrowbar
It can be said that iCrowbar is the most popular and effective file password remover on the market today. It can quickly unlock Excel workbooks regardless of the length and complexity of the password and has been highly rated by a considerable number of users.
Support removing passwords of different types of files: Besides Excel, it also supports removing passwords of Word, PowerPoint, PDF, RAR, ZIP and other files without losing data.
Support removing restrictions of office files: It can remove editing restrictions of Excel, Word, PowerPoint, PDF files with one click, thus allowing you to modify, copy and paste.
4 Attack Modes: Provides 4 advanced and powerful attack modes with almost the highest success rate of decoding in its class.
10X faster: Using advanced algorithms and GPU and CPU acceleration, cracking passwords is the fastest in its class.
Easy to use: Just a few simple steps, friendly to non-technical people.
Steps to Remove Password from Excel with iCrowbar:
Step 1: Download and install iCrowbar software on your computer.
Step 2: Launch the software and select the "Excel" option.
Step 3: Select the "Recover Password" mode.
Step 4: Click "Add" to import the password-protected Excel sheet into the software.
Step 5: Choose an attack type according to your situation. (PS: There are 4 attack modes to choose from. If you are not sure which mode to choose, you can read the introduction at the official website.)
Step 6: Click "Recover" to start the password recovery. Once the password is recovered, it will be displayed on the interface. Now you can directly click "Copy" to copy the password and open your Excel.
The steps to remove passwords for other common file types such as Word, PowerPoint, PDF, RAR, ZIP, etc. are the same and equally simple.
Key Features of iCrowbar
Recover passwords of Excel, Word, PowerPiont, PDF, RAR, ZIP, etc. and open with 100% success.
Remove restrictions of documents without losing data.
Recover Passwords with 4 Attack Modes and 10X faster speed.
Method 2: Remove Excel Password with Google Sheets
If you have a Google account, you can use Google Sheets (a free online application similar to Excel) to unprotect Excel sheets - even if you don't know the password.
Steps to Remove Password from Excel with Google Sheets:
Step 1: Open Google Drive and log in to your Gmail account. Click on the "New" tab and select "Google Sheets".
Step 2: At the left corner of the top of the screen, click on "File" and then "Import".
Step 3: Click on "Upload", upload the password-protected Excel sheet.
Step 4: Select "Replace Spreadsheet" and click on "Import Data". The protected Excel sheet will open in Google Sheets.
Step 5: Click on "Download As", then select "Microsoft Excel".
Step 6: Open the new Excel file, you will find your worksheet has not password anymore.
The uploading speed is slow and sometimes the loading process will be stuck if there are several worksheets in your Excel.
Method 3: Remove Excel Password with ZIP
This method helps you remove password protection from Excel worksheets, but it does not find out for you which password is being used.
Steps to Remove Password from Excel with ZIP:
Step 1: Right-click on the Excel file and select "Open with WinRAR or 7-Zip".
Step 2: Navigate to "xl\worksheets\".
Step 3: Find the Excel sheet you need to unlock. Right-click it and select the "Edit" option.
Step 4: Press CTRL+F to find the text "sheet Protection". Delete everything between the < > tags.
Step 5: Save the file and close the editor. Now, your worksheet is not protected.
There is no guarantee that this method will work with all versions of Excel.
Method 4: Remove Excel Password with VBA Code
This method requires you to be computer savvy and knowledge of code, as using VBA code to unlock Excel passwords can be a bit complicated and difficult for non-technical people.
Steps to Remove Password from Excel with VBA Code:
Step 1: Open the Excel file that needs to be decoded. Press the Alt + F11 key to open the VBA window.
Step 2: Click "Insert" in the toolbar. Select "Module" from the options.
Step 3: Copy the VBA code below and paste it into the VBA window.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Step 4: Press the F5 key and Excel will run the code. This may take a few minutes.
Step 5: When the code is done running, the password will be displayed in the pop-up window. Now you can use it to unlock your Excel worksheet.
1. This method only works with Excel 2010/2007 and earlier versions. It does not work if you need to hack Excel 2013/2016/2019 or later.
2. This method only works for a single worksheet. If you have multiple Excel worksheets that need to be decoded, you need to run VBA code for each worksheet one by one.
Method 5: Remove Excel Password Online
If you prefer to decrypt Excel files online for free instead of using any auxiliary software, then this method is for you. However, it should be noted that the free versions of these online decryption tools generally only support unlocking Excel files of small size.
Steps to Remove Password from Excel online:
Step 1: Go to the LostMyPass official website .
Step 2: Select " Excel" from the "File Type" drop-down menu.
Step 3: Import the password-protected Excel file.
Step 4: The password cracking process will run automatically.
The method of decrypting Excel through online tools requires you to upload the file to a public server, which may expose you to the risk of data leakage. Therefore, it is not recommended to use this method if your Excel sheet contains any business information or important private data.
This article presents the top 5 best Excel password removal methods in 2023 to unlock Excel worksheet password protection. Now the only thing you need to do is to choose the one that suits you best according to your actual situation and preference. After our tests, it is obvious that iCrowbar is the best Excel password remover to help you unlock Excel worksheets/workbooks without a password. If you don't have time to try which method can be 100% successful, then we suggest you to use this professional Excel password remover - iCrowbar without hesitation!