100% local and secure
Your data stays on your device and is never sent to our servers.
Split an Excel file by column
Choose a grouping column and generate a workbook containing a separate sheet for each detected value.
- 100% local
- Instant
- Free
- No account
- Works offline
- Batch processing
Your files are processed locally in your browser and are never sent to our servers.
Drop your file here
Recommended size: up to 30 MB
Workbook split
Processing…0 %
Why use this tool?
Split an Excel table into multiple worksheets based on values from a grouping column.
Smart processing
Clean, structure, and transform your data with rules tailored to the format being processed.
Supported formats
CSV, XLSX, and other tabular formats depending on each tool’s capabilities.
Save time
Get a clean, ready-to-use result in seconds without installing software or configuring a complex workflow.
Guide
How to use this tool
- 1
Import the table
Add the file to split.
- 2
Choose the column
Select the field used to create groups.
- 3
Export the workbook
Download a workbook with one sheet per group.
Tips and best practices
- Work on a copy when your data is important.
- Review the result before reusing it in another application.
- Processing takes place directly in your browser.
Frequently asked questions
How are worksheet names generated?
They are derived from column values and adjusted to Excel worksheet naming constraints.
Is my data uploaded?
No. Processing happens locally in your browser.
Can I use this tool for free?
Yes. The tool is free and requires no account.
Was this tool useful?
Read next
GuideBest practicesBeginner
Split a CSV or Excel table into smaller files
Discover when to split a large table by row count or by a column value, and how to preserve a useful structure in every output file.
29 August 20261 minRead
GuideBest practicesBeginner
Merge CSV or Excel files without misaligning columns
Learn how to align headers, verify schemas and combine several CSV or Excel files while avoiding duplicated or shifted columns.
29 August 20262 minRead
GuideBest practicesBeginner
Convert CSV, Excel, JSON and TSV without losing the structure
Understand delimiters, encodings, types, nested JSON and spreadsheet features before converting data between CSV, Excel, JSON and TSV.
29 August 20262 minRead
GuideBest practicesBeginner
How to clean and prepare a CSV or Excel file before using it
Learn a practical order for removing empty rows, trimming values, standardizing headers, checking identifiers and validating a CSV or Excel dataset.
29 August 20263 minRead
Recommended workflow
Continue your processing
Discover tools that naturally fit before, after, or alongside this one.
Complementary tools
Data & spreadsheets
Merge Excel or CSV files
Merge multiple Excel or CSV files into one table with automatic column alignment.
100% localFeatured
Use this toolData & spreadsheets
Clean an Excel or CSV file
Remove duplicates, empty rows and unnecessary spaces.
100% localFeatured
Use this toolData & spreadsheets
Compare two Excel or CSV files
Compare two Excel or CSV files using a key column and spot the differences.
100% localFeatured
Use this tool