How to split an XLSB file into multiple XLSB files

Sheetize XLSB‑Splitter for .NET provides a straightforward API for dividing a single large XLSB workbook into many smaller, macro‑enabled XLSB files. This is handy when you need to ship parts of a workbook, process data in parallel, or stay within size limits of downstream systems while keeping every macro and visual element intact.

Main Features

Split XLSB into multiple XLSB files

Select break‑points by row count, sheet count, or file‑size thresholds and generate independent XLSB files that each contain a subset of the original data.

Preserve Macros & Formatting

All VBA projects, cell styles, formulas, tables, charts, and embedded objects are retained exactly as they appear in the source workbook.

Streaming & Low‑Memory Processing

Works with massive workbooks (hundreds of MB) in a streaming fashion, ensuring a small memory footprint suitable for batch jobs or cloud functions.

Detailed Instructions

XLSB → Multiple XLSB Workflow

To split an XLSB file with Sheetize, follow these steps:

  1. Initialize the Splitter: Create an instance of SpreadsheetSplitter.
  2. Configure Split Options: Set SplitterSaveOptions to define the splitting criteria – maximum rows per file, maximum file size, or specific sheet groups.
  3. Define File Paths: Provide the source XLSB path and the destination folder where the split files will be written.
  4. Execute Splitting: Call Process with the prepared load and split options.

Example – Split a large XLSB by row count

var loadOptions = new LoadOptions
{
InputFile = "BigFinancialReport.xlsb"
};

var splitOptions = new SplitterSaveOptions
{
OutputFolder = @"E:\Splits\"
};

SpreadsheetSplitter.Process(loadOptions, splitOptions);

Expanded Format Support

  • The splitter can also output the chunks as XLSX or CSV if a macro‑free version is required.
  • Combined with Sheetize’s conversion utilities, you can chain operations: split XLSB → convert each part to CSV → import into a database.

With these capabilities, Sheetize makes breaking down massive XLSB workbooks effortless, whether you’re preparing data for distributed analysis, complying with file‑size policies, or simply organizing a complex workbook into manageable pieces.

 English