How to Remove Password from Excel? [2023 Newest]

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

• Method 2: Remove Excel Password with Google Sheets

• Method 3: Remove Excel Password with ZIP

• Method 4: Remove Excel Password with VBA Code

• Method 5: Remove Excel Password Online

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.

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.

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.

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.

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.

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.

Conclusion

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!