How to automatically split an excel product catalog into category-specific sheets
- Step 1Export the full product catalogue to Excel — Download the complete .xlsx with a Category column.
- Step 2Enter 'Category' as the split column — Type the column header name. The tool creates one sheet per unique category value.
- Step 3Distribute or upload the multi-sheet workbook — Each supplier or buyer navigates to their relevant category sheet directly.
Frequently asked questions
Can I split on sub-category as well as category?+
Single column only in the current version. For a two-level split (Category + Sub-category), concatenate both columns into a new column in Excel first, then split on the combined value.
Does each sheet include the header row?+
Yes. The original header row is included at the top of every sheet.
What if a category name contains characters that are invalid in Excel sheet names?+
Invalid sheet name characters (/ \ * ? [ ] :) are replaced with underscores automatically.
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.