Split CSV into multiple sheets

Split CSV into multiple sheets breaks a large CSV into a series of smaller files, each with the same header row. This is useful when a downstream system, delivery target, or teammate expects files under a certain row count.

Availability: GA

What it does

Input: one or more CSV lists.
Output: the same data, divided into multiple CSV files. Every output file keeps the original header row, and rows are distributed in order, filling each file up to the configured row limit before starting the next one.

When to use it

A downstream delivery target or API rejects files above a certain row count.
You want to parallelize downstream processing (for example, running an AI transform on smaller batches).
A partner requires files chunked into a specific size for their import tooling.

How to configure it

In the Multi FileFeed (MFF) builder, add a Split CSV into multiple sheets node after the node that produces your CSV list.

Settings

Setting	Description	Default
Max rows per file	The maximum number of data rows (not counting the header) allowed in each output file. Once a file reaches this limit, the transform starts a new file with the same header row.	2000

Example

Input

A single CSV with 5,000 rows of order data and a header row.

Output

Three CSV files, each with the same header row:

file_1.csv — 2000 rows
file_2.csv — 2000 rows
file_3.csv — 1000 rows

Troubleshooting

I expected fewer or more output files

Check the Max rows per file setting. Lower the value to produce more, smaller files, or raise it to produce fewer, larger files.

Output files are missing the header row

Confirm the input CSV itself has a single, consistent header row. If the input list already has inconsistent headers across files, fix that upstream before splitting.