> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/tools/split-table-by-column.md).

# Split an Excel table by column online (one sheet per value)

A free Duaer tool: pick a column such as department, region, or store, and get one sheet per value, or download any group as CSV. No upload.

Interactive converter (runs in the browser, no upload): https://doc.duaer.com/tools/split-table-by-column/

## How to use it

1. Drop an Excel or CSV file into the box above.
2. Choose a column under "Split by this column"; the preview shows how many groups you get.
3. Click "Download .xlsx" for one workbook with a sheet per group, or pick a group in the drop-down and click "Download .csv".

## Split rules

- The first sheet is read; its first row is the header and every group keeps it.
- Groups follow the displayed cell text, ignoring surrounding spaces; blank cells go to "(blank)".
- Sheet names are cut to 31 characters, `/ \ ? * [ ] :` become spaces, and duplicates get a number.

## Automate it in Duaer

In Duaer, read the file with [Extract from File](/integrations/builtin/core-nodes/duaer-nodes-base.extractfromfile.md), route rows by this column with a [Switch](/integrations/builtin/core-nodes/duaer-nodes-base.switch.md) node, and give each route its own [Convert to File](/integrations/builtin/core-nodes/duaer-nodes-base.converttofile.md) › Convert to XLSX before sending it to the right owner.
## Questions

### Can I get separate Excel files instead of sheets?

The Duaer split tool puts groups in one workbook. For separate files, pick a group and download its CSV, or give each route its own .xlsx in a Duaer workflow.

### Why do the group counts look off?

The Duaer split tool groups by displayed text, so "East" and "East " match but "East region" is a separate group. Make spellings consistent first.

## Related

- [Free file converters from Duaer](https://doc.duaer.com/tools.md)
- [Merge Excel and CSV files online (columns matched by header)](https://doc.duaer.com/tools/merge-excel-files.md)
- [Remove duplicate rows from Excel or CSV online](https://doc.duaer.com/tools/remove-duplicates.md)
- [Excel to CSV converter (UTF-8, no upload)](https://doc.duaer.com/tools/excel-to-csv.md)