Difference Between Xls & Xlsm

Tim Fisher has 30+ years' professional technology experience. He focuses on support & Microsoft topics but is an expert in all areas of tech. He's also the VP and General Manager of i-google-map.com.

Bạn đang xem: Difference between xls & xlsm


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 exexinh tươi embedded macros that are programmed in the Visual Basic for Applications (VBA) language.


Just lượt thích with XLSX files, this format uses XML and ZIPhường khổng lồ store things like text and formulas inlớn cells that are organized inlớn rows and columns. The data can be cataloged within separate sheets, all stored in a single workbook file.


*

XLSM files have the potential to store và exedễ thương destructive, malicious code through macros. Take great care when opening executable file formats like this that you received via tin nhắn or downloaded from websites you"re not familiar with. See our List of Executable File Extensions for a listing of file extensions to avoid and why.


Microsoft Excel (version 2007 & above) is the primary software program used to open và 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 không lấy phí programs like OpenOffice Calc and WPS Office Spreadsheets. Another example of a miễn phí Office alternative sầu that lets you edit và save sầu baông chồng to this format is Microsoft Excel Online.


Google Sheets is another way to open và edit an XLSM file online. Details for how khổng lồ do that are below.


Quattro Pro, a part of WordPerfect Office, supports this format, too, but it"s not free. OfficeSuite Professional for Android and iOS works as well.

Xem thêm: Nối Móng Là Gì - Cách Phân Biệt Móng Đắp Bột Và Móng Đắp Gel


How to Convert an XLSM File

The best way khổng lồ convert an XLSM tệp tin is lớn open it in one of the editors above sầu, and then save sầu the open tệp tin to lớn another format. For example, if the file is opened in Excel, it can be saved khổng lồ XLSX, XLS, PDF, HTM, CSV, and other similar formats.


Another way khổng lồ convert one is lớn use a free file converter. One example is FileZigZag, which can save the file khổng lồ many of the same formats supported by Excel, as well as ODS, XLT, TXT, XHTML, and some less common ones lượt thích OTS, VOR, STC, và UOS.


If you"re not wanting to lớn download a converter and would lượt thích lớn save sầu the file online to access it later, use the Google Sheets online spreadsheet tool. Doing this converts the file into lớn a special format so that you can make changes to it.


Upload it khổng lồ your Google Drive account through the New > File upload option. Choose Folder upload instead if you need lớn upload an entire thư mục of them.


*

*

Both the original file và the converted one now exist in your Google Drive account. The one that can be edited in Google Sheets is identified by a green inhỏ with an off-centered trắng cross.


You can even use Google Sheets to lớn convert an XLSM file lớn a different format. With the file open there, go to lớn File > Download to tải về it 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. Microsoft has an explanation on enabling và disabling macros in Office files if you need help.


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


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