What Is an XLSM File?
A file with the XLSM file extension is an Excel Macro-Enabled Workbook file created in Excel 2007 or newer. These files are 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, this format uses XML and ZIP to store things like text and formulas into cells that are organized into rows and columns. The data can be cataloged within separate sheets, all stored in a single workbook file.
How to Open an XLSM File
Microsoft Excel (version 2007 and above) is the primary software program used to open and edit XLSM files. They 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 WPS Office Spreadsheets. Another example of a free Office alternative that lets you edit and save back to this format is Microsoft Excel Online. Google Sheets is another way to open and edit an XLSM file online. Details for how to do that are below. Quattro Pro, a part of WordPerfect Office, supports this format, too, but it’s not free. The free OfficeSuite works as well, and can be installed on your computer or phone.
How to Convert an XLSM File
The best way to convert an XLSM file is to open it in one of the editors above, and then save the open file to another format. For example, if the file is opened in Excel, it can be saved to XLSX, XLS, PDF, HTM, CSV, and other similar formats. Another way to convert one is to use a free document file converter. One example is FileZigZag, which can save the file to many of the same formats supported by Excel, as well as ODS, XLT, TXT, XHTML, and some less common ones like OTS, VOR, STC, and UOS. If you’re not wanting to download a converter and would like to save the file online to access it later, use the Google Sheets online spreadsheet tool. Doing this converts the file into a special format so that you can make changes to it. Here’s how:
Still Can’t Open It?
If you’ve tried all the programs mentioned above, and none of them will open or convert your file, it’s highly unlikely you have an actual spreadsheet document. What’s probably happening is that you’ve mixed up this file extension with another one that looks like it. XISE is one example where the file extension resembles XLSM. Files with that extension are actually used by a program called ISE from Xilinx, for project files. Using Excel to open that kind of file just won’t work. Another is SLX. The first three letters are the same as XLSM, despite the unrelated format that uses that extension—it’s a model created with Simulink from MathWorks.
More Information on XLSM Files
Macros in XLSM files won’t run by default because Excel disables them. Microsoft has an explanation on enabling and disabling macros in Office files if you need help. 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 won’t use them unless the file is in this XLSM format.
