Convert an Excel Binary Worksheet (.XLSB) to Excel

How-to basics · Updated November 22, 2026

To convert an Excel binary workbook (.xlsb) to a standard Excel workbook, open it in Excel for Microsoft 365 on Windows, choose File > Save As > Browse, select Excel Workbook (*.xlsx), and save. This creates an .xlsx copy; keep the original .xlsb until you have checked the converted file.

What an Excel binary worksheet file really is

An .xlsb file is technically an Excel binary workbook, not a standalone worksheet. A workbook can contain several sheets, formulas, charts, formatting, and other content, and the .xlsb extension identifies the format used to store that workbook. People often say worksheet when they mean the whole Excel file.

Excel Binary Workbook is one of Excel’s native file formats. It stores workbook content in a binary structure rather than the XML-based package used by .xlsx files. Both formats are designed for Excel workbooks, and converting between them does not normally mean rebuilding the sheets or copying cells one by one. Excel reads the existing workbook and saves it in the selected format.

The usual destination is .xlsx, the standard macro-free Excel workbook format. It is widely supported by current spreadsheet software and is often the best choice for sharing ordinary workbooks. Conversion changes the file format, not the workbook’s purpose: formulas generally remain formulas, and sheets, tables, and charts are not intentionally turned into images or static text.

Check the workbook before converting

Before saving in a different format, identify anything the destination format cannot keep. The most important distinction is whether the workbook contains VBA macros. An .xlsb workbook can contain macros, but .xlsx cannot store a VBA project. If you need the macros, use .xlsm instead of .xlsx, or retain the original .xlsb.

It is also sensible to check for external links, data connections, add-in features, and content that may depend on a particular Excel version. These are not automatically lost just because a workbook is binary, but saving in another format or opening the file in another program can affect some features. Excel may display a compatibility warning if it identifies content that the selected format cannot preserve.

  • Make a backup of the original .xlsb before conversion, especially if it is used for business reporting or operational work.
  • Check whether the workbook contains macros, buttons, or other controls that trigger VBA code.
  • Note any external data sources or linked workbooks so you can test their connections afterward.
  • Confirm that you have permission to save the workbook in the destination folder, and that the file is not open for editing by someone else.

Convert XLSB to XLSX in Excel for Windows

In Excel for Microsoft 365 on Windows, use Save As to make the format change. The steps below create an .xlsx version while leaving the source .xlsb file available as a separate original.

  1. Open the .xlsb workbook in Excel. If a security banner appears, only enable content if you trust the file and its source.
  2. Choose File > Save As > Browse. In some Excel layouts, Save As first shows locations; choose Browse to open the Windows Save As dialog.
  3. Choose the destination folder and enter a file name. To keep the original and converted versions easy to distinguish, you could name the new file Quarterly-Report.xlsx.
  4. Open the Save as type list and select Excel Workbook (*.xlsx). Do not just type .xlsx after the old name while leaving the file type set to .xlsb; choose the actual format from the list.
  5. Select Save. If Excel warns that features cannot be saved in a macro-free workbook, read the warning. Choose to continue only if you accept removing those features; otherwise cancel and save as .xlsm or keep .xlsb.
  6. Close or switch to the new file and check that its name ends in .xlsx. Reopen it from the destination folder to verify that it is readable and that important content is present.

Save As changes the active workbook to the newly saved file, so check the title bar or use File > Info to make sure you are working with the intended copy. The original file remains in its original location unless you deliberately overwrite or delete it. Avoid using the same name and folder if doing so could replace a file you still need.

What may change in an XLSX conversion

For a typical workbook with worksheets, formulas, tables, charts, and formatting, saving as .xlsx is usually straightforward. The conversion does not normally replace formulas with their displayed answers. However, the saved file is not a perfect archival substitute for every .xlsb workbook, so review important behavior rather than judging only by appearance.

Macros are the clearest exception: an .xlsx file cannot contain VBA macros. A macro button might remain visible as an object but no longer run its code if the code was removed. Other controls or specialized content can also trigger a warning or behave differently depending on how they were created. Excel’s warning is a cue to investigate, not a guarantee that every detail of the workbook has been checked.

File size and speed can change too. Binary workbooks are sometimes smaller or quicker to open and save when they contain large amounts of data, but that is not guaranteed; the result depends on the workbook and its contents. An .xlsx file may be larger or smaller after conversion. Do not assume that a change in file size means data was lost, and do not assume that the binary format will always be faster.

Formulas that use newer Excel functions may also be a compatibility concern if the .xlsx file will be opened in an older Excel release or another spreadsheet program. The file extension does not make a new function available in old software. If recipients use different versions, test the file in the oldest supported environment or provide a compatible alternative.

When to choose XLSM or keep XLSB

Choose .xlsx when the workbook does not need VBA and you want a broadly familiar Excel format. Choose .xlsm when you need to preserve VBA macros and want a macro-enabled XML workbook. Choose .xlsb when you need to keep the workbook in binary format, for example because your workflow relies on that format or the workbook is especially large and performs better for your users. The best choice depends on compatibility and required features, not simply on which extension sounds newer.

Saving as .xlsm does not make a workbook safe by itself. It preserves the possibility of running VBA code, so recipients should treat macro-enabled files with care and enable macros only when they trust the source. Conversely, converting a workbook to .xlsx removes its VBA project but is not a complete security check: the file may still contain external links, embedded objects, or other content that warrants review.

If the workbook contains macros and you are unsure whether they matter, save a separate .xlsm copy first, then test the .xlsx copy. Check the buttons, automated reports, and any process that relies on a macro before distributing the macro-free version. Keep the original until the people who use the workbook confirm that the converted file meets their needs.

Verify the converted workbook and fix common problems

After conversion, check more than whether the file opens. Compare key sheets and a few important values with the original. For a financial or inventory workbook, check representative totals, dates, formulas, and filters; for a dashboard, inspect charts and slicers. These are practical spot checks, not a substitute for validating every critical calculation.

  • The file still ends in .xlsb: Reopen Save As and select Excel Workbook (*.xlsx) in the file type list. Changing only the filename suffix does not convert the file format.
  • Excel warns about macros: Cancel if the code must be preserved, then save as Excel Macro-Enabled Workbook (*.xlsm) or keep the .xlsb version.
  • A link or query does not refresh: Check the workbook’s connection settings, source file location, network access, and permissions. A different file format cannot fix an unavailable data source.
  • The converted file looks different: Check print settings, chart layout, conditional formatting, and objects as well as the cells. Compare the original and converted copies in desktop Excel.
  • The file will not save to the selected folder: Try a location where you have write permission, and check whether the workbook is read-only or being edited elsewhere.

If Excel displays a compatibility or feature warning, use the information in that dialog to decide whether to continue. You can cancel, preserve the source, and choose another destination format. Do not dismiss a warning automatically when the workbook is relied on for important calculations or automated tasks.

Other ways to convert and privacy considerations

Excel desktop is generally the most dependable option because it natively reads and writes Excel workbook formats. Excel for Mac has a similar Save As workflow, but labels and dialog controls can differ: use File > Save As and select Excel Workbook (.xlsx) from the file format or format list if that option is available in your installed version. If the workbook contains macros, select a macro-enabled format when offered and verify the result in desktop Excel.

Excel for the web may not support every file format or feature available in desktop Excel, and macro code cannot run there. If the browser does not open the .xlsb file or does not offer the required save format, use the desktop application rather than renaming the file. Support can vary by product version and feature, so check the options shown in your copy of Excel.

Online file-conversion websites are another possible route, but uploading a workbook sends its contents to a third party. A workbook may include customer names, payroll information, formulas, hidden sheets, or confidential business data even if its visible sheet seems harmless. For sensitive files, use an approved local application or an organization-authorized service, and follow your workplace’s data-handling rules. A converter should not be treated as a way to remove confidential information unless you separately inspect and clean the workbook.

Frequently Asked Questions

Can I convert XLSB to XLSX without Excel?
Some spreadsheet applications and online conversion services may accept .xlsb files, but format and feature support varies. Complex workbooks, macros, and connections may not transfer as expected. For the most predictable result, use desktop Excel and verify the saved workbook.

Will converting XLSB to XLSX delete my macros?
Yes, an .xlsx file cannot store a VBA project. If you need the macros, save as .xlsm or keep the .xlsb file. Do not continue past a macro-removal warning unless losing the VBA code is acceptable.

Is XLSX better than XLSB?
Neither is best for every workbook. XLSX is the widely used standard choice for macro-free workbooks and sharing; XLSB is a binary format that can be useful for certain large workbooks. Choose based on features, compatibility, and how the file will be used.

Can I just rename .xlsb to .xlsx?
No. Renaming changes the text in the filename, not the internal file format. Open the workbook and use Save As, then select Excel Workbook (*.xlsx) as the file type.

Does converting the file change its worksheets or formulas?
Ordinary sheets and formulas are generally retained when Excel saves a workbook as .xlsx, but specific features may be affected and macros are not supported in that format. Check the warning messages and test important calculations, links, and controls after saving.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.