Split an Excel workbook
Break a multi-sheet workbook into separate files, or cut one long sheet into chunks of the row count you choose.
Drop your files here
.xlsx, .xlsm, .xls, .ods · up to 300 MB
More settingsFewer settings
How to Split Workbook
- 1
Drop your XLSX file
XLSX, XLSM, XLS and ODS are read in the browser, and the list of sheets appears straight away.
- 2
Choose to split by sheet or by row count
By sheet gives one workbook per tab; by rows cuts a single sheet into equal parts with the header repeated.
- 3
Split and download a ZIP
Parts arrive together in one archive, named after the source file and the sheet or part number.
Two operations that share one word
Splitting by sheet is a filing problem: one workbook holds twelve monthly tabs and each department needs only its own. Splitting by rows is a size problem: one sheet holds half a million rows and the system that must import them accepts ten thousand at a time. They produce completely different results from the same file, so the choice is the first thing on screen rather than a setting buried under advanced options. By sheet keeps the original sheet object intact, including merged ranges, column widths and row heights; by rows rebuilds each part from the values and carries the column widths across so every part still opens readable.
Formulas that point at sheets which are no longer there
A formula like =Summary!B4 makes sense inside a workbook that contains a Summary sheet. Once each sheet becomes its own file, that reference has nothing to resolve against and Excel shows #REF!. The default therefore converts formulas to the values they last evaluated to; no recalculation is needed, because the computed value is stored alongside the formula in the file. If you need the formula text preserved, that option exists, and choosing it produces a warning rather than a silent surprise a week later.
What does not survive the split
Charts, pivot tables, embedded images, conditional formatting and data validation lists are not written into the output files. This is a limitation of the free SheetJS Community Edition that the project uses rather than the paid edition, and rewriting a chart's internal references to sheets that no longer exist would be a substantial job even with it. Rather than let you discover this by opening a part and finding a blank space, the source file is inspected for those features and you are told which ones were present before the download begins.
The workbook never leaves this tab
Reading the file, rebuilding each part and packing the archive all happen locally in your browser. Nothing is uploaded, so a payroll or customer workbook stays on your machine from start to finish.
Frequently asked questions
What happens to charts and pivot tables?
They are not carried into the split files, and you are told which of them the source contained before you download. The library used to write XLSX in the browser cannot produce them, and rebuilding a chart whose data range points at a removed sheet would not be meaningful anyway.
Will formulas between sheets still work?
Not once the sheets are in separate files; the reference has nothing to resolve against. By default formulas are replaced with their computed values so every part opens with correct numbers; keeping the formula text is possible and produces a warning.
How are the output files named?
Splitting by sheet gives source-SheetName.xlsx; splitting by rows gives source-SheetName-part-001.xlsx, numbered with three digits so the parts sort correctly as text.
What if the workbook has only one sheet?
Splitting by sheet is refused with a message saying so, and a suggestion to switch to splitting by row count instead, which is almost certainly what you meant.
Does this work with .xls and .ods files?
Yes for reading. Legacy binary XLS and OpenDocument ODS are both parsed, and the parts are always written as modern XLSX.
Is there a limit on the number of sheets?
No fixed limit beyond available memory. Every sheet becomes a separate workbook and they are packed into one ZIP, so a twelve-tab annual report becomes twelve files in a single download.
Is the file uploaded to a server?
No. The workbook is parsed, split and repacked entirely in your browser, with no upload and no temporary copy stored anywhere.
Related tools
Excel to CSVExport XLSX, XLS and ODS sheets to CSV with the separator, encoding and line endings the receiving system actually wants.
Excel to JSONTurn a spreadsheet into JSON your code can actually consume: array of objects, array of arrays, or one array per column.CSV to ExcelTurn a CSV export into a real XLSX workbook that opens straight into columns, with no import wizard, no mangled accents and no lost leading zeros.
Split CSVCut a large CSV into equal chunks, or into one file per value of a column, with the header, delimiter and encoding carried into every part.JSON to ExcelFlatten a JSON or NDJSON export into a spreadsheet. Nested objects become dot-named columns and every record contributes its keys.
Merge CSVCombine exports whose columns are in different orders, with different encodings and the odd extra field, into one clean CSV.