Split Excel worksheets into separate files

Turn one XLSX or XLS workbook into separate Excel files—one workbook per selected worksheet. Choose the sheets you need, preview the download names, and save a single XLSX or a ZIP of workbooks.

Your Excel workbook is processed locally in your browser and is not uploaded to our servers.

How to split an Excel workbook

1. Choose or drag an XLSX or XLS file into the tool.
2. Review visible worksheets and keep or change the selection.
3. Check the proposed filenames (and ZIP name when splitting more than one sheet).
4. Select Split to create and download the workbook or ZIP.

Browser-based Excel splitting

• Supported formats: XLSX and XLS.
• One selected sheet downloads as a single XLSX file.
• Two or more selected sheets download as one ZIP of XLSX files.
• Hidden worksheets are excluded from selection.
• Common worksheet content is preserved where supported—not a perfect full-workbook clone.

Private Excel splitting

Your Excel workbook is processed locally in your browser and is not uploaded to our servers. Parsing and workbook generation use SheetJS in the browser. ZIP packaging uses JSZip locally. There is no Looty Tools conversion endpoint that receives your workbook contents for this workflow.

Limits and important notes

• Maximum file size is 25.0 MB.
• Maximum of 50 worksheets per workbook and 50 selected outputs.
• Estimated generated Excel output over 150.0 MB before ZIP compression is rejected to protect browser memory.
• Style-aware parsing uses more memory than simpler Excel tools; very large workbooks may still strain the browser.
• Hidden worksheets are excluded from selection.
• Formulas are not recalculated. Cross-sheet references can become invalid after other sheets are removed.
• Charts, images, macros, named ranges, data validation, frozen panes, advanced tables, drawings, and external links are not preserved.
• Macro-enabled .xlsm files are not supported.

Related tools

• Excel to PDFConvert Excel spreadsheets to PDF files.
• CSV to ExcelConvert CSV files to Excel spreadsheets.
• Split CSVSplit a CSV file into multiple smaller CSV files.
• Excel to CSVConvert Excel spreadsheets to CSV files.

Split Excel FAQ

How do I split an Excel workbook?

Open Split Excel, choose an XLSX or XLS workbook, select the visible worksheets you want, then download one XLSX file or a ZIP of separate workbooks.

Is my workbook uploaded?

No. Your Excel workbook is processed locally in your browser and is not uploaded to our servers.

Can I split every worksheet into its own file?

Yes. Visible worksheets are selected by default. Each selected sheet becomes its own XLSX workbook. Two or more sheets download as a ZIP.

Are formulas preserved?

Stored formula expressions and cached values are kept where SheetJS supports them. Formulas are not recalculated during the split.

What happens to formulas referencing another worksheet?

Cross-sheet formula text is left unchanged. After other sheets are removed, those references can become invalid or show stale cached results.

Are charts and formatting preserved?

This tool splits worksheet data into separate workbooks. Common cell values, formulas, merges, and many formats are preserved where supported. Charts, images, macros, named ranges, data validation, frozen panes, and advanced drawings are not promised.

Can I split .xls files?

Yes. Legacy .xls workbooks are accepted and each output is written as a modern .xlsx file. Macro-enabled .xlsm files are not supported.

Are hidden worksheets included?

No. Hidden and very-hidden worksheets are excluded from the selection list.

What is downloaded?

One selected worksheet downloads as a single .xlsx file. Two or more selected worksheets download as one ZIP containing a separate .xlsx file for each sheet.

What are the size and worksheet limits?

Each workbook must be 25 MB or smaller, with at most 50 worksheets and 50 selected outputs. Estimated generated Excel output over 150 MB before ZIP compression is rejected to protect browser memory.