ExcelTool.io

Split Excel by Column Value

Group rows by the values in a column - one worksheet or one file per region, category, or ID. Download a multi-sheet workbook or a ZIP. No upload.

Drop your file here or click to upload

Supports .xlsx, .xls, .xlsm, .xlsb, .csv · up to 50MB

Split an Excel Sheet by Column Value

  1. Upload your file - .xlsx, .xls, .xlsm, .xlsb, or .csv.
  2. Pick the split column - for example Region, Category, or Owner.
  3. Choose the output - one workbook with a sheet per value, or a ZIP with a file per value.
  4. Download - each group keeps the header row.

One File per Category, Instantly

Splitting a master sheet into per-region or per-owner files usually means manual filtering and copy-paste, or a fiddly macro. This tool groups the rows by the column you choose and hands back either a tidy multi-sheet workbook or a ZIP of separate files - all in your browser, so even large or sensitive workbooks never leave your device.

Frequently Asked Questions

Related Tools