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 }

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

Key Facts

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

Overview

The XLSX Workbook Merger is a powerful utility designed to consolidate multiple Excel files into a single workbook, allowing you to either organize data into separate sheets or aggregate rows into one master dataset.

When to Use

  • •When you need to combine monthly reports from different departments into a single master file.
  • •When you want to aggregate data from multiple individual Excel files into one continuous table for analysis.
  • •When you need to keep track of data origins by automatically adding a source filename column to your merged records.

How It Works

  • •Upload your source Excel files and select your preferred merge mode: 'As Separate Sheets' or 'Append Rows'.
  • •Specify the source sheet name and the target sheet name to ensure data is pulled from and placed into the correct locations.
  • •Configure optional settings like the header row index and enable the source file column to maintain traceability.
  • •Process the files to generate a single, unified XLSX workbook ready for download.

Use Cases

Consolidating regional sales spreadsheets into a single national performance report.
Merging individual survey response files into one master dataset for statistical analysis.
Archiving multiple project tracking sheets into one organized workbook for long-term storage.

Examples

1. Consolidating Regional Sales Data

Data Analyst
Background
An analyst receives 12 separate monthly sales reports from different regions, all sharing the same column structure.
Problem
Manually copying and pasting thousands of rows into one master file is error-prone and slow.
How to Use
Upload all 12 files, select 'Append Rows' mode, and enable 'Include Source File Column' to track regional origins.
Example Config
mergeMode: 'append-rows', includeSourceFileColumn: true, sourceFileColumnName: 'region_source'
Outcome
A single master Excel file containing all sales data with an added 'region_source' column for easy filtering.

2. Organizing Departmental Budgets

Background
A finance manager needs to collect budget proposals from five different departments into one review file.
Problem
Keeping five separate files makes it difficult to compare budget allocations side-by-side.
How to Use
Upload the five budget files and select 'As Separate Sheets' mode to keep each department's data distinct but accessible in one workbook.
Example Config
mergeMode: 'sheets'
Outcome
A single workbook containing five distinct sheets, one for each department, allowing for quick tab-switching during budget reviews.

Try with Samples

xml, xlsx, xls
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
Text Case Format Samples
Examples of different text case formats: camelCase, snake_case, kebab-case, PascalCase, and more
matched family xml
xml

Related Hubs

Xml Convert Tools
Explore 33 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

Can I merge files with different structures?

The tool works best with similarly structured workbooks. When using 'Append Rows' mode, ensure your columns align across files for the best results.

What is the difference between the two merge modes?

'As Separate Sheets' creates a new tab for each file, while 'Append Rows' stacks all data into one single sheet.

How do I keep track of which file the data came from?

Enable the 'Include Source File Column' option, and the tool will add a column containing the original filename to every row.

Is there a limit to the number of files I can merge?

You can upload up to 50 files at once, provided the total size does not exceed 200MB.

Can I specify which row contains my headers?

Yes, use the 'Header Row' input to define the row number where your column titles are located.

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]