Categories

← View All Tools

XLSX Multi Sheet Splitter

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

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

Example Results

1 examples

Split Workbook by Sheets

Split all worksheets from one workbook and package standalone files into a ZIP

xlsx-multi-sheet-splitter-example1.zip View File
View input parameters
{ "excelFile": "/public/samples/xlsx/workbook-sales.xlsx", "outputFormat": "xlsx", "includeHiddenSheets": false, "namingPrefix": "sales-sheet" }

Click to upload file or drag and drop file here

Maximum file size: 200MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Key Facts

Category
Format Conversion
Input Types
file, select, checkbox, text
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX Multi Sheet Splitter is a professional utility designed to break down complex, multi-sheet Excel workbooks into individual, manageable files. By automating the extraction process, it allows you to convert each worksheet into a standalone XLSX, CSV, or JSON file, which are then conveniently packaged into a single ZIP archive for easy distribution.

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.

Examples

1. Departmental Data Distribution

Project Manager
Background
A master project workbook contains 12 sheets, one for each department's monthly progress.
Problem
Sending the entire workbook to every department is inefficient and poses a data privacy risk.
How to Use
Upload the master workbook, set the output format to XLSX, and use the prefix 'Dept_Report_'.
Outcome
The tool generates a ZIP file containing 12 separate files, each named 'Dept_Report_[SheetName].xlsx', ready for individual distribution.

2. Data Migration to JSON

Software Developer
Background
A legacy Excel file contains configuration data stored across multiple sheets.
Problem
The application requires this data in JSON format to be imported into a new system.
How to Use
Upload the Excel file and select 'JSON' as the output format.
Outcome
The tool outputs a ZIP file containing a JSON file for every sheet, allowing for immediate integration into the application.

Try with Samples

json, csv, xml
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
Copyright-Free AAC Audio Samples
High-quality AAC encoded audio samples for testing and development, featuring nature sounds and meditation music with excellent compression
preferred input family xlsx
xlsx
Copyright-Free OGG Vorbis Audio Samples
Open-source OGG Vorbis audio samples for testing and development, featuring excellent compression with nature sounds and meditation music
preferred input family xlsx
xlsx
CSV Samples
Sample CSV files with various data types, sizes, and complexity levels
matched family json,csv
json, csv

Related Hubs

Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Csv Convert Tools
Explore 37 csv tools for convert workflows and compare closely related utilities quickly.
Xml Convert Tools
Explore 32 xml tools for convert workflows and compare closely related utilities quickly.
Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.

FAQ

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.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-multi-sheet-splitter

Request Parameters

Parameter Name Type Required Description
excelFile file (Upload required) Yes -
outputFormat select No -
includeHiddenSheets checkbox No -
namingPrefix text No -

File type parameters need to be uploaded first via POST /upload/xlsx-multi-sheet-splitter to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-xlsx-multi-sheet-splitter": {
      "name": "xlsx-multi-sheet-splitter",
      "description": "Split a multi-sheet workbook into independent files by sheet name, with ZIP output",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-multi-sheet-splitter",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]