Excel Data Transformer: Merge & Split Excel Files

Powerful Excel Merge & Split Features

All the tools you need to merge and split Excel files locally - support Windows, Linux, and macOS

Merge Excel Workbooks

Combine multiple Excel workbooks into a single file with just one click

Merge multiple XLS/XLSX files into one
Preserve all formatting and formulas
Customize merge order and structure
Support batch merging of up to 100 files

Merge Excel Worksheets

Combine multiple worksheets from one or more workbooks into a single sheet

Merge sheets within the same workbook
Merge sheets across different workbooks
Keep or remove duplicate rows
Preserve column headers and styles

Split Excel Workbook

Split a single Excel workbook into multiple separate files

Split workbook by worksheets
Custom output file naming rules
Split large files into smaller chunks
Preserve original file formatting

Split Excel Worksheet

Split a single worksheet into multiple sheets or files based on rules

Split by rows, columns, or value
Custom split criteria and rules
Split into multiple sheets or files
Preview split results before export

Blazing Fast Processing

Process large Excel files with millions of rows in minutes

Support files up to 1GB in size
Multi-threaded processing
No data loss or corruption
Fast batch processing

Cross-Platform Support

Works seamlessly on all major operating systems

Full support for Windows (10/11)
Full support for Linux (Ubuntu/Debian)
Full support for macOS (10.15+)
Consistent experience across platforms

How It Works (3 Simple Steps)

Merge or split your Excel files in less than a minute - no internet required

Select Operation

Choose merge (workbook/worksheet) or split (workbook/worksheet) function

Select Files

Choose the Excel files/sheets you want to process and set options

Process & Save

Click process and save the result to your local drive - done in seconds

What People Merge and Split

Two directions, four kinds of job. Split: one workbook with 40 worksheets is hard to send around, so each worksheet is written to its own file in one pass - or a single large worksheet is divided by row count, or by a column value. Merge: many workbooks into one, the sheets of several files into a single sheet, or all the sheets of one workbook into one - the repeated header row is skipped, so the months can be stacked without a header in the middle. (Columns go in by position: files whose column order differs have to be aligned first, which is what merge worksheets spells out.)

Forty sheets, and each department wants theirs

Write every worksheet to its own file in one pass, named after the sheet.

Twelve monthly workbooks, one for the year

Combine a year of monthly exports into one workbook - sheet names kept, repeated headers skipped.

Everyone sent a sheet

The sheets of fifteen returned workbooks into a single sheet, under one set of headers.

One sheet with every department in it

Split a worksheet by a column value so each department gets only their own rows.

The server has no Excel, and no Office licence

Merge and split workbooks on a Linux server, a build agent or a scheduled task.

Frequently Asked Questions

Answers to the most common questions about our Excel merge & split tool

What operating systems are supported? +

Excel Data Transformer supports Windows (10/11 64-bit), Linux (Ubuntu 20.04+, Debian 11+, CentOS 8+), and macOS (10.15 Catalina, Big Sur, Monterey, Ventura, Sonoma). The tool provides a consistent experience across all supported platforms.

Do I need Microsoft Excel installed to use this tool? +

No, you do not need Microsoft Excel or any Office software installed. Our tool has its own built-in Excel file parsing engine that can read and process XLS/XLSX files independently of Microsoft Excel. This makes it perfect for systems without Office installed.

Is the tool really 100% offline? +

Yes! Excel Data Transformer works completely offline. All file processing happens locally on your computer - no data is ever uploaded to our servers or any cloud service. The only time you need internet is when downloading the installer.

What Excel file formats are supported? +

We support all major Excel formats including XLS (Excel 97-2003), XLSX (Excel 2007+), XLSM (macro-enabled), XLSB (binary), and CSV files. The tool can handle both old and new Excel file formats seamlessly.

Can I merge/split large Excel files? +

Yes! Our tool is optimized for large files and can handle Excel files up to 1GB in size with millions of rows, and there's no hard limit on the number of files you can merge or split.

How do I split an Excel workbook into multiple files? +

Choose "Split Excel Workbook", select the workbook and the output folder, then run. Each worksheet is written to its own file, with the sheet name used as the file name. A single worksheet can also be split by row count or by a column value.

How do I merge multiple Excel files into one? +

Choose "Merge Excel Workbooks" and add the files in the order you want. The sheets are combined into one workbook or into a single sheet. A repeated header row is detected and skipped; the columns themselves are appended by position, so every source file must use the same column order.

What is data transformation in Excel? +

Inside Excel, "data transformation in Excel" usually means reshaping data in a sheet with Power Query, formulas or pivot tables. ExcelDataTransformer does Excel data transformation one level up, on the files themselves: it merges Excel workbooks and worksheets into one file, or splits one workbook into many files, without opening Excel.