How to Remove Password from Excel? [5 Best Excel Password Remover]

If you're here, you must forget Excel password and are looking around for how to remove password from Excel. Luckily, your search is over because you've come to the right place! We tested some popular Excel password removal methods and picked out 5 best Excel password remover, either one of them can help you remove Excel password quickly and efficiently! Let's get started!

5 Best Excel Password Remover [2023]

• [No.1] Remove Password from Excel with iCrowbar

• [No.2] Remove Password from Excel with Google Sheets

• [No.3] Remove Password from Excel with ZIP

• [No.4] Remove Password from Excel with VBA Code

• [No.5] Remove Password from Excel Online

[No.1] Remove Excel Password with WooTechy iCrowbar

It can be said that WooTechy iCrowbar is the most effective Excel password remover on the market today. With advanced AI technology and 4 powerful attack modes, it can help you quickly recover password and unlock Excel regardless of the length and complexity of the password. Now this all-in-one professional file unlocker has been highly recognized by a large number of media and users.

How to Remove Password from Excel via WooTechy iCrowbar?

Step 1. Download and install WooTechy iCrowbar on computer.

Step 2. Upload the password-protected Excel file, select a recovery method and click Recover.

Step 3. The recovered password will be displayed on the interface, enter or copy the password to open the Excel file.

[No.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.

How 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.

[No.3] Remove Excel Password with ZIP

You can remove password protection from Excel worksheets with the help of ZIP, but note that it will not find out the password for you, it simply does the job of removal.

How 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.

[No.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 will be a bit complicated and difficult for non-technical people.

How 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.

Sub PasswordRecovery()
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)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

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.

[No.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.

How 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.

Conclusion

Well, this post shares the top 5 best Excel password remover for 2023, and either one of these tools will help you to remove Excel password. So, now the only thing you need to do is to choose the one that suits you best according to your reality and preference!

After our testing, it is obvious that WooTechy iCrowbar is the best Excel password remover to help you recover Excel password and unlock password-protected Excel worksheets/workbooks. If you don't have time to try which one can unlock your Excel files 100%, then don't hesitate, just choose WooTechy iCrowbar!