What is the difference between .xlsb and .xlam?
- Extension
- .xlsb
- .xlam
- Format
- Binary
- Binary
- Category
- Spreadsheet
- Spreadsheet
- Developer
- Microsoft
- Microsoft
- Description
- The xlsb file type is a binary file format used to store Excel spreadsheets. It is a compressed version of the xlsx file type and can only be opened in the Microsoft Excel application. Compared to the xlsx, the xlsb format is much smaller in size and is less prone to corruption.
- xlam (Excel Open XML Macro-Enabled Add-In) is a file type used in Microsoft Excel which contains code written in Visual Basic for Applications (VBA). It is used to store and deploy macros, custom user forms, and other Excel add-in components. xlam files can be opened and edited in Excel, but they are not as secure as other Excel file types.
- MIME Type
- application/vnd.ms-excel.sheet.binary.macroEnabled.12
- application/vnd.ms-excel.addin.macroEnabled.12