Excel Plus icon

Excel Plus

Work with Excel files. Currently supports merging sheets from multiple workbooks.

Merge Sheets

AI-generated

Summary

Merge the worksheets from Excel files received on the configured input connections into one .xlsx workbook. Resolve duplicate sheet names by adding counters or by prefixing each sheet with its source file name.

Inputs

  • Number of Inputs — Sets how many input connections (1–20) the node reads; reconnect upstream nodes after changing it. Defaults to 2.
  • Binary Field Mode — Choose whether every input uses one shared binary-property name or each input uses its own name.
  • Binary Field Name (required) — The binary property containing each incoming Excel file when using the shared-field mode; defaults to data.
  • Binary Field Names per Input (required) — A JSON object mapping each configured input number ("1", "2", and so on) to the binary property that contains its Excel file.
  • Sheet Name Conflict — Either add (1), (2), and so on to duplicate sheet names, or prefix every sheet name with its source file name without its extension.
  • Options → Output File Name — Name for the merged workbook; defaults to merged.xlsx. The .xlsx extension is added when omitted.

Output shape

A single n8n item containing the merged Excel workbook as binary data.

The workbook contains copied sheets from the input workbooks. Sheet names are sanitized and made unique according to the selected conflict strategy.

Links

Discussion