What is the XLA file format?
.xla is an add-in file associated with Microsoft Excel, introduced in the Excel 97 era as the standard mechanism for packaging reusable macros and custom worksheet functions. Like .xls workbooks, .xla uses the OLE2 Compound File Binary (CFB) container format - identified by the D0 CF 11 E0 magic bytes at the start of the file - and as such cannot be opened or read meaningfully in a plain text editor.
Internally, an .xla file is essentially a BIFF8 workbook flagged as an add-in, with an embedded VBA project that runs automatically when Excel loads the file. An .xla add-in can be an official Excel extension created by Microsoft or a custom, user-created file. Add-ins are typically built for a specific Excel version and may expose new menu commands, worksheet functions, or formatting tools.
Users who frequently work in Excel quickly arrive at the conclusion that additional features to make work easier and more streamlined are more than welcome. Good examples are additional time and date utilities or a spreadsheet format converter. Unlike standalone macro files, .xla add-ins load silently at startup without adding visible sheets to any open workbook.
.xla files are more structured than raw macro scripts, yet they still carry security risks because they contain executable VBA code. Unverified .xla files should not be opened. Some .xla add-ins also have limitations regarding number of activations or require additional software to function correctly. Since Excel 2007, .xla has been superseded by .xlam, which uses a ZIP-based Open XML package rather than the legacy binary container; modern Excel versions can still load .xla files but the format is considered legacy.
Security & safety
RISK: HIGHAn XLA is executable code: loading it runs its VBA in Excel with your privileges, so a malicious or tampered add-in can do real harm (the same threat class as macro-laden .xlsm/ .xlam, and a known malware vector). Load XLA add-ins only from sources you trust and have verified. Modern Office blocks macros in files marked as coming from the internet (Mark of the Web) by default - keep that protection on; if Excel warns or disables the add-in, don't override it for unsolicited files. Many organisations block add-in formats at the gateway. Inspect unfamiliar add-ins in the VBA editor (Alt+F11) before enabling, if the project isn't password-locked.
Format details
in a nutshellPrograms that open XLA files
Technical details
deep spec| Container format | OLE2 Compound File Binary (CFB) - the same structured storage used by all Office 97-2003 binary formats |
| Internal binary format | BIFF8 (Binary Interchange File Format 8), identical base structure to .xls workbooks |
| File signature (magic bytes) | D0 CF 11 E0 A1 B1 1A E1 at byte offset 0 - the standard CFB/OLE2 header |
| MIME type | application/vnd.ms-excel |
| Macro language | VBA (Visual Basic for Applications), stored as a VBA project stream inside the CFB container |
| Add-in flag | Workbook IsAddin property set to true; all worksheets are hidden from the user interface at load time |
| Loading mechanism | Registered via Excel's Add-In Manager; loaded automatically at Excel startup before any user workbook opens |
| UDF support | Can expose User-Defined Functions (UDFs) callable in cell formulas of any open workbook |
| Introduced with | Microsoft Excel 97; remained the primary add-in format through Excel 2003 |
| Superseded by | .xlam (Excel 2007+), which uses a ZIP-based Open Packaging Convention (OPC) container instead of CFB |
| Grid size limit | BIFF8 constraint: 65,536 rows × 256 columns per sheet - same ceiling as .xls workbooks |
| Security model | Subject to Excel macro security settings; opening an untrusted .xla file can execute arbitrary VBA code |
| Shared CFB header | Indistinguishable from .xls, .doc, and .ppt by magic bytes alone - file type is determined by internal OLE2 stream names |
| Released | Excel 97 era (legacy add-in format; superseded by .xlam in Excel 2007) |
| Specification | learn.microsoft.com |
XLA conversions
Community Q&A
asked by usersNo questions yet - be the first to ask about XLA files.