Split a CSV into One File per Column Value

Steps

1. Open the Split CSV tool and load the file.
2. Select the option to split by a column's values.
3. Pick the column to group on from the list of headers.
4. Run the split. Each distinct value becomes its own file inside the zip, named after your file and the value, such as orders-West.csv.
5. Spot check a couple of files to make sure each one only holds rows with its value.

Good to know

Tidy the grouping column first

Grouping is exact, so values that differ only in spacing or capitals, like "North" and "north ", stay separate groups. Cleaning that column beforehand gives you fewer, cleaner files. Quotes in the middle of a cell are read as ordinary text; only a leading quote opens a quoted cell. Should a warning say the file finishes with a quote still open, compare rows in against your expectations.

File names

Characters that are not allowed in file names, accented letters included, become an underscore. Spaces, dots and underscores at the ends are trimmed, and the value part of each name is cut to 60 characters. When two values end up with the same name, the later one gets a -2 suffix, so the North and north groups above arrive as orders-North.csv and orders-north-2.csv. There are no naming options in this version.

Empty cells

Rows where the chosen column is empty land in a file of their own ending in -(empty), and a value made only of spaces gets its own file, separate from that one, while a real value of "blank" gets -blank. A value with no usable characters at all, such as "???", goes to -(other). Look at these files before discarding them.

Splitting by month

If you want one file per month but only have full dates, add a helper column with just the year and month, then split on that column.