Split CSV by column value
Pick the column that decides the groups. The sample column is group, with values a and b.
This split follows the text of one column. It does not group by row count or by file size.
🔒 Your files stay in your browser and are never uploaded
If Excel asks to remove leading zeros, click "Don't Convert" to keep them.
- Load the sample or your own file.
- By column value is already selected.
- Run. You should see one part for each distinct value.
Common problems
This split follows one column and makes one file for each distinct value. The sample column is group, with the values a and b, so you should see two parts after the run. Blank cells in that column share one part. They are not dropped and they are not mixed into the other values. Every downloaded file starts with the same header, so each part can be opened on its own. This is not a split by row count and not a split by megabytes. If the column you care about is not the first one, change the column menu before you start. The part list shows how many data rows each file has.
What if the value is blank?
Blank cells share one part.
Is the header repeated?
Yes. Each downloaded file starts with the same header.