How to merge multiple XLSX files

Sheetize XLSX Merger for .NET provides a simple yet powerful API for combining multiple Excel workbooks into one while keeping all worksheets, charts, and formatting intact. This is useful when you need to consolidate reports, aggregate data, or generate a master file for distribution.

Main Features

Merge Multiple XLSX Files

Combine an arbitrary number of XLSX workbooks into a single workbook. Each source file retains its original sheet names (or can be renamed) in the merged output.

Preserve Formatting & Objects

All cell styles, formulas, tables, charts, and images remain intact after the merge.

Streaming Support

Process large workbooks in a streaming fashion to keep memory usage low, ideal for batch merging of many files.

Detailed Instructions

XLSX Merge Workflow

To merge several XLSX files with Sheetize, follow these steps:

  1. Initialize the Merger: Create an instance of SpreadsheetMerger.
  2. Configure Options: Set SaveOptions such as output file path and optional sheet name prefixes.
  3. Provide Source Paths: Supply an array of source XLSX file paths.
  4. Execute Merge: Call Process with the prepared options.

Example – Merge three XLSX files into one

using Sheetize;

var loadOptions = new LoadOptions();
var saveOptions = new SaveOptions
{
OutputFile = "E:\\MergedWorkbook.xlsx"
};

SpreadsheetMerger.Process(loadOptions, saveOptions, new string[]
{
"Baby_growth_tracker.xlsx",
"Bills_to_pay.xlsx",
"Financial_summary.xlsx",
});

Expanded Format Support

  • Sheetize can also merge CSV, TSV, and HTML exports, converting them into a single XLSX workbook.

With these capabilities, Sheetize makes XLSX merging effortless, whether you need a quick script or a production‑grade service that consolidates thousands of spreadsheets daily.

 English