Open a supported plain XLSX workbook. Choose its worksheet and header row, or try the fictional sample.
Choose 1–3 grouping columns. The same combination of saved values makes one group; numbers and text are distinct.
Review groups, row counts and filenames. Check rows marked for review and any filename conflicts.
Select the groups to deliver. Download separate files or a ZIP, and keep the manifest for checking. Other tools need a new file selection after download.
Order sample: first three of eleven rows
Order ID
Customer
Month
Department
Amount
SO001
Customer A
2026-11
Department A
100
SO002
Customer A
2026-11
Department A
200
SO003
Customer A
2026-11
Department B
300
Check the downloaded result
The sample has 11 order rows. Leave Trim surrounding spaces off. Customer makes 4 files; Customer + Month makes 7; all three category columns make 9. A blank customer and the literal text Unclassified are separate groups. All groups together contain the same 11 source rows.
Expected sample output
Grouping columns
Files
Data rows across all files
Customer
4
11
Customer + Month
7
11
Customer + Month + Department
9
11
Each business file contains only its own group. A ZIP of selected groups contains only those groups. A subset does not export all 11 rows.
Values, basic static styles and column widths are kept. Formulas become saved results without recalculation. Unsupported workbook structures stop processing with an explanation.
Review filenames before sharing. The manifest maps groups to files and row counts. Your original workbook stays unchanged and is not uploaded.
Does this split cells or names into columns?
This tool sends whole rows to separate files by column values. It does not split a cell, a name or text into multiple columns.
Can I group on several columns?
Choose 1–3 columns. Their combined saved values define a group. Trimming affects grouping only; output cells keep their original values.
How is this different from splitting by sheet?
Grouping divides one selected worksheet by row values. Splitting by sheet extracts selected existing worksheets as separate files.
To stack detail files into a longer sheet, download the files and select them in merge. Confirm each column mapping; files are not transferred automatically. Append several files into one sheet →