Skip to content

start:

Spreadsheet Project - Filter Test Documents

File Formats Overview

File FormatExtensionNote
BIFF2.xlsBinary format used by MS Excel 2.x
BIFF3.xlsBinary format used by MS Excel 3.0
BIFF4.xlsBinary format for worksheets used by MS Excel 4.0
BIFF4W.xlwBinary format for workbooks used by MS Excel 4.0
BIFF5.xlsBinary format used by MS Excel 5.0 and 95
BIFF8.xlsBinary format used by MS Excel 97, 2000, XP, and 2003
OOXML3.xlsxOffice Open XML format written by the XML plugin of MS Excel 2003
OOBIN3.xlsbBinary format written by the XML plugin of MS Excel 2003
OOXML7.xlsxOffice Open XML format used by MS Excel 2007
OOBIN7.xlsbBinary format used by MS Excel 2007

Test Documents

Sheet Types
These documents contain different types of sheets (worksheets, chart sheets, macro sheets, ...).
BIFF4W BIFF5 BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
Cell Contents
These documents contain basic cell contents (numbers, texts, error codes, formulas).
BIFF2 BIFF3 BIFF4 BIFF5 BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
These documents contain cells with data validation settings.
BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
Cell Formatting
These documents contain formatted cells and cell styles.
BIFF2 BIFF3 BIFF4W BIFF5 BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
These documents contain all available built-in number formats.
OOXML7
These documents contain cells with conditional formatting.
BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
Formulas, Functions, Defined Names
These documents contain formulas (cell formulas, array formulas, shared formulas, table operations, functions).
BIFF2 BIFF3 BIFF4W BIFF5 BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7 ODS
These documents contain defined names (local and global names, built-in names).
BIFF5 BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
External Links, Hyperlinks
The target documents for external links and hyperlinks: targets.zip
These documents contain formula links to external documents.
BIFF2 BIFF3 BIFF4W BIFF5 BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
These documents contain hyperlinks.
BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
Sheet Settings
These documents contain page and print settings on different sheets.
BIFF5 BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
These documents contain view settings on different sheets.
BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
These documents contain protection settings on different sheets.
BIFF8 OOXML3 OOBIN3 OOXML7 OOBIN7
Drawing Layer
These documents contain various drawing objects.
OOXML7 OOBIN7
Charts
These documents contain samples of different chart types.
Bar/column charts OOXML7
Area charts OOXML7
Line/stock charts OOXML7
Scatter/bubble charts OOXML7
Radar charts OOXML7
Pie/doughnut charts OOXML7
Surface charts OOXML7
These documents contain charts with different 3D settings.
BIFF8 OOXML3 OOXML7
These documents contain charts with formatted chart elements.
OOXML7