Excel Sheet Split
Split selected sheets into separate Excel files.
About This Tool
The Excel Sheet Split tool saves selected sheets from one Excel file (.xlsx) as separate Excel files. You can review each sheet's row and column count before choosing, and when multiple sheets are selected they are exported as individual .xlsx files bundled into a single ZIP download. Ideal for distributing or archiving department, segment, project, or data-type sheets separately from a workbook.
How to Use
Select an Excel file
Upload the Excel file (.xlsx) that contains the sheets you want to split. Once selected, you can see the file name, total sheet count, and size.
Choose sheets to split
Check the sheets you need in the list. Use the Select All and Clear Selection buttons to quickly select or deselect multiple sheets.
Split and download
Confirm the selected sheet count and the file names to be created, then click Split Sheets. When done, download the split Excel files at once as a ZIP.
Key Features
Split only the selected sheets
Create separate Excel files for only the sheets you need, instead of every sheet in the workbook.
Process multiple sheets at once
Select multiple sheets and split them into individual .xlsx files in one pass, with Select All and Clear Selection buttons.
Per-sheet info and output file names
Review each sheet's name, row count, and column count while choosing, and preview the file name each sheet will be saved as.
Batch ZIP download
Bundle the split Excel files into a single ZIP archive and download them all at once.
Preserve formulas and formatting
The selected sheet's original content is kept intact, so formulas, cell formatting, charts, images, and merged cells are preserved.
In-browser processing
Your Excel file stays in your browser — nothing is sent to a server.
Use Cases
Distributing departmental sheets
Split department-specific data inside one workbook into separate files for sharing with each department.
Separating project materials
Save sheets split by project, site, segment, or work type as independent Excel files.
Sharing only specific sheets
Share only the sheets you need with customers or partners instead of the entire workbook.
Organizing large workbooks
Break a workbook with many sheets into smaller files for easier management or selective archiving.
Preparing files for system upload
Create individual Excel files for systems that require each sheet to be uploaded separately.
Frequently Asked Questions
Is each selected sheet saved as a separate Excel file?
Yes. Each selected sheet is saved as an individual .xlsx file containing only that sheet.
Can I split multiple sheets at once?
Yes. Select multiple sheets and split them in one pass. The resulting files are bundled into a ZIP for download.
How are the split file names determined?
Each file name is based on the sheet name. For example, a sheet named Segment_A is saved as Segment_A.xlsx.
What if a sheet name contains characters that cannot be used in file names?
Characters that are not allowed in file names, such as slashes, are replaced with hyphens (-). If the name becomes empty, a default name such as sheet or workbook is used.
Are formulas and formatting preserved in the split files?
Yes. The selected sheet's original content is preserved, so formulas, cell formatting, charts, images, and merged cells are kept.
What happens to formulas that reference other sheets?
The split file contains only the selected sheet, so formulas referencing other sheets may break or return errors. It is safest to review files with cross-sheet references before splitting.
Can I select hidden sheets?
Yes. Hidden sheets appear in the list and can be selected. In the resulting split file, the sheet is saved as a visible sheet.
Where can I check a sheet's row and column count?
The row and column counts are shown below each sheet name, so you can tell sheets apart when choosing which to split.
Is the result always a ZIP, even with one sheet?
Yes. The result is always provided as a ZIP file. Even when you select a single sheet, it is downloaded as a ZIP containing that one file.
Are the original Excel files changed?
No. The original Excel file stays unchanged, and new Excel files are created for each selected sheet.
Is my Excel file sent to a server?
No. All processing happens locally in your browser. Your Excel file and split results are never transmitted to a server.
Related Tools
