📊
Split Excel
Split Excel workbooks into multiple files
split
Convert
About this tool
Split Excel workbooks into multiple files
Input: .xlsx, .xls
Output: .zip
Ready to convert
Select a file and click Convert to get started
Split Excel workbooks by worksheet, rows, or parts
Split Excel takes one XLSX or XLS workbook and creates smaller XLSX files inside a downloadable ZIP archive. Choose to export each worksheet separately, divide the first worksheet by a fixed number of data rows, or distribute its rows across a selected number of parts.
When splitting an Excel workbook is useful
- •Extract individual worksheets from a workbook for separate review or sharing.
- •Divide a large table into smaller batches for systems with row limits.
- •Distribute records from one worksheet across several files for manual processing.
How to use this tool
- 1.Upload one supported Excel workbook in XLSX or XLS format.
- 2.Choose By Sheet, By Number of Rows, or Into Equal Parts. Enter a positive row limit or a part count of at least two when that mode is selected.
- 3.Split the workbook, download the ZIP archive, extract its XLSX files, and verify their contents.
How the three Excel split modes work
- By Sheet creates a separate XLSX workbook for each worksheet in the source file. This is the default mode.
- By Number of Rows reads the first worksheet and creates consecutive XLSX files containing up to the selected number of data rows.
- Into Equal Parts reads the first worksheet and distributes its data rows as evenly as possible across the requested number of XLSX files.
Example: divide seven records into four parts
Suppose the first worksheet contains column headings and seven order records. Select Into Equal Parts and enter 4. The ZIP archive contains four XLSX files holding 2, 2, 2, and 1 data records. Alternatively, choose By Number of Rows and enter 3 to create three files containing 3, 3, and 1 records.
Important workbook limitations
- The tool accepts one workbook per request and returns the generated XLSX files together in a ZIP archive.
- Row-based and equal-part modes process only the first worksheet. Choose By Sheet to export all worksheets separately.
- Output workbooks are rebuilt from spreadsheet table values. Original cell styling, charts, macros, merged-cell layouts, and formulas are not preserved as original Excel features.
- The first row is interpreted as column headings. Check dates, identifiers, blank cells, and calculated values after splitting.
- Files are uploaded for server-side processing. Avoid submitting confidential or sensitive records.
Troubleshooting Split Excel results
- A worksheet is missing: select By Sheet rather than a row-based mode.
- The number of output files is unexpected: check the number of data rows and the selected row or part count.
- Formatting or formulas are missing: the tool generates new workbooks from table values rather than copying the original workbook structure.
- An output value looks different: compare source cell types, saved formula results, dates, and identifiers with the extracted files.
Continue the workflow
Return to Data tools, or continue with a complementary tool:
Questions about this specific tool
Can I split an Excel file into separate worksheets?
Yes. By Sheet exports each worksheet as a separate XLSX workbook in one ZIP archive.
Which worksheet is used when splitting by rows?
By Number of Rows and Into Equal Parts both use the first worksheet of the uploaded workbook.
Does each part contain column headings?
Yes. The output files are generated as tables with column headings.
Will formulas and formatting be preserved?
No. The splitter creates new workbooks from table values rather than retaining the original formulas, cell styling, charts, and layout.
What happens if I request more parts than there are records?
Only nonempty parts are generated, so the ZIP may contain fewer files than the requested part count.
What file format will I download?
You download a ZIP archive containing XLSX workbook files.