BIFF record order has changed as the file format has evolved. The simplest way to determine BIFF record order is to create a workbook in Microsoft Excel and then use the BiffView utility to examine the record order.
BIFF Records: Alphabetical Order
|
Record |
Number | |
|
1904: 1904 Date System |
22h | |
|
ADDIN: Workbook Is an Add-in Macro |
87h | |
|
ADDMENU: Menu Addition |
C2h | |
|
ARRAY: Array-Entered Formula |
221h | |
|
AUTOFILTER: AutoFilter Data |
9Eh | |
|
AUTOFILTERINFO: Drop-Down Arrow Count |
9Dh | |
|
BACKUP: Save Backup Version of the File |
40h | |
|
BLANK: Cell Value, Blank Cell |
201h | |
|
BOF: Beginning of File |
809h | |
|
BOOKBOOL: Workbook Option Flag |
DAh | |
|
BOOLERR: Cell Value, Boolean or Error |
205h | |
|
BOTTOMMARGIN: Bottom Margin Measurement |
29h | |
|
BOUNDSHEET: Sheet Information |
85h | |
|
CALCCOUNT: Iteration Count |
0Ch | |
|
CALCMODE: Calculation Mode |
0Dh | |
|
CF: Conditional Formatting Conditions |
1B1h | |
|
CONDFMT: Conditional Formatting Range Information |
1B0h | |
|
CODENAME: VBE Object Name |
42h | |
|
CODEPAGE: Default Code Page |
42h | |
|
COLINFO: Column Formatting Information |
7Dh | |
|
CONTINUE: Continues Long Records |
3Ch | |
|
COORDLIST: Polygon Object Vertex Coordinates |
A9h | |
|
COUNTRY: Default Country and WIN.INI Country |
8Ch | |
|
CRN: Nonresident Operands |
5Ah | |
|
DBCELL: Stream Offsets |
D7h | |
|
DCON: Data Consolidation Information |
50h | |
|
DCONBIN: Data Consolidation Information |
1B5h | |
|
DCONNAME: Data Consolidation Named References |
52h | |
|
DCONREF: Data Consolidation References |
51h | |
|
DEFAULTROWHEIGHT: Default Row Height |
225h | |
|
DEFCOLWIDTH: Default Width for Columns |
55h | |
|
DELMENU: Menu Deletion |
C3h | |
|
DELTA: Iteration Increment |
10h | |
|
DIMENSIONS: Cell Table Size |
200h | |
|
DOCROUTE: Routing Slip Information |
B8h | |
|
DSF: Double Stream File |
161h | |
|
DV: Data Validation Criteria |
1BEh | |
|
DVAL: Data Validation Information |
1B2h | |
|
EDG: Edition Globals |
88h | |
|
EOF: End of File |
0Ah | |
|
EXTERNCOUNT: Number of External References |
16h | |
|
EXTERNNAME: Externally Referenced Name |
223h | |
|
EXTERNSHEET: External Reference |
17h | |
|
EXTSST: Extended Shared String Table |
FFh | |
|
FILEPASS: File Is Password-Protected |
2Fh | |
|
FILESHARING: File-Sharing Information |
5Bh | |
|
FILESHARING2: File-Sharing Information for Shared Lists |
1A5h | |
|
FILTERMODE: Sheet Contains Filtered List |
9Bh | |
|
FNGROUPCOUNT: Built-in Function Group Count |
9Ch | |
|
FNGROUPNAME: Function Group Name |
9Ah | |
|
FONT: Font Description |
231h | |
|
FOOTER: Print Footer on Each Page |
15h | |
|
FORMAT: Number Format |
41Eh | |
|
FORMULA: Cell Formula |
406h | |
|
GCW: Global Column-Width Flags |
ABh | |
|
GRIDSET: State Change of Gridlines Option |
82h | |
|
GUTS: Size of Row and Column Gutters |
80h | |
|
HCENTER: Center Between Horizontal Margins |
83h | |
|
HEADER: Print Header on Each Page |
14h | |
|
HIDEOBJ: Object Display Options |
8Dh | |
|
HLINK: Hyperlink |
1B8h | |
|
HORIZONTALPAGEBREAKS: Explicit Row Page Breaks |
1Bh | |
|
Record |
Number | |
|
IMDATA: Image Data |
7Fh | |
|
INDEX: Index Record |
20Bh | |
|
INTERFACEEND: End of User Interface Records |
E2h | |
|
INTERFACEHDR: Beginning of User Interface Records |
E1h | |
|
ITERATION: Iteration Mode |
11h | |
|
LABEL: Cell Value, String Constant |
204h | |
|
LABELSST: Cell Value, String Constant/SST |
FDh | |
|
LEFTMARGIN: Left Margin Measurement |
26h | |
|
LHNGRAPH: Named Graph Information |
95h | |
|
LHRECORD: .WK? File Conversion Information |
94h | |
|
LPR: Sheet Was Printed Using LINE.PRINT( |
98h | |
|
MMS: ADDMENU/DELMENU Record Group Count |
C1h | |
|
MSODRAWING: Microsoft Office Drawing |
ECh | |
|
MSODRAWINGGROUP: Microsoft Office Drawing Group |
EBh | |
|
MSODRAWINGSELECTION: Microsoft Office Drawing Selection |
EDh | |
|
MULBLANK: Multiple Blank Cells |
BEh | |
|
MULRK: Multiple RK Cells |
BDh | |
|
NAME: Defined Name |
218h | |
|
NOTE: Comment Associated with a Cell |
1Ch | |
|
NUMBER: Cell Value, Floating-Point Number |
203h | |
|
OBJ: Describes a Graphic Object |
5Dh | |
|
OBJPROTECT: Objects Are Protected |
63h | |
|
OBPROJ: Visual Basic Project |
D3h | |
|
OLESIZE: Size of OLE Object |
DEh | |
|
PALETTE: Color Palette Definition |
92h | |
|
PANE: Number of Panes and Their Position |
41h | |
|
PARAMQRY: Query Parameters |
DCh | |
|
PASSWORD: Protection Password |
13h | |
|
PLS: Environment-Specific Print Record |
4Dh | |
|
PRECISION: Precision |
0Eh | |
|
PRINTGRIDLINES: Print Gridlines Flag |
2Bh | |
|
PRINTHEADERS: Print Row/Column Labels |
2Ah | |
|
PROTECT: Protection Flag |
12h | |
|
PROT4REV: Shared Workbook Protection Flag |
1AFh | |
|
QSI: External Data Range |
1ADh | |
|
RECIPNAME: Recipient Name |
B9h | |
|
REFMODE: Reference Mode |
0Fh | |
|
REFRESHALL: Refresh Flag |
1B7h | |
|
RIGHTMARGIN: Right Margin Measurement |
27h | |
|
RK: Cell Value, RK Number |
7Eh | |
|
ROW: Describes a Row |
208h | |
|
RSTRING: Cell with Character Formatting |
D6h | |
|
SAVERECALC: Recalculate Before Save |
5Fh | |
|
SCENARIO: Scenario Data |
AFh | |
|
SCENMAN: Scenario Output Data |
AEh | |
|
SCENPROTECT: Scenario Protection |
DDh | |
|
SCL: Window Zoom Magnification |
A0h | |
|
SELECTION: Current Selection |
1Dh | |
|
SETUP: Page Setup |
A1h | |
|
SHRFMLA: Shared Formula |
BCh | |
|
SORT: Sorting Options |
90h | |
|
SOUND: Sound Note |
96h | |
|
SST: Shared String Table |
FCh | |
|
STANDARDWIDTH: Standard Column Width |
99h | |
|
STRING: String Value of a Formula |
207h | |
|
STYLE: Style Information |
293h | |
|
SUB: Subscriber |
91h | |
|
SUPBOOK: Supporting Workbook |
1AEh | |
|
SXDB: PivotTable Cache Data |
C6h | |
|
SXDBEX: PivotTable Cache Data |
122h | |
|
SXDI: Data Item |
C5h | |
|
SXEX: PivotTable View Extended Information |
F1h | |
|
SXEXT: External Source Information |
DCh | |
|
SXFDBTYPE: SQL Datatype Identifier |
1BBh | |
|
SXFILT: PivotTable Rule Filter |
F2h | |
|
SXFORMAT: PivotTable Format Record |
FBh | |
|
SXFORMULA: PivotTable Formula Record |
103h | |
|
SXFMLA: PivotTable Parsed Expression |
F9h | |
|
Record |
Number | |
|
SXIDSTM: Stream ID |
D5h | |
|
SXIVD: Row/Column Field IDs |
B4h | |
|
SXLI: Line Item Array |
B5h | |
|
SXNAME: PivotTable Name |
F6h | |
|
SXPAIR: PivotTable Name Pair |
F8h | |
|
SXPI: Page Item |
B6h | |
|
SXRULE: PivotTable Rule Data |
F0h | |
|
SXSTRING: String |
CDh | |
|
SXSELECT: PivotTable Selection Information |
F7h | |
|
SXTBL: Multiple Consolidation Source Info |
D0h | |
|
SXTBPG: Page Item Indexes |
D2h | |
|
SXTBRGIITM: Page Item Name Count |
D1h | |
|
SXVD: View Fields |
B1h | |
|
SXVDEX: Extended PivotTable View Fields |
100h | |
|
SXVI: View Item |
B2h | |
|
SXVIEW: View Definition |
B0h | |
|
SXVS: View Source |
E3h | |
|
TABID: Sheet Tab Index Array |
13Dh | |
|
TABIDCONF: Sheet Tab ID of Conflict History |
EAh | |
|
TABLE: Data Table |
236h | |
|
TEMPLATE: Workbook Is a Template |
60h | |
|
TOPMARGIN: Top Margin Measurement |
28h | |
|
TXO: Text Object |
1B6h | |
|
UDDESC: Description String for Chart Autoformat |
DFh | |
|
UNCALCED: Recalculation Status |
5Eh | |
|
USERBVIEW: Workbook Custom View Settings |
1A9h | |
|
USERSVIEWBEGIN: Custom View Settings |
1AAh | |
|
USERSVIEWEND: End of Custom View Records |
1ABh | |
|
USESELFS: Natural Language Formulas Flag |
160h | |
|
VCENTER: Center Between Vertical Margins |
84h | |
|
VERTICALPAGEBREAKS: Explicit Column Page Breaks |
1Ah | |
|
WINDOW1: Window Information |
3Dh | |
|
WINDOW2: Sheet Window Information |
23Eh | |
|
WINDOWPROTECT: Windows Are Protected |
19h | |
|
WRITEACCESS: Write Access User Name |
5Ch | |
|
WRITEPROT: Workbook Is Write-Protected |
86h | |
|
WSBOOL: Additional Workspace Information |
81h | |
|
XCT: CRN Record Count |
59h | |
|
XF: Extended Format |
E0h | |
|
XL5MODIFY: Flag for DSF |
162h | |
BIFF Records: Record Number Order
|
Number |
Record | |
|
0Ah |
EOF: End of File | |
|
0Ch |
CALCCOUNT: Iteration Count | |
|
0Dh |
CALCMODE: Calculation Mode | |
|
0Eh |
PRECISION: Precision | |
|
0Fh |
REFMODE: Reference Mode | |
|
10h |
DELTA: Iteration Increment | |
|
11h |
ITERATION: Iteration Mode | |
|
12h |
PROTECT: Protection Flag | |
|
13h |
PASSWORD: Protection Password | |
|
14h |
HEADER: Print Header on Each Page | |
|
15h |
FOOTER: Print Footer on Each Page | |
|
16h |
EXTERNCOUNT: Number of External References | |
|
17h |
EXTERNSHEET: External Reference | |
|
19h |
WINDOWPROTECT: Windows Are Protected | |
|
1Ah |
VERTICALPAGEBREAKS: Explicit Column Page Breaks | |
|
1Bh |
HORIZONTALPAGEBREAKS: Explicit Row Page Breaks | |
|
1Ch |
NOTE: Comment Associated with a Cell | |
|
1Dh |
SELECTION: Current Selection | |
|
22h |
1904: 1904 Date System | |
|
26h |
LEFTMARGIN: Left Margin Measurement | |
|
27h |
RIGHTMARGIN: Right Margin Measurement | |
|
28h |
TOPMARGIN: Top Margin Measurement | |
|
29h |
BOTTOMMARGIN: Bottom Margin Measurement | |
|
2Ah |
PRINTHEADERS: Print Row/Column Labels | |
|
2Bh |
PRINTGRIDLINES: Print Gridlines Flag | |
|
Number |
Record | |
|
2Fh |
FILEPASS: File Is Password-Protected | |
|
3Ch |
CONTINUE: Continues Long Records | |
|
3Dh |
WINDOW1: Window Information | |
|
40h |
BACKUP: Save Backup Version of the File | |
|
41h |
PANE: Number of Panes and Their Position | |
|
42h |
CODENAME: VBE Object Name | |
|
42h |
CODEPAGE: Default Code Page | |
|
4Dh |
PLS: Environment-Specific Print Record | |
|
50h |
DCON: Data Consolidation Information | |
|
51h |
DCONREF: Data Consolidation References | |
|
52h |
DCONNAME: Data Consolidation Named References | |
|
55h |
DEFCOLWIDTH: Default Width for Columns | |
|
59h |
XCT: CRN Record Count | |
|
5Ah |
CRN: Nonresident Operands | |
|
5Bh |
FILESHARING: File-Sharing Information | |
|
5Ch |
WRITEACCESS: Write Access User Name | |
|
5Dh |
OBJ: Describes a Graphic Object | |
|
5Eh |
UNCALCED: Recalculation Status | |
|
5Fh |
SAVERECALC: Recalculate Before Save | |
|
60h |
TEMPLATE: Workbook Is a Template | |
|
63h |
OBJPROTECT: Objects Are Protected | |
|
7Dh |
COLINFO: Column Formatting Information | |
|
7Eh |
RK: Cell Value, RK Number | |
|
7Fh |
IMDATA: Image Data | |
|
80h |
GUTS: Size of Row and Column Gutters | |
|
81h |
WSBOOL: Additional Workspace Information | |
|
82h |
GRIDSET: State Change of Gridlines Option | |
|
83h |
HCENTER: Center Between Horizontal Margins | |
|
84h |
VCENTER: Center Between Vertical Margins | |
|
85h |
BOUNDSHEET: Sheet Information | |
|
86h |
WRITEPROT: Workbook Is Write-Protected | |
|
87h |
ADDIN: Workbook Is an Add-in Macro | |
|
88h |
EDG: Edition Globals | |
|
89h |
PUB: Publisher | |
|
8Ch |
COUNTRY: Default Country and WIN.INI Country | |
|
8Dh |
HIDEOBJ: Object Display Options | |
|
90h |
SORT: Sorting Options | |
|
91h |
SUB: Subscriber | |
|
92h |
PALETTE: Color Palette Definition | |
|
94h |
LHRECORD: .WK? File Conversion Information | |
|
95h |
LHNGRAPH: Named Graph Information | |
|
96h |
SOUND: Sound Note | |
|
98h |
LPR: Sheet Was Printed Using LINE.PRINT( | |
|
99h |
STANDARDWIDTH: Standard Column Width | |
|
9Ah |
FNGROUPNAME: Function Group Name | |
|
9Bh |
FILTERMODE: Sheet Contains Filtered List | |
|
9Ch |
FNGROUPCOUNT: Built-in Function Group Count | |
|
9Dh |
AUTOFILTERINFO: Drop-Down Arrow Count | |
|
9Eh |
AUTOFILTER: AutoFilter Data | |
|
A0h |
SCL: Window Zoom Magnification | |
|
A1h |
SETUP: Page Setup | |
|
A9h |
COORDLIST: Polygon Object Vertex Coordinates | |
|
ABh |
GCW: Global Column-Width Flags | |
|
AEh |
SCENMAN: Scenario Output Data | |
|
AFh |
SCENARIO: Scenario Data | |
|
B0h |
SXVIEW: View Definition | |
|
B1h |
SXVD: View Fields | |
|
B2h |
SXVI: View Item | |
|
B4h |
SXIVD: Row/Column Field IDs | |
|
B5h |
SXLI: Line Item Array | |
|
B6h |
SXPI: Page Item | |
|
B8h |
DOCROUTE: Routing Slip Information | |
|
B9h |
RECIPNAME: Recipient Name | |
|
BCh |
SHRFMLA: Shared Formula | |
|
BDh |
MULRK: Multiple RK Cells | |
|
BEh |
MULBLANK: Multiple Blank Cells | |
|
C1h |
MMS: ADDMENU/DELMENU Record Group Count | |
|
C2h |
ADDMENU: Menu Addition | |
|
Number |
Record | |
|
C3h |
DELMENU: Menu Deletion | |
|
C5h |
SXDI: Data Item | |
|
C6h |
SXDB: PivotTable Cache Data | |
|
CDh |
SXSTRING: String | |
|
D0h |
SXTBL: Multiple Consolidation Source Info | |
|
D1h |
SXTBRGIITM: Page Item Name Count | |
|
D2h |
SXTBPG: Page Item Indexes | |
|
D3h |
OBPROJ: Visual Basic Project | |
|
D5h |
SXIDSTM: Stream ID | |
|
D6h |
RSTRING: Cell with Character Formatting | |
|
D7h |
DBCELL: Stream Offsets | |
|
DAh |
BOOKBOOL: Workbook Option Flag | |
|
DCh |
PARAMQRY: Query Parameters | |
|
DCh |
SXEXT: External Source Information | |
|
DDh |
SCENPROTECT: Scenario Protection | |
|
DEh |
OLESIZE: Size of OLE Object | |
|
DFh |
UDDESC: Description String for Chart Autoformat | |
|
E0h |
XF: Extended Format | |
|
E1h |
INTERFACEHDR: Beginning of User Interface Records | |
|
E2h |
INTERFACEEND: End of User Interface Records | |
|
E3h |
SXVS: View Source | |
|
EAh |
TABIDCONF: Sheet Tab ID of Conflict History | |
|
EBh |
MSODRAWINGGROUP: Microsoft Office Drawing Group | |
|
ECh |
MSODRAWING: Microsoft Office Drawing | |
|
EDh |
MSODRAWINGSELECTION: Microsoft Office Drawing Selection | |
|
F0h |
SXRULE: PivotTable Rule Data | |
|
F1h |
SXEX: PivotTable View Extended Information | |
|
F2h |
SXFILT: PivotTable Rule Filter | |
|
F6h |
SXNAME: PivotTable Name | |
|
F7h |
SXSELECT: PivotTable Selection Information | |
|
F8h |
SXPAIR: PivotTable Name Pair | |
|
F9h |
SXFMLA: PivotTable Parsed Expression | |
|
FBh |
SXFORMAT: PivotTable Format Record | |
|
FCh |
SST: Shared String Table | |
|
FDh |
LABELSST: Cell Value, String Constant/SST | |
|
FFh |
EXTSST: Extended Shared String Table | |
|
100h |
SXVDEX: Extended PivotTable View Fields | |
|
103h |
SXFORMULA: PivotTable Formula Record | |
|
122h |
SXDBEX: PivotTable Cache Data | |
|
13Dh |
TABID: Sheet Tab Index Array | |
|
160h |
USESELFS: Natural Language Formulas Flag | |
|
161h |
DSF: Double Stream File | |
|
162h |
XL5MODIFY: Flag for DSF | |
|
1A5h |
FILESHARING2: File-Sharing Information for Shared Lists | |
|
1A9h |
USERBVIEW: Workbook Custom View Settings | |
|
1AAh |
USERSVIEWBEGIN: Custom View Settings | |
|
1ABh |
USERSVIEWEND: End of Custom View Records | |
|
1ADh |
QSI: External Data Range | |
|
1AEh |
SUPBOOK: Supporting Workbook | |
|
1AFh |
PROT4REV: Shared Workbook Protection Flag | |
|
1B0h |
CONDFMT: Conditional Formatting Range Information | |
|
1B1h |
CF: Conditional Formatting Conditions | |
|
1B2h |
DVAL: Data Validation Information | |
|
1B5h |
DCONBIN: Data Consolidation Information | |
|
1B6h |
TXO: Text Object | |
|
1B7h |
REFRESHALL: Refresh Flag | |
|
1B8h |
HLINK: Hyperlink | |
|
1BBh |
SXFDBTYPE: SQL Datatype Identifier | |
|
1BCh |
PROT4REVPASS: Shared Workbook Protection Password | |
|
1BEh |
DV: Data Validation Criteria | |
|
200h |
DIMENSIONS: Cell Table Size | |
|
201h |
BLANK: Cell Value, Blank Cell | |
|
203h |
NUMBER: Cell Value, Floating-Point Number | |
|
204h |
LABEL: Cell Value, String Constant | |
|
205h |
BOOLERR: Cell Value, Boolean or Error | |
|
207h |
STRING: String Value of a Formula | |
|
208h |
ROW: Describes a Row | |
|
20Bh |
INDEX: Index Record | |
|
Number |
Record | |
|
218h |
NAME: Defined Name | |
|
221h |
ARRAY: Array-Entered Formula | |
|
223h |
EXTERNNAME: Externally Referenced Name | |
|
225h |
DEFAULTROWHEIGHT: Default Row Height | |
|
231h |
FONT: Font Description | |
|
236h |
TABLE: Data Table | |
|
23Eh |
WINDOW2: Sheet Window Information | |
|
293h |
STYLE: Style Information | |
|
406h |
FORMULA: Cell Formula | |
|
41Eh |
FORMAT: Number Format | |
|
809h |
BOF: Beginning of File | |