Save Your Spreadsheet in Binary (.Xslb) Format

Microsoft Excel typically stores files in an XML-based format, facilitating data exchange with various applications and systems. Yet, for those seeking a swift reduction in file size, converting the Excel spreadsheet into a binary format is an option.


To save an Excel spreadsheet in binary format, follow these instructions:


  1. Open your Excel spreadsheet.
  2. Go to File and then Save As.
  3. Choose where you want to save the file.
  4. Click on the Save as type drop-down menu and select Excel Binary Workbook (*.xlsb).
  5. Finally, click the Save button.


This action will convert your Excel file into a binary format, demanding less storage space. If you wish to set Microsoft Excel to save files in this binary format by default consistently, follow these steps:


  1. Open Microsoft Excel and go to File > Options.
  2. Choose the Save tab from the left sidebar.
  3. Use the dropdown menu next to "Save files in this format" and select the "Excel Binary Workbook (*.xslb)" option.
  4. Click OK to save the changes.


After following the steps mentioned by Toplist, Excel will save all files in binary format by default, unless you specify otherwise.

Screenshot via Excel
Screenshot via Excel
Screenshot via Excel
Screenshot via Excel

Toplist Joint Stock Company
Address: 3rd floor, Viet Tower Building, No. 01 Thai Ha Street, Trung Liet Ward, Dong Da District, Hanoi City, Vietnam
Phone: +84369132468 - Tax code: 0108747679
Social network license number 370/GP-BTTTT issued by the Ministry of Information and Communications on September 9, 2019
Privacy Policy