XLAM File (What It Is & How to Open One) GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > File Types

What Is an XLAM File?

How to open XLAM files in Excel

By Tim Fisher Tim Fisher Senior Vice President & Group General Manager, Tech & Sustainability Emporia State University Tim Fisher has more than 30 years' of professional technology experience. He's been writing about tech for more than two decades and serves as the VP and General Manager of Lifewire. lifewire's editorial guidelines Updated on February 8, 2022 Tweet Share Email Tweet Share Email File Types File Types Apps Windows MS Office Linux Google Drive Backup & Utilities Design Cryptocurrency

What to Know

An XLAM file is an Excel Macro-Enabled Add-In file.Open one with Excel, through the Add-ins window.Change it to an XLSM file by editing its code. This article explains what XLAM files are, including how to open one and what your options are for converting one to a different format.

What Is an XLAM File

A file with the XLAM file extension is an Excel Macro-Enabled Add-In file that's used to add new functions to Excel. Like Excel's XLSM and XLSX file formats, these add-in files are XML-based and saved with ZIP compression to reduce the overall size. Excel Add-In files that don't support macros might use the XLL or XLA file extension.

How to Open an XLAM File

XLAM files can be opened with Microsoft Excel 2007 and newer. Earlier versions of Excel can open one, too, but only if the Microsoft Office Compatibility Pack is installed. Macros in an XLAM file may contain malicious code. Take great care when opening executable file formats received via email or downloaded from websites you're not familiar with. There are two primary methods for opening the file:

Open the XLAM File Through Excel' s Menu

One way you can open it is through the File > Options > Add-ins > Go button. The other path is Developer > Add-Ins. See Microsoft how-to to learn how to enable the Developer tab if you don't already see it. The latter method, through the Developer tab, is also used to open COM Add-Ins (EXE and DLL files). No matter which route you go, the result will bring you to the Add-Ins window where you can select Browse to load the file. If your add-in is already listed in this window, just put a check next to the name to enable it.

Copy the XLAM Files to the AddIns Folder

Another option for opening the file that's especially useful if you have more than one, is to put it in this folder so Excel will automatically load it when it opens:
C:\Users\[username]\AppData\Roaming\Microsoft\AddIns\ Some XLAM files that are downloaded from the internet are blocked and can't be fully used in Excel. Right-click the file in Explorer and choose Properties. In the General tab, select Unblock to have full access to it.

How to Convert an XLAM File

There shouldn't be any reason to use a file converter to save the file to a different format. While those tools do work for lots of file formats, this isn't one of them. See this Excel Forum thread on converting XLAM to XLSM if you want to do that. It involves editing the IsAddIn property to False.

Still Can' t Open It

If your file doesn't open at this point, it's highly likely you're not dealing with an actual XLAM file. This might be the case if you've misread the file extension, which usually happens when the letters look a lot alike. For example, XAML could easily be confused for XLAM even though those files are used with a different program. AML and LXA are some others, where the format is either ACPI Machine Language or Arc Macro Language (for the former), or Microsoft Speech Lexicon (the latter). If you're having trouble figuring out what to do, research the actual file extension at the end of your file to learn more about the format it might be in and find download links to the software you need to open/edit/convert it. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire XLTM File (What It Is & How to Open One) DDL File (What It Is & How to Open One) XAR File (What It Is and How to Open One) What Is a PDF File? (And How to Open One) XLR File (What It Is & How to Open One) CSO File: What It Is and How to Open One EAP File (What It Is and How to Open One) ARW File (What It Is & How to Open One) HDMP File (What It Is and How to Open One) WPD File (What It Is & How to Open One) MQ4 File (What It Is & How to Open One) DRF File (What It Is & How to Open One) CV File (What It Is & How to Open One) ALP File (What It Is and How to Open One) DYLIB File (What It Is & How to Open One) DMC File (What It Is and How to Open One) Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies