You can remove an Excel password in minutes using the same program that created it

If you have forgotten the password to an Excel file or inherited a locked spreadsheet from someone else, you can remove it without special software. Excel lets you save the file without a password using the same steps you would use to change any other file setting. The method depends on which version of Excel you use — desktop Excel, Excel Online, or an older version — but all of them work the same way: open the file, enter the password when prompted, then save it again without password protection.

This guide covers the most common scenarios: removing a password you remember, removing a password you do not remember (which requires a different approach), and what to do if you are working with an older Excel file format.

Key Takeaways

  • If you remember the password, open the file, go to File > Info > Protect Workbook, and choose the option to remove password protection, then save.
  • If you do not remember the password, you will need to use a third-party tool or contact the person who created the file, because Excel does not have a built-in recovery method.
  • Excel Online (the free web version) does not let you remove passwords — you must use the desktop version of Excel or convert the file format.
  • Removing a password from an Excel file you own is legal; removing one from a file you do not own without permission is not.

Removing a password you remember in desktop Excel

Open Excel and select the file. When the password dialog appears, type the password and click OK. The file will open normally.

Once the file is open, click the File tab at the top left. Select Info from the menu on the left side. Look for a button or option labeled "Protect Workbook" — the exact wording varies by Excel version, but it will mention protection. Click it and select the option to remove password protection or unprotect the workbook. You may see a dialog asking you to confirm; if so, click OK.

Now save the file. Use Ctrl+S (Windows) or Command+S (Mac), or go to File > Save. The file will save without password protection. The next time you open it, no password will be required.

Removing a password you do not remember

If you do not remember the password, Excel itself cannot recover it. Excel passwords are designed to be difficult to crack, and Microsoft does not have a master key or recovery process. You have three realistic options: contact the person who created the file and ask for the password, use a third-party password recovery tool, or recreate the spreadsheet from a backup copy.

Third-party tools exist that claim to remove Excel passwords, but they vary widely in reliability and safety. Some work by attempting to crack the password through repeated guessing; others exploit known weaknesses in older Excel versions. Tools like PassFab for Excel, Stellar Repair for Excel, and others are available online, but using them carries a small risk — you are downloading software from outside Microsoft, and you should scan any tool with antivirus software before running it. Read user reviews and check whether the tool is from a company with a track record before downloading.

The safest option is to contact whoever sent you the file and ask them to remove the password before sending it again. If that is not possible and the file is important, a password recovery tool is a reasonable choice — just download from the official website of the company that makes it, not from a third-party download site.

Removing a password in Excel Online

Excel Online (the free web version you access through Office.com or Outlook) does not have a built-in way to remove passwords. If you try to open a password-protected file in Excel Online, it will ask for the password, but once open, the protection settings are not available to change.

If you only have access to Excel Online, download the file to your computer, open it in desktop Excel, remove the password using the steps above, and then re-upload it. If you do not have desktop Excel installed, you can download a free trial from Microsoft's website, or you can ask someone with desktop Excel to remove the password for you.

Removing passwords from older Excel file formats

Excel files come in different formats: .xlsx (the current standard), .xls (older versions), and others. The steps above work for .xlsx files in Excel 2010 and later. If you have an .xls file from Excel 2003 or earlier, the process is slightly different.

Open the file in Excel. Go to Tools > Protection > Unprotect Sheet or Unprotect Workbook (the exact menu path depends on your version). Enter the password if prompted. Save the file using File > Save. If you are using a newer version of Excel to open an old .xls file, Excel will usually convert it to .xlsx automatically, and you can then use the File > Info > Protect Workbook method described above.

What to know about password protection and legality

Removing a password from a file you own or have permission to modify is straightforward and legal. If someone sent you a file and asked you to remove the password, that is fine. If you inherited a file from a colleague or found one on a shared drive, removing the password is usually acceptable in a workplace context — check with your manager or IT department if you are unsure.

Removing a password from a file you do not own and do not have permission to modify is not legal in most places. If you are trying to access someone else's file without their knowledge, that crosses into unauthorized access, which can have legal consequences. If you need access to a file someone else created, ask them directly.

What happens after you remove the password

Once you save the file without a password, anyone who opens it will be able to view and edit it without entering anything. If the file contained sensitive information and you are sharing it with others, removing the password means that information is now visible to anyone who has the file. Consider whether you need to add a different kind of protection — for example, you could mark certain cells as read-only, or you could use file-level encryption through your operating system or cloud storage provider.

If you are removing the password because you forgot it and plan to set a new one, you can do that immediately after removing the old one. Open File > Info > Protect Workbook again and choose the option to set a password. Enter a new password twice to confirm it, then save the file.

Frequently Asked Questions

Can I remove an Excel password without opening the file?

No. You must open the file and enter the password first. Excel does not let you change protection settings on a file you cannot open. If you do not remember the password, you will need to use a third-party tool or contact the person who created the file.

Will removing the password damage the file or lose any data?

No. Removing password protection does not change the spreadsheet itself — all your data, formulas, and formatting stay exactly as they were. You are only removing the lock that prevents opening or editing the file.

Is there a master password for Excel files?

No. Microsoft does not have a master password or backdoor for Excel files. If you forget a password, your only options are to contact the person who set it, use a third-party recovery tool, or recreate the file from a backup.

Can I remove a password from an Excel file on my phone or tablet?

The Excel app for iPhone and iPad can open password-protected files, but it does not have the option to remove the password. You will need to use a computer with desktop Excel or Excel Online to remove it.

What if the file is corrupted and I cannot open it even with the correct password?

Try opening the file in a different version of Excel, or use the Open and Repair feature in Excel (File > Open > Browse, then right-click the file and select Open and Repair). If that does not work, a file repair tool like Stellar Repair for Excel may help, though there is no may provide it will recover a corrupted file.