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

admin
Barton

Apr 12, 2023 (Updated: Nov 15, 2023) • Filed to: Unlock File

48K views, 5 min read

0

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!

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

WooTechy iCrowbar - Best Excel Password Remover

logoicrowbar

8,000,000+

Downloads

  • Password Recovery: Quickly recover passwords of Excel/Word/PowerPoint/PDF/ZIP/RAR to open locked files

  • Restriction Removal: 1 click to remove editing restrictions on Excel/Word/PowerPoint/PDF to edit and copy read-only files

  • Multilingual Password Available: More than 10 multi-language passwords are supported in addition to English

  • AI Technology: Built-in 4 advanced AI attack modes for 99% decoding success rate regardless of password strength

  • Unlimited Usage: No limit on the number of times to use, unlock files as many as you want

  • High Security: No file data will be damaged or lost, and no file content will be affected

  • Easy to Use: Unlock files in a few simple steps, no expertise required, friendly to non-technical people

  • 30-Day Money Back Guarantee: Instant refund within 30 days if the file cannot be unlocked

  • Win: Free Download

    Secure Download

    Mac: Free Download

    Secure Download

How to Remove Password from Excel via WooTechy iCrowbar?

Step 1. Download and install WooTechy iCrowbar on computer.

icrowbar

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

icrowbar-recover-password-2

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

recover excel password 2

Tips

The steps to unlock other common files such as Word, PowerPoint, PDF, ZIP, RAR are the same and easy too.

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

Remove-Excel-Password-with-Google-Sheets-1

Step 2. At the left corner of the top of the screen, click on "File" and then "Import".

Remove-Excel-Password-with-Google-Sheets-2

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.

Remove-Excel-Password-with-Google-Sheets-3

Step 5. Click on "Download As", then select "Microsoft Excel".

Remove-Excel-Password-with-Google-Sheets-4

Step 6. Open the new Excel file, you will find your worksheet has not password anymore.

Note

The uploading speed is slow and sometimes the loading process will be stuck if there are several worksheets in your Excel.

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

Remove-Excel-Password-with-zip-1

Step 4. Press CTRL+F to find the text "sheet Protection". Delete everything between the < > tags.

Remove-Excel-Password-with-zip-2

Step 5. Save the file and close the editor. Now, your worksheet is not protected.

Note

There is no guarantee that this method will work with all versions of Excel.

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

Remove-Excel-Password-with-VBA-1

Step 2. Click "Insert" in the toolbar. Select "Module" from the options.

Remove-Excel-Password-with-VBA-2

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

Remove-Excel-Password-with-VBA-3

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.

Note

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.

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

Remove-Excel-Password-online

Step 3. Import the password-protected Excel file.

Step 4. The password cracking process will run automatically.

Note

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.

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!

Win: Free Download

Secure Download

Mac: Free Download

Secure Download

Generally rated 4.4 (122 participated)

0 Comment(s)

Join the discussion!

success

Rated successfully!

tips

You have already rated this article, please do not repeat scoring!