What Split Excel File helps you do

A workbook that is too large or needs routing by sheet, size, or category can be split without uploading it. This tool reads the file, creates one output per sheet, row chunk, or column value, and packages the parts. It is useful when a single workbook must become a set of files for different teams or import limits.

Splitting, conversion, and ZIP creation run entirely in your browser. The workbook is not uploaded to Haivix.

How it works

The workbook is parsed and the selected worksheet is converted into a table. By-sheet mode copies each worksheet into its own workbook, while row-count and column-value modes divide the rows into parts. Each part is written as XLSX or CSV, named from the sheet or the split value, and zipped when there is more than one.

How to use Split Excel File

Drop an Excel workbook and choose the worksheet for row or column splits.
Choose worksheet, row-count, or column-value mode, then pick XLSX or CSV output.
Split the workbook and download the single file or the ZIP of parts.
Open one part and confirm the header and row range.

When to use it

Send one worksheet per team without sharing the full workbook.
Break a large sheet into smaller files for an import limit.
Create one file per region, owner, or category for separate uploads.
Separate a workbook by sheet before archiving each department's data.
Prepare batches for a system that caps rows per upload.
Give reviewers only the part they need.

When not to use it

Do not split by a column with hundreds of unique values; the 100-part cap applies.
Do not expect charts and cell styles in the split workbooks.
Do not split a sheet with merged cells if the merged layout must be preserved.

Example

A 60,000-row workbook needs to be uploaded in 20,000-row batches. Row-count mode creates three XLSX files, each with the header row, and the ZIP is uploaded one file at a time. A second pass by region creates four smaller files for the regional managers.

What you can do with Split Excel File

Split by worksheet, row count, or column value.
Choose the worksheet for row or column splits.
Export each part as XLSX or CSV.
Keep formulas in by-sheet XLSX output where supported.
Package multiple parts into a ZIP.
Download a single part directly when there is only one.

Example: split a workbook by region

Drop the workbook and choose the worksheet that holds the rows. By-sheet mode does not need a worksheet selection because every sheet becomes a part.

Choose column-value mode and select the region column. Each unique region becomes its own file, which is easier to route than a fixed row count.

Review the part list, download the ZIP, and open one part to confirm the header and the row count.

What to know before you start

A split is capped at 100 parts.
By-sheet XLSX output keeps the original worksheet cells, including formulas; row and column splits and CSV output write values.
Charts and cell styles are not supported by the browser Excel library. Merged cells can change shape when written to a new workbook.
The source workbook is held in browser memory, so very large files can be slow.
There is no manifest file describing the parts.

Common mistakes

Choosing by-sheet mode when the goal is smaller row batches.
Splitting by a column with almost unique values and hitting the part cap.
Expecting formulas in row or column splits; those modes write values.
Ignoring merged cells that change shape in the new workbook.
Downloading one part when the ZIP was intended.

Troubleshooting

If the split stops at 100 parts, increase the rows per part or choose a coarser column.

If a part has no header, confirm that the source sheet has a header row and that the split mode keeps it.

If the output opens with a repair warning, the source may contain merged cells or unsupported styling; try CSV output.

If the ZIP is incomplete, download it again; a large ZIP can be interrupted on a slow connection.

If a by-sheet XLSX loses a formula, the browser library could not preserve it; use Excel for that sheet if the formula is critical.

If a part opens with different column widths, that is expected; the split does not copy formatting. Set the widths in the destination when the file is for review rather than for an import.

Split Excel File