XLSX Workbook Merger

Merge multiple similarly structured workbooks as multiple sheets or append all rows into one sheet

Merge many Excel files into one workbook.

sheets mode: each source file becomes a sheet
append-rows mode: union rows into one target sheet
Optional source-file column for traceability

Example Results

1 examples

Merge Multiple Files as Appended Rows

Combine similarly structured workbooks into one sheet and keep source filename column

xlsx-workbook-merger-example1.xlsx View File

View input parameters

{ "sourceFiles": [ "/public/samples/xlsx/workbook-sales.xlsx", "/public/samples/xlsx/xlsx-column-mapper-example1.xlsx" ], "mergeMode": "append-rows", "sourceSheetName": "Sheet1", "targetSheetName": "Merged", "includeSourceFileColumn": true }

Source Excel Files *

Click to upload files or drag and drop files here

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

Merge Mode

Source Sheet Name

Target Sheet Name

Header Row

Include Source File Column

Source Column Name

Key Facts

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

Overview

Merge many Excel files into one workbook. - **sheets** mode: each source file becomes a sheet - **append-rows** mode: union rows into one target sheet - Optional source-file column for traceability

When to Use

•Use it when you need to convert xml, xlsx 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 Source Excel Files, Merge Mode, Source Sheet Name, Target Sheet Name as input to the tool.
•The tool processes the request and returns a file result.
•For file workflows, start with representative samples such as xml, xlsx test files to verify edge cases and output quality.

Use Cases

Convert xml, xlsx 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

xml, xlsx, xls

XLSX Samples

Sample XLSX spreadsheets for worksheet parsing and data extraction testing

title token xlsx

xlsx, xls

High-quality AAC encoded audio samples for testing and development, featuring nature sounds and meditation music with excellent compression

preferred input family xlsx

xlsx

Open-source OGG Vorbis audio samples for testing and development, featuring excellent compression with nature sounds and meditation music

preferred input family xlsx

xlsx

Text Case Format Samples

Examples of different text case formats: camelCase, snake_case, kebab-case, PascalCase, and more

preferred input family xml

xml

Related Hubs

Xml Convert Tools

Explore 32 xml tools for convert workflows and compare closely related utilities quickly.

Json Convert Tools

Explore 100 json tools for convert workflows and compare closely related utilities quickly.

Image Convert Tools

Explore 100 image tools for convert workflows and compare closely related utilities quickly.

Audio Convert Tools

Explore 100 audio tools for convert workflows and compare closely related utilities quickly.

FAQ

What does XLSX Workbook Merger do?

XLSX Workbook Merger helps you convert xml, xlsx 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 Workbook Merger accept?

XLSX Workbook Merger accepts Source Excel Files, Merge Mode, Source Sheet Name, Target Sheet Name and supports file uploads for 1 field.

Is there an API for XLSX Workbook Merger?

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-workbook-merger

Request Parameters

Parameter Name	Type	Required	Description
sourceFiles	file (Upload required)	Yes	-
mergeMode	select	No	-
sourceSheetName	text	No	-
targetSheetName	text	No	-
headerRow	number	No	-
includeSourceFileColumn	checkbox	No	-
sourceFileColumnName	text	No	-

File type parameters need to be uploaded first via POST /upload/xlsx-workbook-merger 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-workbook-merger": {
      "name": "xlsx-workbook-merger",
      "description": "Merge multiple similarly structured workbooks as multiple sheets or append all rows into one sheet",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-workbook-merger",
      "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]

Categories