How to Remove Password from Excel? [2023 Newest]

admin
Barton

Apr 12, 2023 (Updated: Apr 12, 2023) • Filed to: Unlock Document

48K views, 5 min read

0

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.

Win : Download Now

Secure Download For Win

Mac : Download Now

Secure Download For Mac

Step 2: Launch the software and select the "Excel" option.

select-file-type

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.

recover excel password 2

Tips

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

logo icrowbar

5,000,000+

Downloads

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

  • Win : Download Now

    Secure Download For Win

    Mac : Download Now

    Secure Download For Mac

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

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.

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.

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.

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.

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.

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.

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

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!

Win : Download Now

Secure Download For Win

Mac : Download Now

Secure Download For Mac

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!

Contact Us