Split Excel File by Column Value
Upload an Excel file, select a column, and instantly split the data into separate sheets — one per unique value. Download all splits in one workbook, or download each individually.
Drop your Excel file here
or click to browse — .xlsx, .xls, .xlsm, .xlsb
100% private — your file never leaves your browser
Common Uses for Splitting Excel Files
- By country or region: Split a global dataset into per-country files for regional teams
- By department: Split an HR or budget spreadsheet into per-department files for separate reporting
- By month or quarter: Split a full-year dataset into monthly or quarterly sheets
- By product category: Split sales data into separate files per product line
- By salesperson or agent: Split a leads or orders file to send each person only their own rows
Frequently Asked Questions
How does the split work?
You select a column (e.g. "Country"), and the tool groups all rows by the unique values in that column. Each unique value becomes a separate sheet in the output workbook. The header row is copied to every sheet.
Can I download individual splits instead of all at once?
Yes — the preview table shows each unique value with a row count and a download link. Click the .xlsx link on any row to download just that group as a separate file.
Are my files uploaded to a server?
No. Everything runs in your browser. Your file never leaves your device.
What happens to blank values?
Rows where the selected column is empty are grouped under a "blank" sheet. They are not discarded.
Is there a limit on how many groups it can create?
There is no hard limit, but Excel workbooks support a maximum of about 1,000 sheets. For very high-cardinality columns (like unique IDs), use the individual download buttons instead.