Skip to main content

Remove Watermark from Excel in Make

Remove Watermark from Excel is a shape-deletion operation that targets specific named shapes in an Excel workbook - or removes all shapes from selected worksheets - and returns a cleaned workbook ready to distribute. PDF4me performs exact-match deletion by shape ID so charts, images, and other content are preserved when you specify the watermark name precisely. For background on Excel shapes and the Selection Pane, see Microsoft Excel Selection Pane documentation and Open XML SDK shapes reference.

What this module does

PDF4me Excel, Remove Watermark deletes watermark shapes from Excel workbooks automatically inside Make scenarios. Provide the exact shape name from the Excel Selection Pane to remove only that watermark while leaving charts, images, and drawings intact. Leave Watermark ID empty to clear all shapes from targeted worksheets. Target specific tabs by name or index, or process the entire workbook. The cleaned workbook is returned immediately - no manual Excel editing required.

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

Every PDF4me module in Make requires a valid Connection. Create or select one that holds your PDF4me API key so the scenario can authenticate watermark removal requests securely.

Important Facts You Should Not Miss

Watermark ID performs exact case-sensitive match
The Watermark ID field matches the shape Name property exactly as shown in the Excel Selection Pane (Home → Find & Select → Selection Pane). The match is case-sensitive. If you enter "DRAFT_WM", it will not match "Draft_WM". Always copy the name directly from the Selection Pane to avoid mismatches.
⚠ Empty Watermark ID removes ALL shapes
When Watermark ID is left empty, the module removes every shape from targeted worksheets - including charts, images, drawings, and text boxes, not just watermarks. Use this setting only when you intentionally want to clear all shapes from a sheet. For selective removal, always specify the shape name.
Worksheet targeting uses union of Names and Indexes
When both Worksheet Names and Worksheet Indexes are provided, the module processes the union - all tabs matched by either list. Leave both empty to apply removal to every worksheet in the workbook. Worksheet Indexes are 1-based: index 1 is the first tab, index 2 is the second.
Make PDF4me Excel Remove Watermark module showing File Name and Document mapped from prior module, Watermark ID field, and Worksheet Names array

File Name and Document are mapped from a prior download module. Watermark ID accepts the exact shape name from the Excel Selection Pane.

Parameters

Required: Connection, File Name, and Document must be provided. Watermark ID, Worksheet Names, Worksheet Indexes, and Culture Name are optional - leave Watermark ID empty only if you intend to remove all shapes.

ParameterRequiredWhat it doesExample
ConnectionRequiredPDF4me API connection. Click Add and paste your API key if connecting for the first time.Your PDF4me connection
File NameRequiredExcel filename with extension (.xlsx or .xls). Map from the prior download module output.report.xlsx
DocumentRequiredBinary Excel buffer from a cloud storage download (Google Drive, Dropbox, SharePoint), email attachment, or HTTP response.1. Data
Watermark IDConditionalExact shape name to delete (case-sensitive, matches the Name property in the Excel Selection Pane). Leave empty to remove ALL shapes from targeted worksheets - use with caution.CONFIDENTIAL_WM
Worksheet NamesConditionalArray of exact worksheet tab names to target (case-sensitive). Combined with Worksheet Indexes as a union. Leave both empty to process all worksheets.["Sheet1","Summary"]
Worksheet IndexesConditionalArray of 1-based worksheet tab indexes to target. Index 1 is the first tab. Combined with Worksheet Names as a union. Leave both empty to process all worksheets.[1,3]
Culture NameConditionalLocale code for text rendering during processing. Defaults to empty (system default). Set to match the source file locale if regional characters are present.en-US

Output

FieldTypeWhat it contains
NameStringOutput Excel filename with extension.
Doc DataBufferThe cleaned Excel workbook as a binary buffer with the targeted watermark shapes removed. Pipe directly into a Google Drive upload, SharePoint save, email attachment, or any module that accepts a file buffer.

How to Remove a Watermark from Excel in Make

  1. Add PDF4me ExcelRemove Watermark to your Make scenario.
  2. Select Connection (or click Add to create one with your API key).
  3. Map File Name and Document from a prior cloud storage download or HTTP module.
  4. Enter Watermark ID: open the Excel file, go to Home → Find & Select → Selection Pane, and copy the exact shape name. Paste it here.
  5. Optionally list Worksheet Names or Worksheet Indexes to restrict removal to specific tabs. Leave both empty to process all worksheets.
  6. Click Save and run. The Doc Data output is the cleaned workbook - pipe it into an upload or email module.

When Should I Use Remove Watermark from Excel?

When Should I Use Remove Watermark from Excel?Common Make scenario patterns using Remove Watermark.
Remove DRAFT watermark on document approval
  1. An approval webhook triggers when a document is marked "Approved" in your workflow system.
  2. Google Drive downloads the Excel workbook containing the DRAFT watermark shape.
  3. Remove Watermark runs with Watermark ID set to the exact shape name (e.g. "DRAFT_Watermark") - only that shape is deleted.
  4. The cleaned workbook is uploaded to the final distribution folder and stakeholders are notified by email.
Strip internal watermarks before client delivery
  1. A scheduled trigger or webhook fires when a deliverable is marked ready for the client.
  2. SharePoint downloads the workbook. Watermark ID is set to "INTERNAL_ONLY_WM" to remove only the internal watermark.
  3. Worksheet Indexes targets only the client-visible sheets (e.g. [1, 2]), preserving watermarks on internal archive tabs.
  4. The sanitized workbook is uploaded to the client portal and logged in the delivery tracker.
Clear all shapes during template refresh
  1. An annual template refresh scenario downloads each Excel template from Dropbox.
  2. Remove Watermark runs with Watermark ID left empty and Worksheet Names set to ["Cover", "Summary"] - all shapes on those two tabs are cleared.
  3. An Add Watermark module adds the updated brand watermark to the same sheets.
  4. The refreshed template is saved back to Dropbox and the template library index is updated.

Frequently Asked Questions

What happens if I leave Watermark ID empty?+
Every shape on the targeted worksheets is removed - including charts, images, drawings, and text boxes, not just watermarks. This is a destructive operation on all shapes. Use it only when you deliberately want to clear all shapes from a sheet. For selective removal, always specify the exact shape name in Watermark ID.
How do I find the exact shape name to use as Watermark ID?+
Open the Excel file on your desktop. Go to Home → Find & Select → Selection Pane. All shapes on the active worksheet are listed by their Name property. Copy the exact name (it is case-sensitive) and paste it into the Watermark ID field in your Make module.
Can I remove watermarks from specific worksheets only?+
Yes. Use Worksheet Names to list exact tab names (e.g. ["Sheet1", "Summary"]) or Worksheet Indexes for 1-based positions (e.g. [1, 3]). When both are provided, the module processes the union of both lists. Leave both empty to apply removal to every worksheet in the workbook.
What does the module return and how do I use the output?+
The module returns two fields: Name (the output filename as a string) and Doc Data (the cleaned Excel workbook as a binary buffer). Map Doc Data into a Google Drive upload, SharePoint save, email attachment, or any downstream module that accepts a file buffer.
Is shape name matching case-sensitive?+
Yes. Watermark ID matching is exact and case-sensitive. The shape name "DRAFT_WM" will not match "Draft_WM" or "draft_wm". Open the Selection Pane in Excel to see the exact casing, and copy it precisely to avoid a no-match result where the watermark remains in the output file.

Get Help