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
Supply File URL for the CSV or Excel file.
Choose Split Mode and enter Number of Rows or Number of Chunks.
Keep Include Headers enabled if each group needs its column names.
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
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
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.
Related guides
Was this helpful?

