Convert XLSM to _XLS

Understanding xlsm and xls file formats

XLSM is a Microsoft Excel file format introduced with Excel 2007. It supports macros, which are automated scripts written in VBA (Visual Basic for Applications). The XLS format is the older Excel binary file format, used by Excel 97-2003, and does not natively support the advanced features and macro security of XLSM files.

Why convert xlsm to xls?

Converting XLSM to XLS is often necessary for compatibility with older versions of Excel or third-party applications that do not support the newer XLSM format. However, some advanced features and macro functionalities may be lost or altered during conversion.

How to convert xlsm to xls

The most reliable way to convert an XLSM file to XLS is by using Microsoft Excel itself. Here’s how you can do it:

1. Open your XLSM file in Microsoft Excel.
2. Go to File → Save As.
3. Choose the location where you want to save the file.
4. In the Save as type dropdown menu, select Excel 97-2003 Workbook (*.xls).
5. Click Save.

Excel will warn you if any features or macros are not compatible with the XLS format. Review these warnings to ensure your data and macros are preserved as much as possible.

Best software for xlsm to xls conversion

• Microsoft Excel (recommended): Provides the highest compatibility and preserves most features.
• LibreOffice Calc: Open your XLSM file and use File → Save As to export as XLS. Some macro functionality may be lost.
• Online converters (e.g., Zamzar, CloudConvert): Upload your XLSM file and choose XLS as the output format. These are convenient but may not handle complex macros well.

Important considerations

• Macro compatibility: XLS files support basic macros, but advanced VBA features from XLSM may not work as expected.
• Data loss: Some newer Excel features (tables, slicers, advanced formulas) may not be supported in XLS.
• Backup: Always keep a backup of your original XLSM file before converting.