Go to File → Save As (or press F12), open the Save as type list, choose Excel Binary Workbook (*.xlsb) and click Save. The workbook looks and works exactly as before, but it is stored in binary rather than XML, with the .xlsb extension.
Use XLSB for large, formula-heavy workbooks that are slow to open and save. It holds the same sheets, formulas, pivot tables, charts and VBA as .xlsx or .xlsm, but usually gives a smaller file that opens and saves faster. The grid is the same size, so it does not let you store more than 1,048,576 rows.
Keep using XLSX for files you share. Google Sheets and many third-party tools and add-ins either cannot open XLSB or handle it poorly, and because the file is not readable XML, a corrupted XLSB is harder to repair.
To make XLSB the default for new files, go to File → Options → Save and set Save files in this format to Excel Binary Workbook.
Watch the macros. An XLSB can contain VBA, but unlike .xlsm its extension does not tell you so. Excel applies the same Trust Center macro settings to both, so treat any .xlsb from someone else as you would an .xlsm and click Enable Content only if you trust the source.
Let’s say you are working on a huge sales report with thousands of rows of data, lots of calculations, and several complex charts.
Every time you open or save the file, it takes forever.
Plus, you use macros to automate tasks, like updating the report with new weekly data. In this case, switching to an Excel Binary Workbook (.xlsb) can help. It will make your file smaller and faster to open and save.

In this tutorial, we will look at all the aspects of using a Binary Workbook in Excel.
Quick Notes
- Binary Workbooks are lighter in size.
- These files can handle macros.
- Binary format files open and save faster.
- It has less compatibility with other spreadsheet programs.
- If a file gets corrupted, it’s difficult to recover data.
What is Binary Format (XLSB)?
An Excel Binary Workbook (.xlsb) saves data in a binary format (BIFF12) instead of the XML that other formats (like XLSX and XLSM) use. The user interface of a binary file is the same as that of other files. You can use it in the same way you use other workbooks.
The best way to understand it in simple language is to think of it as packing a suitcase.
In the binary format, Excel packs all your data into a tight, efficient package, making the file smaller and faster to handle. And you can still add and delete worksheets, create charts and pivot tables, write formulas, and write code.
Excel has had this format since Excel 2007, so you can use it in every version since then, on Windows and on Mac. Excel for the web can open an XLSB file too, but macros don’t run in the browser.
Advantages of a Binary Workbook
Here are the advantages of using a Binary Workbook in Excel to store data.
- Smaller File Size:Binary workbooks are more compact, saving space on your computer and making them easier to share.
- Macro Support:Binary workbooks can run macros, so you can automate repetitive tasks and save time.
- Handles Big Data: These files handle large amounts of data better, reducing the chance of your workbook slowing down. The sheet size stays the same as XLSX, though: 1,048,576 rows by 16,384 columns.
- Better for Complex Workbooks:XLSB can handle complex workbooks with many formulas and data more smoothly.
- Mature Format: Excel has used this format since Excel 2007, so it’s well tested and works the same way in every version since then. It isn’t immune to corruption, though, so keep a backup of important files (see the disadvantages below).
- Faster Performance:They open and save faster, so you spend less time waiting for a large workbook to load.
Save, Create, and Open a Binary Workbook in Excel (XLSB)
To save a workbook in a binary format, first of all, open the workbook that you want to save as an XLSB.

- Click the “File” tab in the ribbon to open the Backstage view, select “Save As” from the menu (it shows as “Save a Copy” when the file is on OneDrive with AutoSave on), and then click “Browse” to open the Save As dialog box.
- In the Save As dialog box, choose the location on your computer to save the file. In the “Save as type” drop-down menu, select “Excel Binary Workbook (*.xlsb)”.
- Enter a name for your file in the “File name” field, and then click the “Save” button.
Or, you can also use the keyboard shortcut to open the save as dialog box (Alt → F → A), or press F12 to open it directly. From the “Save as type” drop-down, select “Excel Binary Workbook.” Then, save it the way you normally save a workbook.
On a Mac, go to File → Save As (Command + Shift + S), and pick “Excel Binary Workbook (.xlsb)” from the “File Format” drop-down.
Not just saving an existing workbook as a binary workbook, you can create a new binary file in Excel in the first place.
For this, you just need to follow the same steps that you have learned above. Open the dialog box and select the .XLSB format to save the file.
And if you want every new workbook to save as XLSB, make it the default format. Go to File → Options → Save, select “Excel Binary Workbook” in the “Save files in this format” drop-down, and click OK.
To open an XLSB file, double-click it, or go to File → Open in Excel. It opens like any other workbook.
Save a Workbook as XLSB with VBA
If you need to save files as XLSB again and again, you can do it with a macro. In the code below, FileFormat:=xlExcel12 (value 50) is the Excel Binary Workbook format, and the file name must end with .xlsb.
Sub SaveAsBinaryWorkbook()
' Save the active workbook as .xlsb in the same folder
Dim newName As String
newName = ActiveWorkbook.Path & Application.PathSeparator & _
Left(ActiveWorkbook.Name, InStrRev(ActiveWorkbook.Name, ".") - 1) & ".xlsb"
ActiveWorkbook.SaveAs Filename:=newName, FileFormat:=xlExcel12
End Sub
The workbook needs to be saved at least once before you run it, as a new workbook has no path or extension yet. Application.PathSeparator picks the right folder separator on Windows and on Mac. After that, the open workbook is the new XLSB file, and the old file stays as it was.
XLSX Vs. XLSB
As I said, the biggest difference between XLSX and XLSB is how they save the data in the workbook: XLSX stores it as XML, and XLSB stores it in binary format.
In the below screenshot, we have two workbooks with the same set of data (253,000 cell entries). The XLSX file has a size of 2,427 KB, and the binary file has a size of 1,784 KB.

Below is a table that shows you some of the major differences between XLSX & XLSB.
Feature | XLSX | XLSB |
|---|---|---|
File Extension | .xlsx | .xlsb |
File Format | Open XML Format | Binary Format |
File Size | Larger | Smaller |
Speed | Slower to open/save | Faster to open/save |
Macro Support | Supports macros with .xlsm extension | Supports macros |
Data Storage | Text-based XML | Binary |
Compatibility | Widely compatible with other programs | Less compatible with non-Excel programs |
Corruption Recovery | Easier to recover due to text format | Harder to recover due to binary format |
Security | Generally considered more secure | Potentially less secure due to binary nature |
Usage | Common for sharing and archiving | Common for large and complex workbooks |
Note: An XLSX file can’t store macros at all. If you save a workbook with code as XLSX, Excel removes the code. To keep macros in the XML format, you need a different file type, the Excel Macro-Enabled Workbook (.xlsm). That’s also why XLSX counts as the safer format to share: the risk with XLSB comes from the macros it can hold, the same as with XLSM, not from the binary format itself.
Then, Should I Use XLSB?
XLSX is suitable for basic use and provides all the standard features you need, making it perfect for workbooks that aren’t very large or complex.
Additionally, if security is a priority, XLSX files can’t hold macros and are easier to inspect, making them safer for sharing sensitive information.
For workbooks with extensive formulas, charts, and data, XLSB can manage complexity better without performance issues. When frequent edits and saves are required, XLSB works faster than other formats.
If minimizing file size for storage or sharing is important, XLSB compresses data more effectively, as we have learned above. It can help you hold a large data set, especially when you don’t need to work on the file.
Binary files work best in combination withPOWER QUERY. You can directly extract data from multiple binary (XLSB) files with the help of Power Query.
But stay with XLSX when you share the file with people who use Google Sheets or other spreadsheet apps, or when another tool or script needs to read it, as most of them read XLSX but not XLSB.
Take Care of Security…
Like the XLSM file format, which is the specific Excel file format for storing and running macros, XLSB can also store macros.
This raises a security concern if you get an XLSB file that contains a macro from other users.
Normally, with XLSM, you know from the extension that it can have macros, so you can disable macros in the Excel application before opening it.
That is not the case with XLSB: the extension doesn’t tell you whether the file has a macro or not. If it contains a macro and you have enabled all macros in the Trust Center, it can run a macro automatically when you open the file.
The good news is that Excel’s macro settings work the same way for XLSB and XLSM. With the default setting (Disable VBA macros with notification), the macros in an XLSB file stay off and Excel shows a security warning bar with an Enable Content button. And Excel for Windows blocks macros by default in files downloaded from the internet. You can check the setting under File → Options → Trust Center → Trust Center Settings → Macro Settings.
So keep the default setting, and click Enable Content only for XLSB files you trust.
Disadvantages
- You can’t easily open XLSB files in non-Excel programs like Google Sheets or LibreOffice. Google Sheets doesn’t import XLSB files, and LibreOffice Calc can open them but can’t save back to XLSB. Sharing files with others who don’t use Excel could be problematic.
- Data recovery is challenging with a Binary Workbook (.xlsb) because the data is stored in a binary format, which is not human-readable.
- Some third-party Excel add-ins or extensions might not fully support the XLSB.
- You can’t tell from the file extension whether an XLSB file has macros (see the security section above).
Frequently Asked Questions
Can I convert an XLSB file back to XLSX?
Yes. Open the file, go to File → Save As, and select “Excel Workbook (*.xlsx)” in the “Save as type” drop-down. If the file has macros, Excel warns you that they can’t be saved in a macro-free workbook. In that case, select “Excel Macro-Enabled Workbook (*.xlsm)” to keep them.
Does XLSB give me more rows than XLSX?
No. Both formats have the same sheet size of 1,048,576 rows by 16,384 columns. XLSB makes a big file smaller and faster to open and save, but it doesn’t raise any of Excel’s limits.
Can I open an XLSB file on a Mac or in Excel for the web?
Yes. Excel for Mac opens and saves XLSB files, and Excel for the web can open them too. In the browser, the macros in the file don’t run, so use the desktop app when you need them.
Written by
Puneet Gogia
Microsoft MVP — Excel · Founder, Excel Champs
Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.