Icon

Auto_​Dataset_​Split

* Change output path to the location where you want to save the file.

* Add backslash (\) before each special character to ensure the path is recognized as a string.

Automated dataset split (into Excel files)

This workflow shows how to automatically split a large dataset into multiple smaller Excel files based on file size (row counts).

Sample File
Excel Reader
Count the # ofrows in the file
Counter Generation
Create Chunks
Expression
Group Loop Start
Table Row to Variable
String Manipulation (Variable)
String to Path (Variable)
Save each file through loop
Excel Writer
Variable Loop 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: Lzy
Created at: 2025-09-11
On NodePit since: 2025-09-12
Last update: 2025-09-12
Created with KNIME version: v5.7.0

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

Try NodePit Runner!