BIFF8 record types

Every record in a BIFF8 stream starts with a 2-byte type (see record header). This is the complete list of types in [MS-XLS] section 2.3, in number order, with the name Microsoft uses and what each record holds; the full field layout of each is in section 2.4 under its name. The records most readers need are described on the Cells, Strings and Formulas pages; field layouts of the other records are on workbook settings, styles and conditional formats and worksheet settings. Types 0x1001–0x1068 appear only in chart substreams; names starting SX belong to PivotTables, RR to shared-workbook revisions.

All record types

Type	Name	Holds
`0x0006`	Formula	A cell with a formula and its last value.
`0x000A`	EOF	End of a substream.
`0x000C`	CalcCount	Iteration count for iterative calculation.
`0x000D`	CalcMode	Manual, automatic or automatic-except-tables calculation.
`0x000E`	CalcPrecision	Calculate with full precision or as displayed.
`0x000F`	CalcRefMode	A1 or R1C1 reference style.
`0x0010`	CalcDelta	Smallest change that ends iteration.
`0x0011`	CalcIter	Whether iterative calculation is on.
`0x0012`	Protect	Sheet or workbook protection state.
`0x0013`	Password	Password verifier for sheet or workbook protection.
`0x0014`	Header	Printed page header text.
`0x0015`	Footer	Printed page footer text.
`0x0017`	ExternSheet	Table of sheet references (XTI) used by 3-D formulas.
`0x0018`	Lbl	A defined name.
`0x0019`	WinProtect	Whether workbook windows are locked.
`0x001A`	VerticalPageBreaks	Manual column page breaks.
`0x001B`	HorizontalPageBreaks	Manual row page breaks.
`0x001C`	Note	A cell comment.
`0x001D`	Selection	Selected cells in a pane.
`0x0022`	Date1904	Whether dates count from 1904 instead of 1900.
`0x0023`	ExternName	An external name, add-in function or DDE/OLE link item.
`0x0026`	LeftMargin	Left print margin.
`0x0027`	RightMargin	Right print margin.
`0x0028`	TopMargin	Top print margin.
`0x0029`	BottomMargin	Bottom print margin.
`0x002A`	PrintRowCol	Print row and column headings.
`0x002B`	PrintGrid	Print gridlines.
`0x002F`	FilePass	Encryption method and password check.
`0x0031`	Font	A font.
`0x0033`	PrintSize	Printed size of a chart.
`0x003C`	Continue	Continuation of the previous record’s data.
`0x003D`	Window1	Workbook window position, size and active sheet.
`0x0040`	Backup	Save a backup copy.
`0x0041`	Pane	Frozen or split panes.
`0x0042`	CodePage	Code page of the workbook’s 8-bit text.
`0x004D`	Pls	Printer settings and driver data.
`0x0050`	DCon	Data consolidation settings.
`0x0051`	DConRef	A range used as a data source.
`0x0052`	DConName	A named range used as a data source.
`0x0055`	DefColWidth	Default column width.
`0x0059`	XCT	Start of an external cell cache.
`0x005A`	CRN	Cached values of cells in an external sheet.
`0x005B`	FileSharing	Read-only recommendation and write password.
`0x005C`	WriteAccess	Name of the user who last saved the file.
`0x005D`	Obj	Properties of a drawing object or form control.
`0x005E`	Uncalced	Formulas were awaiting recalculation when saved.
`0x005F`	CalcSaveRecalc	Recalculate before saving.
`0x0060`	Template	The workbook is a template.
`0x0061`	Intl	The macro sheet is an international macro sheet.
`0x0063`	ObjProtect	Object protection state.
`0x007D`	ColInfo	Width, format and visibility of a range of columns.
`0x0080`	Guts	Outline gutter sizes and levels.
`0x0081`	WsBool	Sheet options, including dialog sheet and fit-to-page.
`0x0082`	GridSet	Reserved value.
`0x0083`	HCenter	Centre horizontally when printed.
`0x0084`	VCenter	Centre vertically when printed.
`0x0085`	BoundSheet8	A sheet’s name, type, visibility and stream offset.
`0x0086`	WriteProtect	The file is write-protected.
`0x008C`	Country	Locale of the workbook.
`0x008D`	HideObj	How objects are shown.
`0x0090`	Sort	Sort settings for a range.
`0x0092`	Palette	Custom colour palette.
`0x0097`	Sync	Synchronised scrolling position.
`0x0098`	LPr	Unused.
`0x0099`	DxGCol	Default width of columns without their own.
`0x009A`	FnGroupName	A user-defined function category.
`0x009B`	FilterMode	The sheet’s data is filtered.
`0x009C`	BuiltInFnGroupCount	Number of built-in function categories.
`0x009D`	AutoFilterInfo	Number of AutoFilter columns.
`0x009E`	AutoFilter	An AutoFilter condition.
`0x00A0`	Scl	Zoom level.
`0x00A1`	Setup	Page setup: paper, scale, orientation.
`0x00AE`	ScenMan	Scenario Manager state.
`0x00AF`	SCENARIO	A scenario.
`0x00B0`	SxView	A PivotTable view.
`0x00B1`	Sxvd	Pivot field properties.
`0x00B2`	SXVI	A pivot item.
`0x00B4`	SxIvd	Row or column field order.
`0x00B5`	SXLI	Pivot lines of the row or column area.
`0x00B6`	SXPI	Page-axis fields and filters.
`0x00B8`	DocRoute	Routing slip.
`0x00B9`	RecipName	A routing slip recipient.
`0x00BD`	MulRk	Several numeric cells in one row.
`0x00BE`	MulBlank	Several formatted empty cells in one row.
`0x00C1`	Mms	Reserved; ignored.
`0x00C5`	SXDI	A PivotTable data item.
`0x00C6`	SXDB	PivotCache properties.
`0x00C7`	SXFDB	A PivotCache field.
`0x00C8`	SXDBB	Cache field values of a record.
`0x00C9`	SXNum	Numeric cache item.
`0x00CA`	SxBool	Boolean cache item.
`0x00CB`	SxErr	Error cache item.
`0x00CC`	SXInt	Integer cache item.
`0x00CD`	SXString	String segment for a PivotCache.
`0x00CE`	SXDtr	Date and time cache item.
`0x00CF`	SxNil	Empty cache item.
`0x00D0`	SXTbl	Multiple consolidation ranges.
`0x00D1`	SXTBRGIITM	Start of page item names for consolidation.
`0x00D2`	SxTbpg	Consolidation source range properties.
`0x00D3`	ObProj	The file has a VBA project.
`0x00D5`	SXStreamID	A stream in the PivotCache storage.
`0x00D7`	DBCell	Offsets within a block of up to 32 rows.
`0x00D8`	SXRng	Numeric or date grouping of cache items.
`0x00D9`	SxIsxoper	Mapping between grouped cache items.
`0x00DA`	BookBool	Workbook options (save external values, etc.).
`0x00DC`	DbOrParamQry	A DbQuery or ParamQry record, by context.
`0x00DD`	ScenarioProtect	Scenario protection.
`0x00DE`	OleObjectSize	Visible range when embedded as an OLE object.
`0x00E0`	XF	A cell format or cell style format.
`0x00E1`	InterfaceHdr	Start of user-interface records; interface code page.
`0x00E2`	InterfaceEnd	End of user-interface records.
`0x00E3`	SXVS	PivotCache source type.
`0x00E5`	MergeCells	Merged cell ranges.
`0x00E9`	BkHim	Sheet background picture.
`0x00EB`	MsoDrawingGroup	Office Drawing data shared by the workbook.
`0x00EC`	MsoDrawing	Office Drawing data of a sheet.
`0x00ED`	MsoDrawingSelection	Selected drawing objects.
`0x00EF`	PhoneticInfo	Default phonetic guide settings.
`0x00F0`	SxRule	Areas of a PivotTable view.
`0x00F1`	SXEx	Extra PivotTable view properties.
`0x00F2`	SxFilt	PivotTable rule filter.
`0x00F4`	SxDXF	Differential formatting in a PivotTable.
`0x00F5`	SxItm	References to pivot, data or cache items.
`0x00F6`	SxName	Calculated field or item.
`0x00F7`	SxSelect	Selection in a PivotTable.
`0x00F8`	SXPair	Pivot item used by a calculated item.
`0x00F9`	SxFmla	Formula of a calculated field or item.
`0x00FB`	SxFormat	Start of PivotTable formatting records.
`0x00FC`	SST	The shared string table.
`0x00FD`	LabelSst	A text cell, as an index into the SST.
`0x00FF`	ExtSST	Index into the SST for quick lookup.
`0x0100`	SXVDEx	Extended pivot field properties.
`0x0103`	SXFormula	Cache field a calculated item applies to.
`0x0122`	SXDBEx	Extra PivotCache properties.
`0x0137`	RRDInsDel	Revision: rows or columns inserted or deleted.
`0x0138`	RRDHead	Revision: header of a set of revisions.
`0x013B`	RRDChgCell	Revision: a changed cell.
`0x013D`	RRTabId	Unique sheet identifiers for revisions.
`0x013E`	RRDRenSheet	Revision: a sheet renamed.
`0x013F`	RRSort	Revision: a sort.
`0x0140`	RRDMove	Revision: cells moved.
`0x014A`	RRFormat	Revision: formatting changed.
`0x014B`	RRAutoFmt	Revision: AutoFormat applied.
`0x014D`	RRInsertSh	Revision: a sheet inserted.
`0x014E`	RRDMoveBegin	Start of a move revision.
`0x014F`	RRDMoveEnd	End of a move revision.
`0x0150`	RRDInsDelBegin	Start of an insert or delete revision.
`0x0151`	RRDInsDelEnd	End of an insert or delete revision.
`0x0152`	RRDConflict	Resolution of a conflict between users’ revisions.
`0x0153`	RRDDefName	Revision: a defined name.
`0x0154`	RRDRstEtxp	Font of a formatting run in a revision.
`0x015F`	LRng	Label range for natural-language formulas.
`0x0160`	UsesELFs	Natural-language formulas are supported.
`0x0161`	DSF	Reserved; ignored.
`0x0191`	CUsr	Number of users with the shared workbook open.
`0x0192`	CbUsr	Size of each UsrInfo record.
`0x0193`	UsrInfo	A user of the shared workbook.
`0x0194`	UsrExcl	A user’s exclusive lock.
`0x0195`	FileLock	The shared workbook is locked by a user.
`0x0196`	RRDInfo	Shared-workbook information.
`0x0197`	BCUsrs	Start of the UsrInfo records.
`0x0198`	UsrChk	Version of the last user’s application.
`0x01A9`	UserBView	Workbook settings of a custom view.
`0x01AA`	UserSViewBegin	Start of a custom view’s sheet settings (also `UserSViewBegin_Chart` in chart sheets).
`0x01AB`	UserSViewEnd	End of a custom view’s sheet settings.
`0x01AC`	RRDUserView	Revision: a custom view.
`0x01AD`	Qsi	Query table properties.
`0x01AE`	SupBook	A supporting workbook: this one, an external file, an add-in or DDE/OLE.
`0x01AF`	Prot4Rev	Revision log removal is disallowed.
`0x01B0`	CondFmt	Conditional formatting ranges.
`0x01B1`	CF	A conditional formatting rule.
`0x01B2`	DVal	Data validation settings of a sheet.
`0x01B5`	DConBin	A built-in named range used as a data source.
`0x01B6`	TxO	Text of a text box or control (text in following Continue records).
`0x01B7`	RefreshAll	Refresh external data on opening.
`0x01B8`	HLink	A hyperlink on a range.
`0x01B9`	Lel	A lost natural-language formula label.
`0x01BA`	CodeName	VBA code name of the workbook or sheet.
`0x01BB`	SXFDBType	Data type of a cache field.
`0x01BC`	Prot4RevPass	Password for revision log protection.
`0x01BD`	ObNoMacros	A VBA project exists but has no macros.
`0x01BE`	Dv	A data validation rule.
`0x01C0`	Excel9File	Optional and unused.
`0x01C1`	RecalcId	Calculation engine that last recalculated.
`0x01C2`	EntExU2	Application-specific cache.
`0x0200`	Dimensions	The used range of the sheet.
`0x0201`	Blank	A formatted empty cell.
`0x0203`	Number	A cell with a floating-point number.
`0x0204`	Label	A cell with text held in the record.
`0x0205`	BoolErr	A cell with a Boolean or error value.
`0x0207`	String	Text result of the preceding formula.
`0x0208`	Row	A row: height, format, outline.
`0x020B`	Index	Row range and DBCell offsets of a sheet.
`0x0221`	Array	An array formula for a range.
`0x0225`	DefaultRowHeight	Height of empty rows.
`0x0236`	Table	A data table (what-if table).
`0x023E`	Window2	Sheet window options: gridlines, freeze, zoom, selection.
`0x027E`	RK	A cell with a compact (RK) number.
`0x0293`	Style	A cell style.
`0x0418`	BigName	Large user-defined name/value data.
`0x041E`	Format	A number format string and its id.
`0x043C`	ContinueBigName	Continuation of a BigName.
`0x04BC`	ShrFmla	A formula shared by a range of cells.
`0x0800`	HLinkTooltip	Tooltip of a hyperlink.
`0x0801`	WebPub	A published web page.
`0x0802`	QsiSXTag	Name and refresh data of a query table or PivotTable.
`0x0803`	DBQueryExt	External connection details.
`0x0804`	ExtString	Connection string of an external query.
`0x0805`	TxtQry	Text-file query.
`0x0806`	Qsir	Query table formatting.
`0x0807`	Qsif	A query table field.
`0x0808`	RRDTQSIF	Revision: query table field removed.
`0x0809`	BOF	Start of a substream.
`0x080A`	OleDbConn	OLE DB connection.
`0x080B`	WOpt	Save-as-web-page options.
`0x080C`	SXViewEx	Start of PivotTable OLAP extensions.
`0x080D`	SXTH	A pivot hierarchy.
`0x080E`	SXPIEx	OLAP page-axis extensions.
`0x080F`	SXVDTEx	OLAP pivot field extensions.
`0x0810`	SXViewEx9	PivotTable view extensions.
`0x0812`	ContinueFrt	Continuation of a future record.
`0x0813`	RealTimeData	Real-time data (RTD) topics.
`0x0850`	ChartFrtInfo	Versions that created and last saved a chart.
`0x0851`	FrtWrapper	Wraps an ordinary record as a future record.
`0x0852`	StartBlock	Start of a block of chart future records.
`0x0853`	EndBlock	End of such a block.
`0x0854`	StartObject	Start of a chart object’s future records.
`0x0855`	EndObject	End of a chart object’s future records.
`0x0856`	CatLab	Axis label attributes.
`0x0857`	YMult	Value axis display unit (thousands, millions…).
`0x0858`	SXViewLink	Source PivotTable of a PivotChart.
`0x0859`	PivotChartBits	PivotChart flags.
`0x085A`	FrtFontList	Fonts used in a chart.
`0x0862`	SheetExt	Sheet tab colour and other sheet properties.
`0x0863`	BookExt	Further workbook properties.
`0x0864`	SXAddl	Additional PivotTable data, in many classes.
`0x0865`	CrErr	Errors found during crash recovery.
`0x0866`	HFPicture	Picture in a header or footer.
`0x0867`	FeatHdr	Header of shared features (protection, smart tags…).
`0x0868`	Feat	Shared feature data.
`0x086A`	DataLabExt	Start of an extended data label.
`0x086B`	DataLabExtContents	Contents of an extended data label.
`0x086C`	CellWatch	A watched cell.
`0x0871`	FeatHdr11	Common information for the sheet’s tables.
`0x0872`	Feature11	A table (list).
`0x0874`	DropDownObjIds	Reusable drop-down object ids.
`0x0875`	ContinueFrt11	Continuation of a future record (Excel 2003 features).
`0x0876`	DConn	A data connection.
`0x0877`	List12	Table formatting added in Excel 2007.
`0x0878`	Feature12	A table (Excel 2007 data).
`0x0879`	CondFmt12	Excel 2007 conditional formatting ranges.
`0x087A`	CF12	An Excel 2007 conditional formatting rule.
`0x087B`	CFEx	Extension of a CondFmt.
`0x087C`	XFCRC	Count and checksum of the XF records.
`0x087D`	XFExt	Extended properties of an XF (theme colours…).
`0x087E`	AutoFilter12	Excel 2007 AutoFilter properties.
`0x087F`	ContinueFrt12	Continuation of a future record (Excel 2007 features).
`0x0884`	MDTInfo	A metadata type.
`0x0885`	MDXStr	Shared MDX metadata string.
`0x0886`	MDXTuple	MDX tuple metadata.
`0x0887`	MDXSet	MDX set metadata.
`0x0888`	MDXProp	MDX member property metadata.
`0x0889`	MDXKPI	MDX KPI metadata.
`0x088A`	MDB	Shared set of MDX metadata.
`0x088B`	PLV	Page Layout view settings.
`0x088C`	Compat12	Check compatibility with earlier versions.
`0x088D`	DXF	A differential format.
`0x088E`	TableStyles	Default table and PivotTable styles.
`0x088F`	TableStyle	A user-defined table style.
`0x0890`	TableStyleElement	One element of a table style.
`0x0892`	StyleExt	Extra cell style information.
`0x0893`	NamePublish	Publishing setting of a defined name.
`0x0894`	NameCmt	Comment on a defined name.
`0x0895`	SortData	Sort data for a range.
`0x0896`	Theme	The document theme.
`0x0897`	GUIDTypeLib	GUID of the VBA type library.
`0x0898`	FnGrp12	A user-defined function category name.
`0x0899`	NameFnGrp12	A function within such a category.
`0x089A`	MTRSettings	Multithreaded calculation settings.
`0x089B`	CompressPictures	Picture compression on save.
`0x089C`	HeaderFooter	Even-page and first-page header and footer.
`0x089D`	CrtLayout12	Layout of an attached chart label.
`0x089E`	CrtMlFrt	Extra chart element properties (XML).
`0x089F`	CrtMlFrtContinue	Continuation of CrtMlFrt.
`0x08A3`	ForceFullCalculation	Forced full calculation mode.
`0x08A4`	ShapePropsStream	Chart element shape formatting (XML).
`0x08A5`	TextPropsStream	Chart text properties (XML).
`0x08A6`	RichTextStream	Chart rich text properties (XML).
`0x08A7`	CrtLayout12A	Layout of the plot area.
`0x1001`	Units	Zero; ignored.
`0x1002`	Chart	Position and size of the chart area.
`0x1003`	Series	A series, trendline or error bars.
`0x1006`	DataFormat	Data point or series the next formatting applies to.
`0x1007`	LineFormat	Line appearance.
`0x1009`	MarkerFormat	Data marker colour, size and shape.
`0x100A`	AreaFormat	Fill pattern and colours.
`0x100B`	PieFormat	Distance of pie slices from the centre.
`0x100C`	AttachedLabel	Data label properties.
`0x100D`	SeriesText	Text of a series name, title or label.
`0x1014`	ChartFormat	A chart group.
`0x1015`	Legend	The legend.
`0x1016`	SeriesList	Series of the chart.
`0x1017`	Bar	Bar or column chart group.
`0x1018`	Line	Line chart group.
`0x1019`	Pie	Pie or doughnut chart group.
`0x101A`	Area	Area chart group.
`0x101B`	Scatter	Scatter or bubble chart group.
`0x101C`	CrtLine	Drop, high-low, series or leader lines.
`0x101D`	Axis	An axis.
`0x101E`	Tick	Axis labels and tick marks.
`0x101F`	ValueRange	Value axis scale.
`0x1020`	CatSerRange	Category, date or series axis scale.
`0x1021`	AxisLine	Which part of the axis a LineFormat applies to.
`0x1022`	CrtLink	Written but unused.
`0x1024`	DefaultText	Which text elements default formatting applies to.
`0x1025`	Text	An attached label.
`0x1026`	FontX	Font of a text element.
`0x1027`	ObjectLink	What a text element is attached to.
`0x1032`	Frame	Frame around a chart element.
`0x1033`	Begin	Start of a nested group of chart records.
`0x1034`	End	End of that group.
`0x1035`	PlotArea	The following Frame is the plot area’s.
`0x103A`	Chart3d	3-D rendering of the plot area.
`0x103C`	PicF	Layout of a picture fill.
`0x103D`	DropBar	Up or down bars.
`0x103E`	Radar	Radar chart group.
`0x103F`	Surf	Surface chart group.
`0x1040`	RadarArea	Filled radar chart group.
`0x1041`	AxisParent	An axis group.
`0x1043`	LegendException	A changed or deleted legend entry.
`0x1044`	ShtProps	Chart sheet properties.
`0x1045`	SerToCrt	Chart group of the current series.
`0x1046`	AxesUsed	Number of axis groups.
`0x1048`	SBaseRef	PivotTable referenced by a chart.
`0x104A`	SerParent	Series a trendline or error bar belongs to.
`0x104B`	SerAuxTrend	A trendline.
`0x104E`	IFmtRecord	Number format of axis text.
`0x104F`	Pos	Size and position of a legend, label or plot area.
`0x1050`	AlRuns	Rich text runs in chart text.
`0x1051`	BRAI	Reference to the sheet data for a series part.
`0x105B`	SerAuxErrBar	Error bar properties.
`0x105C`	ClrtClient	Custom chart colour palette.
`0x105D`	SerFmt	Properties of a series’ points, markers or lines.
`0x105F`	Chart3DBarShape	Shape of 3-D bars.
`0x1060`	Fbi	Font scaling information.
`0x1061`	BopPop	Bar-of-pie or pie-of-pie chart group.
`0x1062`	AxcExt	Date axis extensions.
`0x1063`	Dat	Data table on a chart.
`0x1064`	PlotGrowth	Font scale factors.
`0x1065`	SIIndex	Kind of chart data that follows.
`0x1066`	GelFrame	Fill pattern (Office Drawing properties).
`0x1067`	BopPopCustom	Data points in the secondary bar or pie.
`0x1068`	Fbi2	Font scaling information (alternative form).

.XLS File Format – Record types

All record types