CSV Splitter - Split your CSV files into smaller files (Updated Oct 2026)
Description
CSV Splitter provides a straightforward solution for managing large CSV (Comma Separated Values) files by dividing them into multiple smaller files. This is particularly handy for handling files that are gigabytes in size, letting you break them down into more manageable chunks. Add one CSV file or a whole batch, specify the number of records per split file, and the tool creates the smaller files for you, numbering each part so they stay in order.
You get useful control over the details: repeat the header row at the top of every output file so each part is self-describing, choose the delimiter and text encoding, and set your own filename prefix (auto-filled from the source name). A
Preview reports each file's size, line count, data rows, detected delimiter and how many output files it will produce before you commit, and while the split runs a progress bar and activity log show exactly what's happening — you can cancel at any time and jump straight to the results with
Open Folder.
How to use
1. Click
Add File(s)… and choose the CSV file (or files) you want to split. The output folder and filename prefix are filled in automatically from the first file — use
Remove to drop a selected file from the list.
2. Check the
Output Folder (click
Browse… to change it), set
Records per File to how many data rows each part should contain, and adjust the
Filename Prefix if you want.
3. Set the options to match your data: tick
Include header row in every output file so the first row is repeated at the top of each part, and pick the
Delimiter and
Encoding if the defaults (auto-detect / UTF-8) don't suit your file.
4. (Optional) Click
Preview to see, in the activity log, each file's size, line count, data rows, detected delimiter, and how many output files it will produce at your current settings — a quick sanity check before you split.
5. Click
Split CSV and wait for the files to be created. The progress bar and activity log show each part as it's written; click
Cancel to stop early, or
Open Folder when it's done to view the results.
Clear resets everything for the next job.
Split files are saved with your filename prefix and a numbered part suffix. For example, a file split with the prefix "Example" produces Example_Part_01.csv, Example_Part_02.csv and so on until the file has been completely split. When you add several files at once (batch mode), each source file is split using its own name as the prefix.
Run it automatically with Watch and Process
Have every large CSV file that arrives in a folder split into smaller files automatically, with the header row copied into each part — without opening this window.
How to set it up:
1. Open
Watch and Process Automation, type a
Task Name and pick the
Watch Folder with
Browse… — the folder your files arrive in.
2. In
File Types type
*.csv.
3. Click
Add FW Tool…, choose
CSV Splitter and set the
Rows in each part, tick
The first row is a header if it is, choose whether to
Put the parts in their own folder, and where to
Save the result. The line
What this step will do at the bottom of the window sums up your choices. Click
OK.
4. Click
Add Task, select the task and click
Start Watching. From now on every new file is handled within a few seconds, while the Watch and Process window is open (it can be minimised).
Example: A website export
orders.csv with 2,501 orders, but your accounting program only imports 1,000 rows at a time. With 1,000 rows in each part, the task makes a folder
orders (parts) with
orders_Part_01.csv and
orders_Part_02.csv (1,000 orders each) and
orders_Part_03.csv (501), each starting with the header row.
Good to know: Files that already fit in one part are skipped. The parts keep the file's character encoding. Rows are split line by line, the same as this window, so a value that contains a line break inside quotes may end up split across two lines. The original file isn't changed, and the parts are never split again.