How to split an XLSX file into multiple XLSX files

Sheetize XLSX‑Splitter for .NET offers a straightforward API to divide a single workbook into many smaller workbooks while keeping every worksheet, chart, table, and formatting intact. Use it when you need one file per sheet, or when you must split a massive sheet into fixed‑size chunks for downstream processing.

Main Features

Split by Worksheet

Create an individual XLSX file for each sheet in the source workbook, optionally naming the files after the sheet titles.

Split by Row Limit

Break a large sheet into multiple files, each containing a maximum number of rows (e.g., 10 000 rows per file).

Preserve Formatting & Objects

All cell styles, formulas, tables, charts, and images are retained exactly as they appear in the original file.

Streaming Support

Handle very large workbooks with low memory footprints by processing rows in a streaming manner.

Detailed Instructions

XLSX → Multiple XLSX Workflow

Follow these steps to split an XLSX workbook using Sheetize:

  1. Initialize the Splitter: Create an instance of SpreadsheetSplitter.
  2. Define Paths: Provide the source XLSX path and the output directory where the parts will be written.
  3. Execute Splitting: Call Process with the prepared load and save options.

Example – Split a workbook by sheet

var loadOptions = new LoadOptions
{
InputFile = @"C:\Data\BigReport.xlsx"
};

var saveOptions = new SplitterSaveOptions
{
OutputFolder = @"C:\Data\BigReport\Parts\",
SplitMode = SplitMode.BySheet,
// Optional: customize file names
FileNamePattern = "{SheetName}.xlsx"
};

SpreadsheetSplitter.Process(loadOptions, saveOptions);

Expanded Format Support

  • The splitter can also work on CSV or TSV exports, generating multiple files with identical row‑limit logic.
  • After splitting, you may pipe each part directly into downstream converters (e.g., XLSX → PDF, XLSX → JSON) using Sheetize’s streaming API.

With Sheetize’s XLSX‑Splitter, breaking down large workbooks into manageable pieces becomes a one‑liner, letting you focus on analysis instead of file‑management headaches.

 English