# XLSX Multi Sheet Splitter

Split a multi-sheet workbook into independent files by sheet name, with ZIP output

> Canonical page: https://elysiatools.com/en/tools/xlsx-multi-sheet-splitter

- **Category:** Format Conversion

- **Keywords:** xlsx, sheet, split, workbook, zip, csv, json

## Overview

Split one workbook into many files.

- Export each worksheet as a standalone file
- Supports XLSX, CSV, or JSON per sheet
- Optional hidden-sheet export
- Returns a ZIP package with manifest

## Inputs

- **Excel File** (file)
- **Output Format** (select)
- **Include Hidden Sheets** (checkbox)
- **Output File Prefix** (text): sheet

## When to use

- When you need to distribute specific data subsets from a large master workbook to different team members.
- When you need to convert individual sheets into machine-readable formats like JSON or CSV for data integration.
- When a workbook contains too many sheets and you need to isolate them into separate files to reduce file size and improve performance.

## How it works

- Upload your Excel workbook using the file picker.
- Select your preferred output format (XLSX, CSV, or JSON) and choose whether to include hidden sheets.
- Set a custom naming prefix to organize your output files effectively.
- Process the file to generate a downloadable ZIP archive containing all your extracted sheets.

## Use cases

- Isolating department-specific financial data from a company-wide master budget workbook.
- Preparing individual sheet data for ingestion into a database or web application via JSON.
- Cleaning up large workbooks by splitting them into smaller, focused files for easier collaboration.

## Frequently asked questions

### What file formats can I export to?

You can export your worksheets as XLSX, CSV, or JSON files.

### Does the tool handle hidden sheets?

Yes, you can toggle the 'Include Hidden Sheets' option to decide whether to extract them or skip them.

### How are the output files delivered?

All extracted sheets are packaged into a single ZIP file for easy downloading.

### Is there a limit to the file size?

The tool supports file uploads up to 200MB.

### Can I rename the output files?

Yes, you can use the 'Output File Prefix' field to define a custom naming convention for all extracted files.

## Related tools

- [JSON-LD Generator from CSV](https://elysiatools.com/en/tools/json-ld-generator-from-csv): Turn CSV or Excel rows into Schema.org JSON-LD for articles, products, or events, with validation-ready output for SEO workflows
- [Time Series Anomaly Detector](https://elysiatools.com/en/tools/time-series-anomaly-detector): Upload CSV or JSON time series data, detect anomalies with Z-Score and IQR methods, and return a chart-backed report
- [Time Series Forecast & Seasonality Analyzer](https://elysiatools.com/en/tools/time-series-forecast-seasonality-analyzer): Forecast future periods from CSV or JSON time-series data and inspect trend, seasonal, and residual decomposition in one report
- [XLSX Range Extractor](https://elysiatools.com/en/tools/xlsx-range-extractor): Extract a specific sheet/range/named-range from Excel into JSON with coordinates or record objects
- [XLSX Sheet to CSV Pack](https://elysiatools.com/en/tools/xlsx-sheet-to-csv-pack): Export each Excel worksheet as an individual CSV file and include a manifest with schema/statistics
- [XLSX Sheet To JSON Schema](https://elysiatools.com/en/tools/xlsx-sheet-to-json-schema): Infer JSON Schema from worksheet headers and sample rows with types, enum candidates, and basic constraints
- [XLSX Sparkline Injector](https://elysiatools.com/en/tools/xlsx-sparkline-injector): Inject Excel sparklines into worksheet cells by patching XLSX sheet XML with sparkline definitions
- [XLSX Chart Embedder](https://elysiatools.com/en/tools/xlsx-chart-embedder): Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports

## Samples

- [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing
- [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests
- [CSV Samples](https://elysiatools.com/en/samples/csv-samples): Sample CSV files with various data types, sizes, and complexity levels
- [Python Samples](https://elysiatools.com/en/samples/python): Essential Python code examples and Hello World demonstrations

## Related content

- [XLSX ETL Ingestion and Warehouse Handoff](https://elysiatools.com/en/hubs/xlsx-etl-ingestion-workflows): Turn mixed workbook and CSV sources into traceable, schema-aware outputs for SQL loading, Parquet pipelines, and object-storage batch handoff.