How to merge multiple XLSX files

Step‑by‑step guide to using Sheetize for merging several XLSX files into a single workbook, ensuring data consolidation and format preservation.

Sheetize XLSX Merger for .NET offers a straightforward yet powerful API for combining multiple Excel workbooks into one while keeping all worksheets, charts and formatting intact. This is handy when you need to consolidate reports, aggregate data, or create 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 many files.

Detailed Instructions

XLSX Merge Workflow

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

  1. Initialise the Merger – create an instance of SpreadsheetMerger.
  2. Configure Options – set SaveOptions such as the 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 every day.

 Українська