CSV table split into equal-sized blocks

People handling a large CSV table can divide it when their next step requires several blocks of the same size.

Split a CSV table into equally sized blocks, creating regular portions that are easier to distribute wherever the next task requires them.

How to use

On the first line, state how many rows each block should contain.
Add the expected separator, then paste the complete table while keeping its header row.
Run the cut and go through the blocks produced in the result area.
Take each portion separately, and check the row count of the last block, which is often shorter.
Rename or save each portion on its own if you plan to send them to different people.

Example

The sample asks for blocks of two rows taken from a short table of four cities. Look at how many blocks appear in the output, how the original rows are spread between them, and whether any row was lost along the way.

Input

2
--
id,city
1,Lyon
2,Nantes
3,Lille
4,Brest

Limits and formats

The split is driven by a row count, not by file size, so two blocks can end up weighing very different amounts.
A cell holding line breaks inside quotes can throw off the way rows are counted.
Make sure each portion still carries the header when you plan to reuse it alone in a spreadsheet.
Cells that contain the separator character need quotes, otherwise a row may be cut in the wrong place.

Where processing happens

Everything happens in your browser: the table is cut on the spot, with no upload, and your rows never leave your device.

Frequently asked questions

How are the rows counted in each block?

The number you enter applies to the rows of your table. When the total does not divide evenly, the final portion simply holds fewer rows than the ones before it, which is expected.

Can I split my file into a fixed number of files?

No, the split is driven by a block size rather than a target number of portions. To reach a given number of files, work out the rows per block first.

Can I download every portion at once?

The output appears as text that you copy block by block and then save wherever you like. There is no single archive holding all the portions in one download.