XLSB · 5 XLSB workbooks

Sample XLSB Binary Spreadsheet Files

Download free, validated XLSB (.xlsb) binary workbooks for testing upload filters, pyxlsb parsers, and high-volume data models from 100 to 10,000 rows.

5 XLSB workbooks 100 – 10,000 rows · 12 KB – 283 KB BIFF12 Binary · ISO/IEC 29500

Direct Downloads

Available XLSB Sample Workbooks

5 XLSB workbooks

RowsSizeWorkbook NameData DomainFormatDownload

100 rows

12.6 KB

100 Rows Financial Ledger & Settlement

Data Domain:Financial Accounting & Settlement

XLSB Download XLSB

500 rows

20.7 KB

500 Rows Supply Chain & Global Inventory

Data Domain:Supply Chain & Global Inventory

XLSB Download XLSB

1,000 rows

39.5 KB

1,000 Rows Commercial Real Estate Sales

Data Domain:Commercial Real Estate & Valuation

XLSB Download XLSB

5,000 rows

142.7 KB

5,000 Rows Industrial IoT Sensor Telemetry

Data Domain:Industrial IoT High-Frequency Stream

XLSB Download XLSB

10,000 rows

276.7 KB

10,000 Rows Quantitative Market Trading Quotes

Data Domain:High-Volume Market Quotes & Liquidity

XLSB Download XLSB

XLSB Technical Architecture

Architecture & High-Performance Testing Guide for Excel Binary Workbooks (XLSB)

XLSB (Excel Binary Workbook) is an Open Packaging Conventions (OPC) spreadsheet package that stores workbook structure, worksheet cells, formulas, and formatting as compact binary streams rather than XML documents. Defined under the Microsoft Open Specifications [MS-XLSB] and ISO/IEC 29500, XLSB delivers up to 50% smaller file sizes and 2× faster load times, making it the industry standard for quantitative finance, algorithmic trading, and massive enterprise data models.

History & Architectural Evolution: From BIFF8 to BIFF12

When Microsoft introduced Office Open XML in Office 2007 to modernize legacy binary files (.xls, BIFF8), the primary focus was human-readable XML. However, enterprise users working with multi-hundred-megabyte models quickly encountered steep performance penalties: XML parsing required immense CPU memory allocations and bloated file sizes due to repetitive opening and closing tags.

To solve this problem without abandoning the open ZIP container architecture, Microsoft engineered the BIFF12 format (Binary Interchange File Format version 12) under the extension .xlsb.

Unlike legacy .xls (which relied on monolithic OLE structured storage), XLSB adopts the modern Open Packaging Conventions (OPC) ZIP envelope. Crucially, it replaces verbose XML components like sheet1.xml and sharedStrings.xml with optimized binary records like sheet1.bin and sharedStrings.bin, achieving the ideal balance of open container packaging and raw binary speed.

Format Mechanics: Inside the BIFF12 Record Structure

The performance gains of XLSB stem from its deterministic byte-level record layout:

Variable-Length Record Headers

Every record in an XLSB binary stream begins with a compact record type identifier (1 to 2 bytes) and a 32-bit payload length, enabling zero-copy seeking through unused records.

Zero XML Serialization Overhead

Numbers, dates, and IEEE 754 floating-point values are stored directly as raw binary integers and double-precision bytes, bypassing CPU-intensive text-to-number parsing.

Shared String Binary Indexing

Repetitive string tokens are stored once in xl/sharedStrings.bin with a fast 4-byte index table, drastically reducing memory footprint during multi-sheet operations.

Optional VBA Macro Support

Like XLSM, XLSB can store embedded VBA macro routines in xl/vbaProject.bin, but without changing its .xlsb file extension.

Performance Benchmarks: XLSB vs XLSX vs CSV

Empirical comparisons across file footprint, parsing latency, and memory consumption on large tabular datasets:

Metric / Dimension	XLSX (Standard OpenXML)	XLSB (BIFF12 Binary)	Performance Advantage
On-Disk File Size (100k rows) ~50% reduction in storage and bandwidth	18.4 MB	9.2 MB	~50% reduction in storage and bandwidth
Parse & Load Time 2.3× faster ingestion throughput	4.8 seconds	2.1 seconds	2.3× faster ingestion throughput
Parser RAM Consumption 56% lower peak heap allocation	480 MB	210 MB	56% lower peak heap allocation
Data Type Precision Zero precision loss from string rounding	Text-encoded floats	Native IEEE 754 64-bit	Zero precision loss from string rounding

Developer Ingestion & Parsing Libraries

Standard XML-only tools like openpyxl cannot parse XLSB files. High-throughput pipelines rely on specialized binary libraries:

Library / Framework	Ecosystem	Native Syntax / Ingestion	Optimization Notes
calamine (Python / Rust)	Python / Rust	import python_calamine; workbook = python_calamine.load_workbook('data.xlsb') Rust-powered engine, fastest spreadsheet reader available across all languages.	Rust-powered engine, fastest spreadsheet reader available across all languages.
pyxlsb	Python	from pyxlsb import open_workbook; with open_workbook('data.xlsb') as wb: ... Pure-Python zero-dependency streaming iterator for XLSB rows.	Pure-Python zero-dependency streaming iterator for XLSB rows.
Apache POI	Java / Kotlin	new XSSFBReader(new OPCPackage(new File('data.xlsb'))) Enterprise Java streaming event API for BIFF12 workbook parts.	Enterprise Java streaming event API for BIFF12 workbook parts.
EPPlus / ClosedXML	.NET / C#	using var package = new ExcelPackage(new FileInfo('data.xlsb')); Native C# support for high-volume financial accounting pipelines.	Native C# support for high-volume financial accounting pipelines.

QA Testing & File Gateway Validation Checklist

When evaluating web upload forms, microservices, or antivirus sandboxes with XLSB files, verify the following quality criteria:

Verify that upload gateways recognize MIME type application/vnd.ms-excel.sheet.binary.macroEnabled.main along with .xlsb extensions.
Confirm that streaming ETL parsers gracefully handle binary records without attempting to read them as UTF-8 XML.
Test server-side conversion pipelines (e.g., XLSB to CSV or Parquet) to verify numeric floating-point accuracy.
Check whether antivirus scanners inspect compressed binary streams (BIFF12) without false-positive triggers.
Ensure that upload size limit checks reflect the fact that an XLSB file holds twice as much tabular data as an equal-sized XLSX file.
Validate error reporting when users upload an XLSB containing VBA code to a form that permits only macro-free data.

XLSB Technical Specifications

Standard Specification: Microsoft [MS-XLSB] / ISO/IEC 29500 / ECMA-376
MIME Media Type: application/vnd.ms-excel.sheet.binary.macroEnabled.main
File Extension: .xlsb
Internal Stream Format: Binary Interchange File Format version 12 (BIFF12)
Container Architecture: Open Packaging Conventions (OPC) ZIP Package
First Introduced: Microsoft Office 2007
Typical Compression Advantage: 35% – 55% smaller than equivalent XLSX

About the XLSB format

XLSB (Excel Binary Workbook) is the high-performance binary spreadsheet format introduced in Microsoft Office 2007, defined under the [MS-XLSB] BIFF12 specification.

Binary BIFF12 streams

Unlike XML-based XLSX files, XLSB encodes worksheet cells, formulas, formatting, and shared strings in compact binary records, reducing file size by up to 50% and dramatically accelerating load times.

Open Packaging Conventions (OPC)

An XLSB file remains a standard ZIP archive conforming to ISO/IEC 29500, but replaces XML parts with .bin streams such as xl/workbook.bin and xl/worksheets/sheet1.bin.

Enterprise quantitative finance

XLSB is the preferred format in financial modeling, investment banking, and large data warehouses for workbooks exceeding hundreds of megabytes or millions of calculations.

Source article: Wikipedia: Microsoft Excel (File formats)

Frequently Asked Questions About XLSB Files

What is an XLSB file and how does it differ from XLSX?+

An XLSB file is an Excel Binary Workbook. While standard .xlsx files store workbook information in human-readable XML files inside a ZIP container, .xlsb files store data in binary streams (BIFF12). This makes XLSB files up to 50% smaller on disk and significantly faster to read and save in Excel.

Why do financial institutions and hedge funds prefer XLSB?+

Quantitative finance teams and risk modelers work with massive spreadsheets containing millions of formula cells, market quotes, and cash flow schedules. Using XLSX causes sluggish load times, high RAM consumption, and crashes. XLSB drastically cuts file opening times from minutes to seconds.

Can Python libraries like Pandas or OpenPyXL read XLSB files?+

Standard openpyxl does not support XLSB. However, you can read XLSB files in Python using pandas by specifying the pyxlsb engine (pd.read_excel("file.xlsb", engine="pyxlsb")) or using python-calamine, which is written in Rust and delivers blazing-fast parsing speeds.

Can an XLSB file contain VBA macros?+

Yes. Unlike the XLSX format (which strips macros), XLSB workbooks can contain embedded Visual Basic for Applications (VBA) code without changing the .xlsb extension. Antivirus gateways should always inspect XLSB files for embedded vbaProject.bin parts.

When should I choose XLSB over standard XLSX?+

Choose XLSB when dealing with large datasets (over 50,000 rows), complex financial models with heavy formula calculations, or when file size limits on email attachments and cloud storage are a concern. Use XLSX when maximum compatibility with simple third-party web tools is required.