DataMimiDataMimi

Unprotect an Excel Sheet

Lift the sheet and workbook editing lock from your own .xlsx, so its cells and sheets can be changed again.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Unprotect an Excel Sheet

  1. 1Select your file, or drop it on the page
  2. 2Run it — nothing to set up
  3. 3Download unprotected.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

How do I unprotect an Excel sheet?

Upload the .xlsx and download it with the sheet protection and the workbook structure lock removed. Cells, formulas and formatting stay as they were.

Can it open a file that asks for a password to open?

No. That file is encrypted, which is real security, and it is refused. Only the editing lock on sheets — which is not encryption — is removed.

Is this allowed?

Use it on files that are yours or that you have the right to edit, such as an old template whose password was lost.

Does it keep macros?

An .xlsm keeps its macros.

More Excel tools

See all