You generally cannot open an .xlb file as a worksheet in Excel. An XLB file usually stores toolbar customizations for an older version of Excel, so a compatible legacy Excel installation may load it automatically when it starts. Microsoft 365 does not support opening or importing XLB files as workbooks; if you need the data, ask for the original workbook in a format such as .xlsx or .xls.
Before changing anything, identify which Excel version created the file and what you want to recover. Restoring toolbar settings is different from opening spreadsheet data, and replacing an existing settings file can remove customizations currently stored on your computer.
What You’ll Need
- The XLB file and, if possible, information from the person or system that supplied it about the Excel version that created it.
- A Windows computer with the same or a compatible older desktop version of Excel, if the goal is to restore legacy toolbar customizations. Microsoft 365, Excel for the web, and current Mac versions are not a way to open an XLB as a workbook.
- A backup of the existing Excel settings file before you replace or rename anything. You do not need a special XLB viewer to use the supported legacy restoration approach.
Step-by-Step
- Confirm the file extension and your goal. In File Explorer, locate the file and check that its full name ends in .xlb. If extensions are hidden, select View > Show > File name extensions in Windows 11; in Windows 10, use the View tab and select File name extensions. This helps distinguish an XLB from a workbook whose name or extension was changed. Decide whether you need old toolbar buttons or the contents of a spreadsheet. An XLB normally contains user-interface settings, not cells, formulas, or sheets.
- Find out which Excel version created it. Ask the sender, check the computer or application that produced it, or look at its original folder and filename for clues. Legacy releases often used version-numbered filenames, but names and storage locations can vary, so the name alone is not proof. A file created for one old Excel release may not work with another. If nobody can identify the version and the file matters, keep an untouched copy and avoid experimenting with the only copy.
- Do not try to open it from Excel’s Open dialog. In Microsoft 365 for Windows, File > Open is for supported workbook and document formats. Selecting an XLB there will not display spreadsheet contents, and changing the file filter to show all files will not make it a workbook. Double-clicking the file in File Explorer is also not a reliable way to load toolbar settings. If you need records, calculations, or a report, request the original .xlsx, .xls, or another data export from its source.
- For a matching older Windows Excel, close Excel and locate its settings folder. Exit every open Excel window first. In File Explorer’s address bar, enter
%appdata%\Microsoft\Exceland press Enter. This opens the roaming Excel settings folder for the current Windows account when that folder exists. Legacy Excel versions commonly stored their XLB settings there, although the exact path and expected filename can differ by Excel release and installation. If the folder is not present, do not create a random folder and assume Excel will use it; check the source computer or that version’s documentation for its actual settings location. - Back up the current settings before restoring the supplied file. In the settings folder, look for the existing XLB file. Copy it to a safe location, such as a separate backup folder, or rename it with a .bak ending while Excel is closed. Do not delete it. If the supplied XLB is from the same Excel version, place a copy in the location that version uses and give the copy the expected filename only when you have verified the required name. Avoid overwriting files by guessing: the wrong file or filename can leave Excel using its old settings or make it rebuild a blank customization file.
- Start the matching legacy Excel and check the toolbar. Launch the same compatible Excel release using its normal shortcut. XLB settings are generally read by Excel at startup, rather than opened like a workbook. Check whether the expected toolbar buttons or layout appear. If they do not, close Excel again before changing files, and restore the backup if necessary. Do not try the same replacement procedure in Microsoft 365: current Excel does not provide a supported XLB import workflow.
- For Microsoft 365, use an appropriate customization file instead. Current Excel for Windows can import supported Ribbon and Quick Access Toolbar customizations exported in the .exportedUI format. In Excel, open File > Options > Customize Ribbon, select Import/Export, and choose Import customization file. This is not an XLB converter: an .xlb file will not become a valid .exportedUI file simply by renaming its extension. If you only have an XLB, ask for a compatible export or recreate the commands manually in File > Options > Customize Ribbon or File > Options > Quick Access Toolbar.
Common Mistakes
- Treating XLB as an Excel workbook. A workbook holds sheets and data; an XLB usually holds toolbar configuration. It will not reveal cells when opened in Excel, and a file conversion site cannot reliably turn toolbar settings into worksheet data.
- Changing the extension to .xlsx. Renaming changes the label, not the file’s internal format. Excel may report that the file is damaged or has an incorrect extension. Restore the original .xlb name if you changed it, and request an actual workbook if data is needed.
- Replacing a settings file without a backup. An existing XLB may contain personal customizations. Keep a separate copy before trying a restoration, and close Excel first so it does not overwrite settings while the file is being changed.
- Assuming every XLB works in every Excel version. Legacy settings are version-dependent. Copying an old file into a modern Office folder, or using a file from a different release, does not make Excel 365 recognize it.
- Opening a file from an unknown source in a random utility. XLB is not a document format for viewing cell data. If the sender cannot explain what it contains or where it came from, scan it with your organization’s security tools and ask for a safer, clearly identified export.
Tips
Keep the original file unchanged and work with a copy. This makes it easy to retry with the correct legacy Excel version or restore the previous settings. If you are helping someone else, record the Excel version, Windows account, original filename, and folder before moving the file. These details can be more useful than repeatedly changing extensions or testing unrelated Excel installations.
If the goal is to recover familiar commands rather than preserve the exact old toolbar, list the buttons you need and add their current equivalents in Excel’s Ribbon or Quick Access Toolbar settings. In Microsoft 365 for Windows, use File > Options > Customize Ribbon for Ribbon commands and File > Options > Quick Access Toolbar for Quick Access Toolbar commands. A screenshot of the old interface or a description from the person who used it can help identify those commands.
Mac and web users should not follow Windows AppData instructions. Those paths refer to Windows user settings, and Excel for the web does not offer an XLB loading feature. For a Mac, ask for the original workbook if you need data, or request a current-format customization export where applicable. Do not move an XLB into a Mac Office settings folder expecting it to import.
Troubleshooting
- Excel says the file format or extension is invalid: This is expected if an XLB is being opened as a workbook, or if its extension was changed. Restore the .xlb extension and use the legacy settings procedure only with a compatible version. For spreadsheet contents, contact the source for an .xlsx or .xls copy.
- The toolbar does not change after copying the file: Verify that Excel was fully closed, the file is in the correct settings folder for that Windows account, and the filename matches what the installed legacy version expects. Confirm the file came from a compatible Excel release. If any of those details are uncertain, restore your backup rather than trying additional guessed filenames.
- The old toolbar appears empty or some commands are missing: The file may be incomplete, damaged, or dependent on an add-in, template, or command that is not installed on this computer. Return to the backed-up settings file, then ask the sender whether the original setup also required a particular add-in or workbook template. An XLB cannot recreate software that is absent.
- You cannot find the Excel settings folder: Check that you are signed in to the Windows account that runs Excel and enter the path directly in File Explorer. The folder may not exist until that Excel version has been run, or the installation may use a different location. Do not place the file in the Documents folder or the Office installation directory unless reliable instructions for that exact version say to do so.
- Excel creates a new XLB or your customizations disappear: Close Excel and restore the backup you made. A newly generated settings file can indicate that Excel did not recognize the supplied file, the name was wrong, or the file belonged to another version. Do not keep replacing files until you have confirmed the correct version and location.
- You need the contents, but the sender only provided an XLB: Ask the sender to open the original workbook and save or export the data as .xlsx, .xls, .csv, or PDF, depending on what you need. An XLB generally cannot supply the workbook because it stores interface preferences rather than worksheet content.
Frequently Asked Questions
Can I open an XLB file directly in Excel?
No. Excel does not treat an XLB as a workbook. A compatible older Excel version may load it automatically as toolbar settings when Excel starts.
Does an XLB file contain my spreadsheet data?
Usually not. XLB files are associated with legacy Excel toolbar customizations. Ask for the original workbook if you need its sheets, formulas, or records.
Can Excel for Microsoft 365 import an XLB file?
No supported XLB import is available in Microsoft 365. Excel for Windows can import certain customization files in .exportedUI format, but that format is not interchangeable with XLB.
Can I convert XLB to XLSX by renaming it?
No. An extension change does not convert the file’s contents. Renaming an XLB to .xlsx can produce an error and will not create a workbook.
Can I use an XLB file on a Mac or in Excel for the web?
There is no supported way to load an XLB as a workbook in either. Windows legacy settings-folder instructions do not apply to Mac or web Excel.
Is it safe to delete an XLB file?
Deleting one may remove legacy toolbar customizations, and Excel may create a replacement settings file. Back it up first, especially if you are unsure which Excel installation uses it.
Related
- Paragraph Break in Word: How to Start a New Paragraph
- How to Insert a Number Line in Word: Two Easy Methods
- How to Insert a Page Break in Word for Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Average Shortcut in Excel: Fast Ways to Calculate MeanIn Excel for Microsoft 365 on Windows, click the blank cell where you want the result, press Alt,…
- Excel Not Responding When Copying and Pasting? FixesIf Excel stops responding when you copy and paste, first wait a minute without clicking repeatedly; a large…
- Excel Scatter Plot Labels: Add Names to PointsTo label points in an Excel scatter plot with names, select the chart, choose Chart Design > Add…
- Excel Zoom: How to Enlarge a Worksheet on Windows PCTo zoom in on an Excel worksheet in Windows, drag the zoom slider at the bottom-right of the…
- How to Automatically Add Page Numbers in Microsoft WordTo automatically add page numbers in Word, open the document and choose Insert > Page Number, then select…
- Resize Cells in Excel: Keyboard Shortcuts That WorkTo resize cells in Excel quickly, resize their columns or rows: in Excel for Microsoft 365 on Windows,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.