What it does
Excel Splitter takes one Excel file and splits a worksheet into multiple .xlsx files — one per unique value in a column you choose. All output files are bundled into a single .zip for download.
Step by step
- 1 Upload your file — drag it onto the upload area or click to browse. Supported formats:
.xlsx, .xlsm, .xls.
- 2 Select a worksheet — if your file has multiple sheets, pick the one containing the data you want to split. If there is only one sheet it is selected automatically.
- 3 Select a column — choose the column whose values will be used to group rows. Row 1 is always treated as the header row.
- 4 Click "Split & Download" — the file is processed on the server (in memory only) and the resulting ZIP is saved in your browser.
- 5 Download the ZIP — click the Download button that appears. Each
.xlsx inside is named after its column value and contains the header row plus all matching data rows.
History
Every successful split is saved to your browser's local storage. The History section below the main card lets you re-download or delete any previous result. Use "Clear all" to remove everything at once.
Warnings & errors
- Blank values — rows where the selected column is empty are skipped. A warning will tell you how many were skipped.
- Invalid filename characters — if any column value contains
/ \ : * ? " < > |, the split is aborted and all offending values are listed. Fix the source data and try again.
Your data stays private. Nothing is saved on the server. All results are stored only in your browser's local storage (IndexedDB).