Excel Binary Workbook Format
There are many different Excel workbook filetypes—XLS, XLSB, XLSM, XLSX—, but one in particular stands out from the rest. That filetype is the Excel Binary Workbook file. This type of workbook file differs from other Excel Workbook files (like xlsx and xlsm filetypes—which are the standard Excel Workbook and Excel Macro-Enabled Workbook files respectively) in the fact that Excel Binary Workbook files (which have the xlsb file extension) store data in a binary format whereas other Excel Workbook files store data in XML. The benefits of storing data in a binary format means that Excel Binary Workbook files are read from and written to significantly faster when compared to other Excel Workbook files. These benefits also manifest themselves in calculation speed and workbook size, making them significantly faster and significantly smaller respectively. Excel Binary Workbooks have all these benefits while still allowing for the implementation of VBA code macros. Binary Workbooks can also load formulas greater than the standard 8192 character limit that is present in other workbook files, such as XLSX and XLSM. This means that the use of Excel Binary Workbook files is very beneficial in massively sized spreadsheets with long, complex formulas and long calculation times which may or may not need to utilize VBA code macros. However, binary .xlsb format files are not compatible with versions of Excel prior to Excel 2003 and are only compatible with Excel 2003 if the Excel 2007 compatibility pack has been installed along with Service Pack 3. Excel Binary Workbook files can also be incompatible with any software or service that requires XML data instead of binary data, such as certain web servers or certain linked or layered systems.
Excel Binary Workbook Pros and Cons VS XLSX
– Smaller file size
– Faster to read from and write to (XLSB can save to/load from file faster)
– Can load formulas greater than the standard 8192 character limit
– Can have VBA code macros
– Can only be loaded by Excel 2007 and later versions
– Modification of the Excel Ribbon menu is not allowed while working on an XLSB
– Maybe incompatible with software or services that require XML data instead of binary data
DoneEx XCell Compiler can compile Excel Binary Workbook files! In fact, DoneEx XCell Compiler can compile all Excel Workbook files (xls, xlsx, xlsm, xlsb)! This means that you can just use the Excel Workbook type that best suits your needs—from your workbook to your environment.
After compiling with DoneEx XCell Compiler, you will get the binary workbook in an executable (exe) file format with protected formulas and VBA code, which is more secure than a standard Excel Workbook file.
How to Create an Excel Binary Workbook File
The process of creating an Excel Binary Workbook file is much like creating any other Excel Workbook file. Just open Excel and work on your workbook, then once you are ready and willing to save your work, just follow these simple steps:
How to Convert an Excel Binary Workbook to XLSX, XLSM, or XLS
If you are working with a software, service, or any type of environment that does not support binary spreadsheet files and requires workbooks are stored as XML data you may need to convert your Excel Binary Workbook file into another Excel Workbook file. The process of converting your Excel Binary Workbook file into an Excel Workbook file is similar to creating an Excel Binary Workbook file. Once you have the Excel Binary Workbook you wish to convert into another Excel Workbook file open, just follow these simple steps:
3. Once you are at the “Save As” browsing menu, click on the “Save as type” drop down menu and select the Excel Workbook file that is the most appropriate for you. If you wish to convert your Excel Binary Workbook into a standard Excel Workbook that does not support VBA code macros then you need to save your workbook with the “XLSX” filetype, so you need to select the “Excel Workbook” from the “Save as type” drop down menu.
If you wish to convert your binary .xlsb format spreadsheet into a standard Excel Workbook that can support VBA code macros then you need to save your workbook with the “XLSM” filetype, so you need to select the “Excel Macro-Enabled Workbook” from the “Save as type” drop down menu.
If you wish to convert your .XLSB format Workbook into a standard Excel Workbook that can be read by Excel 2003 and prior versions, then you need to save your workbook with the “XLS” filetype, so you need to select the “Excel 97-2003 Workbook” from the “Save as type” drop down menu.
4. Once you have the appropriate filetype that you wish to convert your Excel Binary Workbook into, just click the “Save” button and you are done! Your Excel Binary Workbook has now been converted to the filetype that you have chosen in step 3!