What Is an XLSM File?

How to Open, Edit, and Convert XLSM Files

XLSM Files
XLSM Files.

A file with the XLSM file extension is an Excel Macro-Enabled Workbook file created in Excel 2007 or newer.

XLSM files are actually identical to Microsoft Excel Open XML Format Spreadsheet (XLSX) files with the only difference being that XLSM files will execute embedded macros that are programmed in the Visual Basic for Applications (VBA) language.

Just like with XLSX files, Microsoft's XLSM file format uses XML architecture and ZIP compression to store things like text and formulas into cells that are organized into rows and columns.

These rows and columns can be cataloged into separate sheets within a single XLSM workbook.

How to Open an XLSM File

Warning: XLSM files have the potential to store and execute destructive, malicious code through macros. Take great care when opening executable file formats like this that you received via email or downloaded from websites you're not familiar with. See my List of Executable File Extensions for a listing of file extensions to avoid and why.

Microsoft Excel (version 2007 and above) is the primary software program used to open XLSM files and edit XLSM files. XLSM files can be used in older versions of Excel too, but only if you install the free Microsoft Office Compatibility Pack.

You can use XLSM files without Excel with free programs like OpenOffice Calc and Kingsoft Spreadsheets. Another example of a free Microsoft Office alternative that lets you edit and save back to the XLSM format, is Microsoft Excel Online.

Google Sheets is another way you can open and edit an XLSM file online. Details for how to do that are below.

How to Convert an XLSM File

The best way to convert an XLSM file is to open it in one of the XLSM editors above, and then save the open file to another format. For example, an XLSM file opened with Excel can be converted to XLSX, XLS, PDF, HTM, CSV, and other formats.

Another way to convert an XLSM file is to use a free file converter. One way to do that online is with FileZigZag, which supports the conversion of XLSM to many of the same formats supported by Microsoft Excel, but also to ODS, XLT, TXT, XHTML, and some less common ones like OTS, VOR, STC, and UOS.

XLSM files can also be converted to a format usable with Google Sheets, which is Google's online spreadsheet program. To do this, you need to login to your Google account (it's the same login information you use to access Gmail, YouTube, Google Photos, etc.) or make a new Google account if you don't already have one.

  1. Upload the XLSM file to your Google Drive account through the NEW > File upload menu. Use the Folder upload option if you need to upload an entire folder of XLSM files.
  2. Right-click the XLSM file in Google Drive and choose Open with > Google Sheets.
  3. The XLSM file will automatically convert to a format that lets you read and use the file with Google Sheets.

Tip: You can even use Google Sheets to convert an XLSM file to a different format. With the file open in your Google account, go to File > Download as to download the XLSM file as an XLSX, ODS, PDF, HTML, CSV, or TSV file.

More Information on XLSM Files

Macros in XLSM files won't run by default because Excel disables them.

See Microsoft's Enable or Disable Macros in Office Documents to learn how to make use of them.

An Excel file with a similar file extension is the XLSMHTML file, which is similar to XLS files but is an Archived MIME HTML spreadsheet file used with older versions of Excel to show the spreadsheet data in HTML. Newer versions of Excel use MHTML or MHT to publish Excel documents to HTML.

XLSX files can contain macros as well but Excel will not use them unless the file is in this XLSM format.

More Help With XLSM Files

See Get More Help for information about contacting me on social networks or via email, posting on tech support forums, and more.

Let me know what kinds of problems you're having with opening or using the XLSM file and I'll see what I can do to help.

Was this page helpful?