This article describes the two primary file formats that XLB files use. Learn where Excel and OpenOffice store these files and how to use both.
Reduce Excel file size up to 90% with Binary Workbook format (Microsoft Excel .XLSB extension)
A file with the XLB file extension is most likely an Excel toolbar file. Some versions of Excel use it to store information about the current settings of toolbars, such as their options and locations, and is useful if you want to copy the configuration to another computer.
If it is not associated with Excel, the XLB file may instead be a module information file used by the OpenOffice Basic software to store macro or component library details. It uses XML formatting and is most likely called script.xlb or dialog.xlb. The former contains the names of the modules in the library, while the latter is intended for storing the names of dialog boxes.
An XLB file can be opened with Microsoft Excel, but it is important to realize that it only stores customization information, not actual spreadsheet data. This means that you cannot simply double-click on the file and expect it to open with any kind of readable information.
