XLSX Sheet to CSV Pack

Export each Excel worksheet as an individual CSV file and include a manifest with schema/statistics

Convert workbook sheets into a CSV package.

  • One CSV per sheet
  • manifest.json includes sheet name, row count, column names, delimiter, and encoding
  • Returns a ZIP archive

Example Results

1 examples

Export Workbook Sheets to CSV Pack

Create one CSV per sheet plus manifest.json in a ZIP package

xlsx-sheet-to-csv-pack-example1.zip View File
View input parameters
{ "excelFile": "/public/samples/xlsx/workbook-sales.xlsx", "delimiter": ",", "outputEncoding": "utf-8-bom" }

Click to upload file or drag and drop file here

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

Key Facts

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

Overview

The XLSX Sheet to CSV Pack tool enables you to efficiently convert complex Excel workbooks into a structured ZIP archive, where each worksheet is exported as an individual CSV file accompanied by a comprehensive manifest.json file detailing schema and data statistics.

When to Use

  • •When you need to extract multiple worksheets from a single Excel file into separate, machine-readable CSV files.
  • •When you require a standardized manifest file to track row counts, column names, and encoding for automated data pipelines.
  • •When you want to batch-process large workbooks while maintaining data integrity and specific character encoding requirements.

How It Works

  • •Upload your Excel file and select specific sheets if you wish to filter the output.
  • •Configure your preferred CSV delimiter, output encoding, and header preferences.
  • •Process the file to generate a ZIP archive containing individual CSVs for each sheet and a manifest.json file.
  • •Download the resulting ZIP package to access your structured data files.

Use Cases

Preparing multi-tab financial reports for ingestion into database systems or data analysis platforms.
Standardizing large Excel workbooks into clean, individual CSV files for version control or archival purposes.
Automating data extraction workflows where a manifest file is required to verify data structure before processing.

Examples

1. Batch Exporting Sales Data

Data Analyst
Background
A monthly sales report contains 12 separate sheets, one for each region, which need to be imported into a SQL database.
Problem
Manually saving each sheet as a CSV is error-prone and time-consuming.
How to Use
Upload the workbook, select the comma delimiter, and set the encoding to UTF-8.
Example Config
delimiter: ',', outputEncoding: 'utf-8', includeHeader: true
Outcome
A ZIP file containing 12 distinct CSV files and a manifest.json file, ready for automated database ingestion.

2. Legacy System Data Migration

IT Administrator
Background
Migrating legacy inventory data stored in an Excel workbook to a system that requires GBK encoding.
Problem
Standard exports often result in character corruption when moving between systems with different encoding standards.
How to Use
Upload the inventory file and explicitly select 'GBK' from the output encoding options.
Example Config
outputEncoding: 'gbk', skipHiddenSheets: true
Outcome
A ZIP package with correctly encoded CSV files that maintain character integrity for the legacy system.

Try with Samples

csv, xml, xlsx
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
title token csv
csv

Related Hubs

Csv Convert Tools
Explore 38 csv tools for convert workflows and compare closely related utilities quickly.
Xml Convert Tools
Explore 33 xml tools for convert workflows and compare closely related utilities quickly.
Csv Tools
Explore 9 csv tools for utility workflows and compare closely related utilities quickly.
Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.

FAQ

What is included in the manifest.json file?

The manifest includes metadata for each exported sheet, such as the sheet name, total row count, column headers, delimiter used, and the file encoding.

Can I choose which sheets to export?

Yes, you can specify individual sheet names in the 'Selected Sheets' field, separated by commas, to export only the data you need.

Does the tool support different character encodings?

Yes, you can select from UTF-8 with BOM, standard UTF-8, or GBK encoding to ensure compatibility with your target system.

What happens to hidden sheets?

By default, the tool is configured to skip hidden sheets, but you can adjust this setting based on your specific requirements.

In what format is the final output delivered?

The output is delivered as a single ZIP archive containing all individual CSV files and the manifest.json file.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-sheet-to-csv-pack

Request Parameters

Parameter Name Type Required Description
excelFile file (Upload required) Yes -
selectedSheets text No -
delimiter select No -
outputEncoding select No -
includeHeader checkbox No -
skipHiddenSheets checkbox No -

File type parameters need to be uploaded first via POST /upload/xlsx-sheet-to-csv-pack 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-sheet-to-csv-pack": {
      "name": "xlsx-sheet-to-csv-pack",
      "description": "Export each Excel worksheet as an individual CSV file and include a manifest with schema/statistics",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-sheet-to-csv-pack",
      "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]