| Extension | .xlsm |
| Category | documents |
| Description | The XLSM format is a file extension used in Microsoft Excel to denote a spreadsheet containing macros written in the Visual Basic for Applications (VBA) programming language. It is an evolution of the traditional XLSX format, which stores data without macros. XLSM files offer users the ability to automate tasks, perform calculations, and create custom functions within Excel using VBA macros. These macros can range from simple scripts to complex automation routines, enabling users to streamline workflows and enhance productivity. XLSM files are commonly used in business, finance, and data analysis applications where automation and customization are required. |
| Technical details | XLSM files are based on the Open XML format, which is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations, and word processing documents.
Within the compressed archive, the main components of an XLSM file include XML files for workbook structure, styles, themes, and shared strings. These XML files describe the content and formatting of the spreadsheet.
XLSM files support macros written in VBA (Visual Basic for Applications).
XLSM files can be opened and edited in Microsoft Excel, as well as other spreadsheet software that supports the Open XML format.
The ".xlsm" file extension is used to distinguish macro-enabled Excel workbooks from standard Excel workbooks, which typically have the ".xlsx" extension. This helps users and applications identify files that contain macros. |
