Microsoft Excel allows users saving spreadsheet in a variety of file formats with the extension XLSX, XLSM and XLSB. What’s the difference between XLSX, XLSM and XLSB? Read this article to find the answer.
XLSX and XLSM are the successors of the old XLS format. While the old XLS format has stored the data binary, XLSX and XLSM are internally using the XML format (Extensible Markup Language).
The difference between XLSX and XLSM is that XLSX does not contain macros and in contract XLSM does. So, if you do not want to worry about any security settings, you can just choose the XLXS format for your spreadsheet. Macros are simply not stored when using the XLXS format.
- XLSX: Excel Workbook without Macros
- XLSM: Excel Workbook with activated Macros
- XLSB: Excel Binary Workbook
The XLSB format includes a binary workbook and thus is similar to the old BIFF format of the XLS files. The XLSB files have the advantage that they are smaller and can be processed and opened more quickly compared to the XML based formats XLSX and XLSM. Therefore, they are always a good choice when comprehensive data is available, if complex calculations must be calculated or if there are other limitations of the XML format.
By the way, you can open the XLXS and XLSM files in an archive program such as 7-Zip. Then you see the contained XML files.
Note that if you want to change a file format from one to another, you couldn’t just rename the file extension. You need to use a piece of converter software, such as Gmagon XLS2csv, which helps you convert .xls/.xlsx files to .csv text files in batch mode.