Why split a file
An import accepts 100,000 rows at a time; an upload form takes 10 MB; Excel stops at 1,048,576 rows; a colleague only needs this month. Splitting cuts the file into pieces that are each a complete table.
Splitting in Intact CSV Editor
- Open the file. Filter or sort first if the pieces should follow an order.
- Choose File ▸ Split into Several Files and set the number of rows per piece.
- Pick a folder. The pieces are written as
name-01,name-02… so they sort in order.
Every piece keeps the column names and is written in the file's own separator, quoting, encoding and line endings, so each opens anywhere as a table in its own right.
Taking out just the rows you need
If you need one part rather than equal pieces, filter the rows — by condition, by a column's values, by a pattern — and extract the rows shown to a new document. Or export the filtered rows directly to any format.
On the command line
split -l 100000 big.csv part- splits by lines, but the pieces after the first have no header row, and a
value with a line break inside it is cut in two. Tools such as qsv split handle both; Intact CSV Editor does it
with a sheet and a preview.
Try it on your own file
Intact CSV Editor is free for seven days, fourteen with an account — every feature, no card. Download the free trial.
