For the complete documentation index, see llms.txt. This page is also available as Markdown.

Split Sheets

Divide CSV or Excel data into smaller groups of rows. Use it to process a large table in parts while keeping each worksheet separate.

Use this tool

  1. Supply File URL for the CSV or Excel file.

  2. Choose Split Mode and enter Number of Rows or Number of Chunks.

  3. Keep Include Headers enabled if each group needs its column names.

  4. Run the tool and inspect Chunks, grouped by worksheet name.

Behavior and limits

Headers are additional to the data-row limit. Each Excel worksheet is split separately; a CSV uses the name Sheet1. The returned chunks are CSV text grouped by sheet, not a single newly created Excel workbook.

Inputs

Field
Parameter
Description

File URL (required)

file_url

URL of the CSV or Excel file to be split

Split Mode (required)

split_mode

Choose how to split: by number of rows per chunk or by total number of chunks

Number of Rows

num_rows

Number of data rows per chunk when using Number of Rows split mode. Headers are additional and not counted toward this limit. For example, if num_rows=5 with headers enabled creates chunks of 6 rows (1 header + 5 data). Default is 100 rows per chunk. Must be at least 1.

Number of Chunks

num_chunks

Total number of chunks to create when using 'num_chunks' split mode. Default is 5 chunks. Must be between 1 and 200.

Include Headers

include_headers

Whether to include the header row in each chunk. When enabled, each chunk will start with the column headers as an additional row. Headers are not counted toward the number of rows limit. Default is true.

Outputs

Field
Parameter
Description

Chunks

chunks

Dictionary mapping sheet names to their CSV chunks. For CSV files, uses 'Sheet1' as the key. For Excel files, each worksheet is processed separately with its sheet name as the key.

Was this helpful?