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.

Elysia Tools

Navigation

Format Conversion

XLSX Workbook Merger

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

Details

What this tool helps you do

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

Execution

Run this tool

Fill in the form, run the tool, and review the result in one place.

Prepared example runs

Click an example to fill the form automatically. File inputs still need an upload.

1 examples

Merge Multiple Files as Appended Rows

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

{
  "type": "file",
  "filePath": "/public/samples/xlsx/xlsx-workbook-merger-example1.xlsx"
}

Inputs

Set the required fields, then run the tool.

7 options

FilesUpload source files for this workflow.1

Source Excel FilesfileRequired

Per-file max size: 100 MB / Max files: 50Supported types: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

ContentPaste or type the main input values.3

Source Sheet NametextOptionalTarget Sheet NametextOptionalSource Column NametextOptional

SettingsAdjust formats, ranges, numbers, and modes.2

Merge ModeselectOptionalHeader RownumberOptional

TogglesEnable or disable optional behavior.1

Include Source File ColumncheckboxOptionalEnabled when checked

Result

Ready for a run

Run the tool to preview files, text, structured data, or streamed output here.

Samples

XLSX Workbook Merger

What this tool helps you do

Run this tool

Prepared example runs

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

Prepared example runs

Inputs

Result

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Overview

When to use

How it works

Use cases

Examples

1. Consolidating Regional Sales Data

2. Organizing Departmental Budgets

FAQ

XLSX Samples

XLS Samples

Nginx Log Parser Samples

Android Serialization Java Samples

XLSX Chart Embedder

XLSX Markdown Table Exporter

XLSX Multi Sheet Splitter

XLSX Print Setup Pack

Excel and XLSX Data Automation Tools

XLSX ETL, Import Normalization, and Warehouse Export Tools

XML Conversion, Mapping, and XPath Tools

KPI Dashboard and Report Pack Tools