.XLSB File Extension
Microsoft Excel Binary Spreadsheet
3.7 | 58 Votes
What is an XLSB file?
An XLSB file is a spreadsheet workbook created by Microsoft Excel, a program used to create and edit spreadsheets. It contains one or more spreadsheets with cells arranged by a grid of rows and columns, as well as charts, macros, and formatting. XLSB files are saved in a binary format.
XLSB files differ from standard Open XML format (.XLSX) spreadsheets since they store the spreadsheet using a binary format (BIFF12). You will most likely see and use the XLSX file more often because it is compressed to save space and is easier to share with other users. XLSB files are not compressed, making them larger in size than XLSX files. However, XLSB files may perform more efficiently within Excel because they are saved in the larger binary format.
To create an XLSB file with Excel, select File → Save As, then select "Excel Binary Workbook (*.xlsb)" from the file type dropdown menu. Depending on the operating system you are using, Excel saves XLSB files in the following locations by default :
Windows Vista, 7, & 10:
C:\Documents and Settings\Application Data\Microsoft\Excel\XLStart
How do I open an XLSB file?
However, Excel is the best option for opening XLSB files because it fully supports the formatting of Excel spreadsheets, which may include graphs and the spacing of data fields. To open an XLSB file with Excel, select File → Open → Browse, then choose the XLSB file you would like to open.