Group values are matched exactly
Tokyo and tokyo are separate groups, as are A and A . The tool does not trim or normalize the split values. Clean that column first if those variants are supposed to be one group.
Free web tool
Split a CSV into separate files for each distinct value in a selected column.
Split one CSV into separate files by store, owner, category, or another column value. Each output gets the original header and every row belonging to that exact group value.
Tokyo and tokyo are separate groups, as are A and A . The tool does not trim or normalize the split values. Clean that column first if those variants are supposed to be one group.
Rows with a blank split value are not discarded. They form a blank group. That can be useful for “unassigned” records, and it can also reveal missing data you did not expect.
Because group values become filenames, characters that are awkward in filenames are converted to underscores, long names are limited, and blank values get a generic base name. If different group labels sanitize to the same base—such as A/B and A:B—the later file gets a suffix such as _2 instead of overwriting the first.
If the split column contains customer segments, employee names, or another sensitive label, that value also becomes visible in the saved filename. Check filenames as well as file contents before placing them in shared folders.
Thousands of output files are hard to use safely, so this tool caps the operation at 50 groups. If you hit that limit unexpectedly, it is a useful signal to check for label variations or a wrong split column.