Split Excel by column
Split a spreadsheet into separate XLSX files by the values in a selected column. Review the groups and download a ZIP.
Output XLSX / ZIPChoose filesProcessed on your device
Choose files to select sheets and columns.
Results contain values stored as text cells. Formatting and formula recalculation are not supported.
Example
A Customer column with 12 North rows and 8 South rows produces two workbooks, each with its own header row.
Supported features and limits
- The header is copied to each group. Empty values are placed in an Unspecified group.
- Conflicting output filenames receive a number. Cell values are not changed.
- Values are saved as text cells. Original formatting, macros, charts, and formula recalculation are not supported. Each sheet supports up to 50,000 rows, 200 columns, and 1 million cells; selected input files support up to 2 million cells in total.
Frequently asked questions
Will my original files change?
No. The tool creates new result files. Review the downloaded results before using them.
Are my files uploaded?
Selected files are processed in your browser. File contents and filenames are not sent to a server. Aggregate tool-use counts are collected as described in the privacy notice.