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

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

When to Use

  • •Use it when you need to convert json, csv content quickly in the browser.
  • •Helpful for format conversion workflows that need repeatable inputs and fast results.
  • •A good fit when you want to test with real files before running the same workflow in code or API calls.

How It Works

  • •Provide Excel File, Output Format, Include Hidden Sheets, Output File Prefix as input to the tool.
  • •The tool processes the request and returns a file result.
  • •For file workflows, start with representative samples such as json, csv test files to verify edge cases and output quality.

Use Cases

Convert json, csv data during debugging or QA.
Validate expected output before using the API or automation flows.
Test the workflow with representative sample files and edge cases.

Try with Samples

json, csv, xml
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
Web Data Serialization Rust Samples
Web Rust data serialization examples including JSON serialization, deserialization, and XML parsing
preferred input family xml
xml
Windows Serialization C++ Samples
Windows C++ data serialization examples including JSON serialization/deserialization and XML parsing
preferred input family xml
xml
Web Data Serialization Go Samples
Web Go data serialization examples including JSON encoding/decoding and XML parsing
preferred input family xml
xml

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 does XLSX Multi Sheet Splitter do?

XLSX Multi Sheet Splitter helps you convert json, csv content online without setting up a separate local script or app.

When should I use this tool?

Use it when you need a quick convert workflow, want to verify output, or need a browser-based utility for format conversion tasks.

Can I try this tool with sample data?

Yes. This page can recommend related sample files so you can test the workflow immediately.

What inputs does XLSX Multi Sheet Splitter accept?

XLSX Multi Sheet Splitter accepts Excel File, Output Format, Include Hidden Sheets, Output File Prefix and supports file uploads for 1 field.

Is there an API for XLSX Multi Sheet Splitter?

Yes. The tool page includes an API endpoint so you can move from manual testing to scripted usage.

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]