How to merge multiple xlsb files

Sheetize XLSB Merger for .NET provides a simple yet powerful API for combining several XLSB workbooks into a single file while preserving all worksheets, charts, and formatting. This is useful when you need to consolidate reports, aggregate data, or prepare a master workbook for distribution.

Main Features

Merge Multiple XLSB Files

Combine an arbitrary number of XLSB workbooks into one consolidated workbook. The merger maintains sheet order and can optionally rename sheets to avoid conflicts.

Preserve Formatting & Objects

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

Streaming Support

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

Detailed Instructions

XLSB Merge Workflow

To merge XLSB files with Sheetize, follow these steps:

  1. Initialise the Merger: Create an instance of SpreadsheetMerger.
  2. Configure Options: Set SaveOptions if you need custom sheet naming, ordering, or conflict resolution.
  3. Define File Paths: Provide an array of source XLSB paths and the destination merged XLSB location.
  4. Execute Merge: Call Process with the prepared options.

Example – Merge three XLSB files into a single workbook

using Sheetize;

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

SpreadsheetMerger.Process(loadOptions, saveOptions, new string[]
{
    "Q1_Sales.xlsb",
    "Q2_Sales.xlsb",
    "Q3_Sales.xlsb",
});

Expanded Format Support

  • Sheetize can also merge CSV, TSV, and HTML exports generated from workbooks (the resulting files are wrapped in a ZIP with optional encryption).

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

 Українська