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 group individually.
Drop your Excel file here
or click to browse — .xlsx, .xls, .xlsm, .xlsb
100% private — your file never leaves your browser
How to Split an Excel File by Column
Upload your file
Drag and drop your .xlsx or .xls file onto the tool, or click to browse. Multi-sheet workbooks are supported — you can choose which sheet to split.
Select the split column
Choose the column whose unique values will define the groups. Each distinct value becomes one sheet (or one download file). The preview shows row counts per group.
Download your splits
Click "Download All" to get every group in a single workbook, or click the individual .xlsx links in the preview to download each group separately.
Common Uses for Splitting Excel Files
- By country or region: Split a global sales or customer dataset into per-country files so regional teams only see their own data.
- By department: Split an HR payroll or budget spreadsheet into per-department sheets for separate reporting and review.
- By month or quarter: Split a full-year transaction dataset into monthly sheets for period-by-period analysis.
- By product category: Split a product catalogue or inventory file into per-category sheets for category managers.
- By salesperson or agent: Split a leads or orders file so each person receives only their own rows — without exposing other agents' data.
To merge files back together, use the Merge Excel Files tool — it is the reverse operation. If you also need to convert the resulting splits to another format, try the Excel to CSV Converter or Excel to JSON Converter.
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 automatically 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 links instead of downloading all splits in one workbook.
Related Excel Tools
Merge Excel Files
The reverse operation — combine multiple workbooks into one file or one sheet.
Duplicate Row Finder
Find and remove duplicate rows before or after splitting your data.
Excel to CSV Converter
Convert individual split sheets to CSV for importing into other tools.
Fill Blank Cells
Fill grouped blank cells before splitting — ensures every row has the column value you are splitting on.