Icon

Excel - Merge Multiple Sheets

<p>List Excel Files and convert them into sheets of a collected file</p>

URL: adapted from example by Gene Feigel https://community.knime.com/c/ask-the-community/how-do-i-merge-multiple-smaller-single-sheet-excel-files-with-different-columns-into-one-large-excel-workbook-with-each-one-of-those-smaller-files-being-one-sheet-of-the-new-workbook#comment_wrapper_115624522
URL: Medium Blog: KNIME and Excel — An Overview of What You Can Do https://medium.com/low-code-for-advanced-data-science/knime-and-excel-an-overview-of-what-you-can-do-c6d400319745
URL: KNIME Community https://community.knime.com/c/ask-the-community/how-do-i-merge-multiple-smaller-single-sheet-excel-files-with-different-columns-into-one-large-excel-workbook-with-each-one-of-those-smaller-files-being-one-sheet-of-the-new-workbook#comment_wrapper_115636278
URL: Medium Blog: KNIME — Cases, Switches and Catching Errors https://medium.com/low-code-for-advanced-data-science/knime-cases-switches-and-catching-errors-5ab748cbeaa3

List Excel Files and convert them into sheets of a collected file

https://community.knime.com/c/ask-the-community/how-do-i-merge-multiple-smaller-single-sheet-excel-files-with-different-columns-into-one-large-excel-workbook-with-each-one-of-those-smaller-files-being-one-sheet-of-the-new-workbook#comment_wrapper_115636278

/data/*.xslx
List Files/Folders
Table Row to Variable Loop Start
convert path to string
Path to String (Variable)
Shift - F6 - Edit Variable settingsextract the sheet name usedinto Flow Variable"v_sheet_name"
Excel Reader
knime://knime.workflow/data/output/Output.xlsx1st iteration => overwrite
Excel Writer
Extract the file name and extension
URL to File Path (Variable)
v_sheet_nameclean up the name andadd the file name
Variable Expression
Variable Loop End
if($$["currentIteration"]=0,0,1)Detect if the current loop iteration is the first one to steer the CASE switch"v_select_port"
Variable Expression
first iterationhandled differently"v_select_port"
CASE Switch Start
knime://knime.workflow/data/output/Output.xlsxother iterations => append
Excel Writer
CASE Switch End

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Owner
Created at: 2026-09-25
On NodePit since: 2026-09-27
Last update: 2026-09-27
Created with KNIME version: v5.12.0
Tags: ExcelmergeSwitchcasesheet

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!