Excel Sheet Splitter
Split an Excel workbook into separate files, one for each sheet. You get back a single .zip containing one .xlsx per sheet, with formatting and merged cells preserved.
- Nothing uploaded
- No size limit
- No account
Drag and drop an Excel file here, or click to select a file
Supported formats: .xlsx, .xls
What the Excel Sheet Splitter tool does
A workbook with twenty tabs is awkward to share when each recipient only needs one of them. This tool splits an Excel file into separate files, one per worksheet, and hands them back as a single zip. Formatting, merged cells, column widths and row heights are carried into each new file, so a split sheet still looks like the original.
How to split an Excel workbook into separate files
Add your workbook
Drop the .xlsx or .xls file you want to split. Every worksheet it contains will be turned into its own file.
Split the workbook
Progress shows which sheet is being written and how many are left. Sheets are prepared in memory rather than downloaded one at a time.
Download the zip
You get one .zip containing an .xlsx per sheet, named after the original file and the sheet. A workbook with a single sheet skips the zip and downloads directly.
What stays on your device
Your workbook is never uploaded. The Excel Sheet Splitter tool reads the file straight from your disk and does all of its work inside this browser tab, using the open-source ExcelJS and SheetJS libraries. There is no account, no upload limit and no copy of your data on any server — once this page has loaded, the tool keeps working even if you disconnect from the internet.
Limitations to know about
- Formulas that referenced other sheets in the workbook will no longer find them once each sheet is a separate file, and will show a reference error when opened.
- Workbook-level features that span sheets — defined names, cross-sheet charts and pivot caches — are not carried into the individual files.
- Characters that Excel allows in a sheet name but Windows does not allow in a filename are replaced with an underscore. Two sheets that end up with the same filename get a numbered suffix so neither is lost.
- A legacy .xls file is converted to .xlsx before processing, which preserves the data but not the original formatting.
Frequently asked questions
How do I split an Excel file into separate files for each sheet?
Drop the workbook above and choose Split workbook. Each worksheet is written to its own .xlsx and the whole set arrives as one zip, so there is no need to save each file by hand.
Why do I get a zip instead of separate downloads?
Browsers block a page that starts several downloads in a row, so a workbook with twelve sheets would previously give you one file and a permission prompt. A single zip always arrives complete. Unzip it and every sheet is there as an ordinary .xlsx.
Is my formatting kept?
Yes. Cell styles, fonts, fills, borders, alignment, merged cells, column widths, row heights and the sheet's view settings are all copied into the new file.
Can I split one sheet into several files by a column value instead?
Yes, but with a different tool: this one splits by worksheet, so use Split Excel by Column Value when you want the rows of a single sheet divided by what is in a column — one file per region, per salesperson or per month. It is linked under Related tools below.
Are my files uploaded to a server?
No. Every tool on Excel Toolbox runs in your browser using the open-source ExcelJS and SheetJS libraries. Your workbook is read from your own disk, processed in your browser tab, and written back out as a download. It is never sent to us or to anyone else, which is why the tools keep working if you go offline after the page has loaded.
How large a file can I process?
There is no upload limit, because nothing is uploaded — the ceiling is your device's memory. Files up to about 25 MB are comfortable on a typical laptop. Much larger workbooks will still work but take longer, and processing runs in the page, so leave the tab open until your download starts.