Online tools
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.
How to use it
- Drop an Excel or CSV file into the box above.
- Choose a column under "Split by this column"; the preview shows how many groups you get.
- 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, route rows by this column with a Switch node, and give each route its own Convert to File › 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.
In this section
Free file converters from Duaer
Free Duaer tools for spreadsheets and data files: convert formats, merge, split, remove duplicates, fix encodings, and format JSON. Everything runs in your browser and no file is uploaded.
File conversionMerge Excel and CSV files online (columns matched by header)
A free Duaer tool: pick several Excel or CSV files, match columns by header name, and get one table with an optional source-file column. No upload.
File conversionRemove duplicate rows from Excel or CSV online
A free Duaer tool: open an Excel or CSV file, pick the columns that define a duplicate, keep the first row, optionally ignore case and spaces, and see how many rows were removed. No upload.
File conversionExcel to CSV converter (UTF-8, no upload)
A free Duaer tool that turns .xlsx or .xls into UTF-8 CSV in your browser. Pick a sheet; a BOM is added by default so Excel reopens it cleanly.