Split Excel by Column Value

How Rows Are Grouped

Pick one column and every distinct value in it becomes a group. Rows are read in order and appended to the group matching their cell in that column, so a group holds its rows in the same sequence they had in the source sheet, and the groups themselves appear in the order their values were first met - not alphabetically. When First row is a header is ticked, the header row is copied to the top of every group so each split opens as a usable table.

The group summary under the controls lists each value with its row count as you change the column, so you can check the grouping is the one you meant before producing any files. It shows the first 100 groups; the downloads include them all.

Two Ways to Take the Result

One workbook, a sheet per value produces a single .xlsx with each group on its own worksheet, named after the value. Worksheet names have to obey Excel's rules, so they are capped at 31 characters, the characters : \ / ? * [ ] are replaced, and a collision after truncation gets a numeric suffix - two long region names that differ only at the end can therefore come back as Name and Name_2. ZIP with one file per value builds a separate workbook per group and zips them; those file names are lowercased with unusual characters turned into hyphens, and duplicates numbered. Choose the ZIP when the groups are going to different people, and the workbook when you still want to compare them side by side.

Grouping Is Exact - Which Is a Feature and a Trap

Values are compared as text with no trimming and no case folding, so West, west, and West  are three groups. That is correct behaviour for codes and IDs, where a case difference can be meaningful, and a nuisance for hand-typed categories. The group table makes it obvious: a region list that should have four entries and shows seven has spelling variants in it. Normalize the column in Excel Data Cleaner - Trim, Collapse repeated spaces, and a Text case setting - then come back and split. Rows with a blank in the split column are kept together as a (blank) group rather than being discarded.

Edge Cases

Only the first sheet of the uploaded file is read. Splitting on a column with hundreds of distinct values produces hundreds of worksheets or files, and a workbook that many sheets deep is unwieldy - if the column is close to unique per row, you probably want a filter rather than a split. Everything is written as values, so formulas become their last results and number formats are not carried over; a date column used for grouping groups by its underlying serial number, which means one group per day. The ZIP is built in your browser, so a very large source sheet takes memory proportional to the whole set of groups at once.

When a Different Tool Fits Better

If you want one group and not all of them, Filter Excel Rows extracts it directly. If the file is already split into worksheets and you want those as separate files - or you want to cut a long sheet into fixed chunks - that is Excel Splitter. When what you actually need is one summary line per group rather than every row, use the Pivot Table Generator. And to put the pieces back together afterwards, Excel Merge is the reverse operation.