Convert XLA to XLSX

Older Excel add-ins may contain worksheets or data that must be edited, shared, or archived as a normal workbook. Converting the extract to .xlsx removes the legacy add-in container, but it does not preserve the add-in's executable features.

What the XLA format is

.xla is the legacy Excel 97–2003 Add-In format. Excel uses it for VBA macros, custom commands, user-defined functions, menus, toolbars, and sometimes hidden worksheets. An XLA is a workbook configured as an add-in, so it may open without a visible worksheet window. Newer Excel add-ins normally use .xlam.

XLA files occur in older Excel installations and in accounting, engineering, and other systems that distribute custom Excel functionality. The file may contain no useful tabular data; its main purpose may be to provide code and commands.

What the XLSX format is

.xlsx is the XML-based workbook format used by current desktop Excel, Excel for the web, and many spreadsheet applications. It stores worksheets, formulas, tables, charts, formatting, named ranges, and data validation without an embedded VBA project.

Use XLSX when the output must behave as an ordinary editable workbook or must be shared with software that does not support legacy add-ins. XLSX cannot retain VBA code, add-in registration, custom commands, or VBA-defined worksheet functions.

How to convert XLA to XLSX

Microsoft Excel: export visible worksheet data

1. Make a backup of the original .xla file.
2. Open desktop Excel and select File → Open → Browse. Select the XLA file, using an all-files filter if necessary. Enable macros only when the file is trusted and its code is required; an untrusted add-in can contain executable VBA.
3. If Excel displays the add-in's worksheets, select File → Save As and choose Excel Workbook (*.xlsx). Save under a new name.
4. Accept Excel's format warning. Excel discards VBA and other features that XLSX cannot store.
5. If the add-in window is hidden, create a blank workbook, expose any permitted sheet in the XLA through Home → Format → Hide & Unhide → Unhide Sheet, then copy the required ranges or entire worksheets into the blank workbook and save it as .xlsx.

Some add-in sheets are hidden with VBA's VeryHidden setting or protected by the author, in which case the normal Unhide command will not work. The owner or administrator must expose or unlock those sheets; do not bypass protection without authorization.

Excel: make an add-in workbook visible

If Excel opens the XLA as a hidden add-in workbook rather than a normal workbook, use a separate trusted workbook containing this VBA procedure. Replace both paths, run it, and inspect the exported file:

Sub ExportXla()
    Dim wb As Workbook
    Set wb = Workbooks.Open("C:\path\tool.xla")
    wb.IsAddin = False
    wb.SaveAs "C:\path\tool.xlsx", xlOpenXMLWorkbook
    wb.Close SaveChanges:=False
End Sub

This procedure changes the opened workbook's add-in status and saves a macro-free XLSX. It cannot recover sheets that are protected, encrypted, or absent, and it should not be used to extract code or content without permission.

LibreOffice Calc

LibreOffice Calc may open some older Excel add-ins, but XLA VBA, add-in registration, hidden-sheet behavior, and formulas are not reliably compatible. Use File → Save As and select Excel 2007–365 (*.xlsx) only after checking every required sheet and formula. Microsoft Excel is the safer exporter for an XLA made for Excel.

Online converters

Direct online XLA conversion is generally unsuitable: services may not support the add-in container, cannot reproduce its VBA behavior, and may expose confidential data or executable code to a third party. If the XLA contains only nonconfidential data, extract that data into a normal workbook locally first. Services such as CloudConvert or Zamzar can be considered for supported ordinary spreadsheet files, but check their current input list, retention policy, and output before uploading; do not expect them to preserve add-in functionality.

Quality and compatibility checks

After export, check formulas, named ranges, external links, charts, formatting, hidden sheets, and data validation. Formulas that call an add-in function can become #NAME?, retain broken links, or produce different results when the XLA is unavailable.

If the macros or custom functions are required, keep the original XLA installed and use the extracted workbook only for data, or save a macro-enabled workbook as .xlsm when the code is part of the workbook and can legally be migrated. An .xlsm file still cannot reproduce add-in registration automatically. Renaming .xla to .xlsx does not convert it and can make the file unreadable.