Difference Between Xls & Xlsm

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Both XLS and XLSM files are spreadsheet files for Microsoft Excel, a widely-used spreadsheet program.The main difference between the file types is that XLSM files contain macros and XLS files do not.

Advertisement

Definition

Video of the Day

Macros are scripts that perform small, automated tasks within another program. Macros in XLSM files can help you complete repetitive tasks, like formatting columns of data, more quickly.

Advertisement

Video of the Day

Safety

Microsoft Excel disables macros by default because macros can be used to distribute viruses, potentially harming your computer. Even if an Excel document contains macros, Excel will not execute them unless you save the file in XLSM format.

Advertisement

Programs

You can open XLS files in a variety of spreadsheet programs, including OpenOffice Calc, WordPerfect Office and Gnumeric. Since you can only open XLSM files in Excel or WordPerfect, saving them as XLS files instead will make it easier to access the files.

Advertisement

Advertisement

Advertisement

references