Excel Splitter

Split your Excel file into multiple sheets based on column values

Upload File

Select Sheet

Configure Split

Download

Upload Excel File

Select one Excel file to split into multiple sheets

Supported formats: .xlsx, .xls (Single file only)

Uploaded File

Ready to split

Select Worksheet to Split

Choose the worksheet you want to split

Configure Split Rules

Select columns and how to split the data

Select Columns to Split By

You can select multiple columns. Each selected column will create groups based on its values.

Advanced Options

Maximum Sheets Limit: Limit the number of sheets to prevent file overload (10-100)

Include headers in each sheet

Create "Uncategorized" sheet for empty values

Split Preview

Select at least one column to see the preview

Split Complete!

Original Rows

Sheets Created

Split Columns Used

Generated Sheets

Processing...

Please wait while we split your file

How to Use Excel Splitter

Split large Excel files into organized sheets in 4 easy steps

100% Secure: All processing happens in your browser. Your files never leave your device.

Upload Your Excel File

Select an Excel file (.xlsx or .xls) that you want to split into multiple sheets.

Choose Split Columns

Select one or more columns to split by. For date columns, choose split by year, month, day, hour, or minute. For other columns, split by unique values.

Configure Options

Set the maximum number of sheets and choose whether to include headers and handle empty values.

Download Result

Review the split results and download your new Excel file with organized sheets.

Common Use Cases

Split by Date

Organize sales data by month or year for easy analysis

Split by Category

Separate customer data by region or department

Split by Product

Create separate sheets for each product line or SKU