Skip to content
Lizely

Split Excel Sheets

Split every worksheet from a local .xlsx workbook into separately named data-only .xlsx files inside one ZIP download.

Privacy: your files never leave your device. All processing happens locally in your browser.

How to use

  1. 1.Choose one local .xlsx workbook no larger than 20 MB.
  2. 2.Confirm that the workbook contains the worksheets you want as separate data-only files.
  3. 3.Create the ZIP, extract it locally, and inspect a generated workbook in the destination application.

About Split Excel Sheets

Split Excel Sheets turns the worksheets in one local .xlsx workbook into separately named .xlsx files collected in a single ZIP download. Choose a normal Excel-format workbook, then select Split worksheets into ZIP. The browser reads the worksheet list, writes one output workbook for each sheet, and creates names with a stable numeric prefix so their original order is visible after extraction. Everything happens in the current browser tab: the source workbook is not uploaded, changed, retained, or sent to a conversion service. This is useful when a report, export, or handoff contains independent tabs that different people or local systems need to receive separately.

The output has an intentionally narrow contract. Each generated file is a data-only worksheet export based on stored cell values. The page does not calculate formulas, run macros, open links, follow external connections, or execute embedded content. It also does not promise to preserve formulas, charts, images, comments, formatting, conditional rules, widths, merged-cell layout, named ranges, filters, workbook settings, print layout, data validation, protections, hidden-sheet state, or other presentation details. If any of those features carry meaning, keep the source workbook and use software designed to preserve the full workbook structure. The tool makes its data-export boundary visible rather than silently claiming to clone Excel files.

Every output filename is derived from the corresponding worksheet name only after removing path-like and control characters. A two-digit order prefix prevents similarly named sheets from overwriting one another after the ZIP is unpacked. A blank or unusual sheet name receives a safe fallback rather than becoming an unsafe archive path. The browser packages the generated .xlsx files only after the visitor requests the split, so the workbook writer and ZIP builder stay out of the initial tool-page bundle. The resulting ZIP is a normal local download; it is not an upload archive, a cloud share link, or a recovery mechanism for a damaged spreadsheet.

Clear limits keep the operation honest on ordinary browsers. The source must be a non-empty .xlsx file no larger than 20 MB, using a classic single-disk OOXML ZIP directory with at most 2,000 entries and no more than 50 MB of declared expanded data. The workbook may contain up to 50 worksheets, each selected sheet is bounded by the reader's addressed-cell limit, and the total generated worksheet data plus final ZIP is limited to 20 MB. Unsupported Zip64, encrypted, multi-disk, legacy .xls, macro-enabled, malformed, or over-limit packages are rejected. The tool stops with an error rather than silently omitting a worksheet or offering a partial archive.

For dependable use, start with a small representative workbook, download the ZIP, extract it locally, and open one generated file in the destination spreadsheet program to confirm that the stored values meet your handoff need. Keep the original workbook as the source of record. This utility does not merge sheets, repair corrupt files, choose a subset of tabs, convert a legacy Excel format, preserve a visual report, or infer a business schema. It provides one transparent local path from a bounded multi-sheet workbook to an ordered ZIP of separate data-only worksheet files.

Methodology & sources

Validate a bounded classic .xlsx ZIP, load stored worksheet values only, create one safely named data-only .xlsx file per worksheet, and bundle the bounded outputs into a local ZIP after explicit visitor action.

Frequently asked questions

Does this upload or change my workbook?
No. The browser reads the local file and creates a separate ZIP download without modifying the source.
Will formulas, formatting, and charts be preserved?
No. Each output is a data-only worksheet export based on stored cell values.
Why are output names prefixed with numbers?
The numeric prefixes preserve worksheet order and avoid archive filename collisions.

Related tools

Developer Tools guides

View all