How to automatically split excel rows into separate sheets by column value
- Step 1Upload your file — Drop an .xlsx or .csv with a categorical column to split on (e.g. Region, Department, Status).
- Step 2Enter the split column name — Type the header name of the column whose unique values will become separate sheets.
- Step 3Download the multi-sheet workbook — The output .xlsx has one sheet per unique value. Each sheet contains only the matching rows.
Frequently asked questions
What if a column value is longer than 31 characters?+
Excel sheet names are capped at 31 characters. Long values are truncated at the limit.
Can I output separate files instead of separate sheets?+
Multi-file ZIP output is on the roadmap. Currently all groups are combined into one multi-sheet workbook.
What happens to the blank group?+
Rows where the split column is empty are grouped under the key '__blank__' and appear on a sheet of that name.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.