Skip to main content
PDF4me APIIntegrationsKnowledge BaseExtensionsAPI TesterBlog

Unlock Excel in Zapier

PDF4me Unlock Excel is a Zapier action that removes password protection from Excel files across all three protection layers, file encryption, workbook structure locks, and worksheet content locks, in a single step. Use it to edit protected templates, unlock archived files for reuse, or clear passwords before merging spreadsheet data. It returns the unlocked file for the next Zap step.

What this action does

Takes a protected Excel workbook from a previous Zap step and removes each protection layer you supply a password for: Secure On Open Password (file encryption), Workbook Protection Password (sheet structure), and Worksheet Protection Password (cell content). If more than one password is provided, the action tries them in logical order for each layer rather than requiring an exact match for a specific field. Target specific sheets with Worksheets-By Name or Worksheets-By Index, or leave both empty to unlock the whole workbook.

Related Blog Posts
No blog post yet for this feature — coming soon.
In the meantime, browse the PDF4me blog for tutorials and workflows across every platform.
Visit the blog →

Authenticating Your API Request​

To access the PDF4me Web API through Zapier, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Zapier workflows and PDF4me's Excel unlocking services.

Get your API Key

Important Facts You Should Not Miss​

Only File is required
File Name, every password field, worksheet-targeting fields, and Culture Name are all optional in the Zapier configuration.
This is not a password-recovery tool
The action removes protection using passwords you supply. It tries multiple supplied passwords in order per layer, but it does not crack or guess an unknown password.
Three independent protection layers
File encryption, workbook structure locks, and worksheet content locks each use their own password field and are removed independently.
Map File and File Name from previous steps

Use the + button next to File and File Name to map from earlier Zap steps. You can use File Url and Full File Name from a previous PDF4me Excel action, such as Secure Excel.

File: (Exists but not shown)

If you see "File: (Exists but not shown)" in the File field and get errors, select the option that provides the full file content instead. See Zapier & Power Automate Tips for details.

PDF4me Excel Unlock Workbooks Zapier configuration - File, File Name, Secure On Open Password, Workbook Protection Password, Worksheet Protection Password, Worksheets-By Name, Worksheets-By Index, Culture Name
Only File carries an asterisk. Every password field, worksheet-targeting field, and Culture Name are optional.

What Are the Key Features of Unlock Excel?​

  • Three-Layer Unlocking: Secure On Open Password, Workbook Protection Password, Worksheet Protection Password
  • Intelligent Password Fallback: tries supplied passwords in logical order for each layer
  • Worksheet Targeting: Worksheets-By Name or Worksheets-By Index, leave empty for all
  • Culture Support: Culture Name for region-specific processing

Parameters​

Complete list of parameters for the Unlock Excel action. Parameter names match the Zapier configuration UI shown in the screenshot above.

Quick setup checklist
  1. Map File (Excel) and File Name from a previous step
  2. Set Secure On Open Password if the file is encrypted to prevent opening
  3. Set Workbook Protection Password and Worksheet Protection Password if those layers are applied
  4. Optionally set Worksheets-By Name or Worksheets-By Index; leave empty for all sheets
ParameterRequiredWhat it doesExample
FileRequiredProtected Excel file to unlock. Map from a previous step. Must provide full file content.[19. File Url]
File NameConditionalExcel filename, used for output file identification.merged_rows.xlsx
Secure On Open PasswordConditionalPassword to open the encrypted file. Removes file-open encryption.1234
Workbook Protection PasswordConditionalPassword for the workbook structure lock. Removes the sheet add/delete/rename restriction.12345
Worksheet Protection PasswordConditionalPassword for the worksheet content lock. Removes the cell-editing restriction.123456
Worksheets-By NameConditionalComma-separated worksheet names to target. Empty targets all worksheets.Sheet1, Summary
Worksheets-By IndexConditionalComma-separated 0-based worksheet positions to target. Empty targets all worksheets.0, 1, 2
Culture NameConditionalLocale used when processing region-specific number and date formats.en-US
Provide only the passwords the file actually has

Leave a password field empty if that protection layer was never applied. Supplying an incorrect password for a layer that does not exist has no effect; the action only removes protection that is present and matched.

Important: Only File is required. Provide a password for each protection layer the file actually has, the action tries them in logical order if more than one candidate password is supplied.

What Does Unlock Excel Return?​

The PDF4me Unlock Excel action returns the unlocked Excel file for use in subsequent Zap steps. The output format is common across all PDF4me Excel actions in Zapier.

File Url

API endpoint to download the unlocked Excel file. Map this to the next step's file input.

api.pdf4me.com/Zapier/GetDocument?d=...
Alternate File Url

Alternative download URL with the filename in the path.

api.pdf4me.com/Zapier/GetAltDocument/.../merged_rows.xlsx
FieldTypeWhat it contains
Job IdStringUnique identifier for the Zapier job execution.
File UrlURLAPI endpoint to download the unlocked Excel file.
Alternate File UrlURLAlternate download URL with the filename in the path.
File NameStringBase filename without extension.
File ExtensionStringFile extension of the returned file, e.g. .xlsx.
Full File NameStringComplete filename with extension.
Document IdStringUnique identifier for the processed document.
File SizeNumberSize of the output file in bytes.

Example JSON output (URLs show format only, not working links):

{
"Job Id": "969f2da3-f10a-49bf-b084-6fc4759991ec",
"File Url": "api.pdf4me.com/Zapier/GetDocument?d=...",
"Alternate File Url": "api.pdf4me.com/Zapier/GetAltDocument/.../merged_rows.xlsx",
"File Name": "merged_rows",
"Full File Name": "merged_rows.xlsx",
"File Extension": ".xlsx",
"Document Id": "07386627-184a-44b2-a040-5ea2712a4bc5",
"File Size": 212764
}
Same output for all PDF4me Excel actions

This output structure is shared across Unlock Excel, Secure Excel, Update Rows, and other PDF4me Excel actions in Zapier. The URLs are temporary, use them in the next step before they expire.

Typical Setups​

Workflow ExamplesCommon Zapier workflow patterns using Unlock Excel.
Protected template refresh
  1. A scheduled trigger fires when a recurring template refresh is due.
  2. PDF4me Unlock Excel maps File and File Name from the stored template and supplies the known Secure On Open and Workbook Protection passwords, leaving Worksheets-By Name and Worksheets-By Index empty to unlock every sheet.
  3. Update Rows inserts the current period's data into the now-editable template.
  4. PDF4me Secure Excel re-applies protection with a new password before the file is saved back to the library.
Nightly protected master data sync
  1. A scheduled trigger runs a nightly data sync.
  2. PDF4me Unlock Excel maps the protected master data workbook from SharePoint, supplies its Secure On Open Password from a secure vault, and sets Worksheets-By Name to the specific sheets that need updating.
  3. Update Rows writes fresh records queried from the production database into the now-unlocked sheets.
  4. PDF4me Secure Excel re-applies the original protection before the file is uploaded back to SharePoint.
Archive preparation
  1. A trigger fires when a file moves into a long-term archive folder.
  2. PDF4me Unlock Excel maps the protected file and supplies whichever of the three passwords the file actually carries, leaving worksheet targeting empty to unlock the full workbook.
  3. The unlocked file is uploaded to cold storage, where archived files are kept accessible without password management overhead.

Practical Tips​

File: (Exists but not shown) causes errors
Select the mapping option that provides the file's full binary content instead of a reference. See Zapier & Power Automate Tips for the exact steps.
Only File is required
Every password field, both worksheet-targeting fields, and Culture Name are optional. Leave a password field empty if that protection layer was never applied.
One password field can cover a missing layer
If you only know one password, the intelligent fallback tries it against each protection layer, you don't need to duplicate it into every field.
Re-protect after editing
This action only removes protection. Pair it with the Secure Excel action afterward if the file needs to go back out with a password.
Not a password-recovery tool
Unlock Excel requires a correct password for each layer it removes. It cannot recover or guess an unknown password.

Cheat Sheet​

FieldValue
ActionUnlock Excel
File[Mapped from previous step]
Secure On Open Password1234
Workbook Protection Password12345
Worksheet Protection Password123456
Worksheets-By Name(empty for all)
Culture Nameen-US

Common Questions​

How do I unprotect an Excel worksheet automatically in Zapier?+
Add the PDF4me Unlock Excel action to a Zap, map the protected workbook from a previous step, and enter the Worksheet Protection Password that was used to lock the sheet. See Microsoft's guide to worksheet protection for how the native Excel feature works.
How do I unlock cells in Excel that are locked for editing?+
Cell locking is controlled by worksheet protection. Provide the Worksheet Protection Password in this action and the cell-editing lock is removed for the worksheets you target, or all worksheets if none are specified.
Can I unprotect an Excel workbook without knowing the password?+
No. This action removes protection using passwords you supply, it does not crack or recover unknown passwords. If multiple candidate passwords are provided, it tries them in order for each layer, but at least one supplied value must match the real password.
What is the difference between workbook protection and worksheet protection in Excel?+
Workbook protection locks the structure, preventing sheets from being added, deleted, hidden, or renamed. Worksheet protection locks the content of a specific sheet, preventing cell edits. See Microsoft's documentation on protected worksheet areas for the underlying concept. This action removes both layers independently, along with a separate file-open encryption password.
Does this action remove a read-only recommendation on an Excel file?+
This action targets password-based protection layers, encryption, workbook structure locks, and worksheet locks. A file-level read-only recommendation set without a password is a different setting and is not one of the three protection layers this action removes.

Same Task on Other Platforms​

Industry Use Cases & Applications​

  • Budget Template Updates: unlock protected budget templates for annual refresh and data updates
  • Financial Model Edits: remove protection from financial models for assumption updates
  • Archive Preparation: unlock quarterly financial files before long-term archive storage
  • Consolidation Updates: unlock entity templates for monthly consolidation data refresh
  • Audit File Access: unlock archived audit files for subsequent year reference

Get Help​

Zapier IntegrationGet your API KeyZapier Documentation