Excel Sheet Splitter

Choose a split strategy

The splitter always creates new XLSX files and never edits the source workbook. Choose the strategy that matches the structure of your data.

The data-row and column strategies are for a table with a meaningful first row. They do not split at a target file size or apply a custom formula. Use the worksheet-tab strategy when each tab should remain its own file.

Data-row chunks and column groups

For data-row chunks, choose from 1 to 100,000 data rows for each output. The first row is copied to every generated XLSX. For example, a sheet with one header row and 24,000 data rows can become three files of 10,000, 10,000 and 4,000 data rows.

For column-value splitting, choose the column that defines each group. Every distinct value gets its own XLSX. Empty values are grouped together so no matching data row is silently dropped. Both strategies omit blank data rows, because the browser reader uses a non-blank row view of the selected worksheet.

Row and column splitting require exactly one selected worksheet and a first row containing at least one non-empty header cell. If the proposed split would produce more than 100 files, choose a larger row count or a column with fewer distinct values.

Accepted workbooks and limits

The splitter accepts genuine XLSX workbooks and legacy binary XLS workbooks. It does not accept XLSM, XLSB, ODS or CSV files. Renaming another file to .xlsx or .xls is not enough: the browser checks the file container, and XLSX archives are checked before the workbook reader opens them.

One workbook can be up to 20 MiB, contain up to 100 worksheets and use up to 2 million cells across the workbook. A split can create at most 100 files, and combined output is limited to 100 MiB. A malformed, unusually compressed or oversized workbook can be refused before conversion to protect the browser.

Choose worksheets deliberately

Visible worksheets are selected by default. Hidden and VeryHidden worksheets are identified in the list and are included only when you select them. This is useful when a workbook has helper tabs that should not be distributed with the main report.

A selected hidden tab is written to its own newly generated workbook. Do not rely on the result to retain its original hidden or VeryHidden state. Row and column strategies require one selected worksheet, so select a hidden tab deliberately before using either of those strategies. Keep the source workbook if that visibility setting matters.

Formulas, formatting and workbook compatibility

Each result is a newly written XLSX, not a byte-for-byte extraction of the source workbook. The worksheet-tab strategy carries the selected worksheet into a new workbook, but the splitter does not calculate, refresh or validate formulas. A formula that refers to another worksheet in the original workbook can point to a missing sheet after separation, so check the downloaded file before using it for a financial model or an operational import.

Row and column strategies rebuild the sheet from browser-read cell values. They copy the header row and selected data rows, but do not preserve formulas, cell formatting or blank data rows. Do not rely on any strategy to preserve charts, pivot tables, named ranges, data validation, print settings, external connections or other workbook-level features. The output format is XLSX, so macro-enabled workbooks are not accepted. Keep the original file and verify a representative result in the spreadsheet application you use.

Private browser processing and temporary drafts

Workbook reading, worksheet selection, XLSX creation, ZIP packaging and download preparation happen in your browser. Workbook bytes, worksheet values and filenames are not uploaded, sent to our servers or put in the URL.

In the multi-step flow, the browser can keep a hash-checked workbook draft in IndexedDB so the next step can restore it. The URL carries only an opaque job identifier. The draft becomes unavailable after 30 minutes. Starting over or requesting a download asks the browser to remove the draft, and the tool warns you if it cannot confirm removal. If temporary browser storage is unavailable, the controls stay on one page so you can still finish.

Downloaded files are handled by your browser. On a shared computer, remove downloads yourself after checking the output.