Since Excel 2007, you can save your Excel file with the extension xlsX. What the last X means ?
XLSX, What the last X means?
XML is a computer language. It means eXtensible Markup Language. In fact it's a language where all the data are ordered. No easy to understand for human but for a computer, when data are ordered it's easier to store.
XLSX is a compress file
If you have on your computer an xls file and you save it in xlsx, you will see that the size has been significantly reduced.
If you change the extension xlsx to zip, you can still open your file.
But be careful ! If you edit the xml files, you may destroy the architecture of the XML file and you will no longer be able to open your Excel file (after renaming the file zip file xlsx).
Protection against macros
We have seen that the last x of a xlsx file indicates that the file is compressed and respects the XML standard. The M, of a xlsm file, indicates that the file contains macros.
A macro is a program written by an end-user to provide an automation (opening files, data comparison, data aggregation across multiple sheets, ...) but also a program may cause malfunctions. In addition, a macro can run directly when you open an Excel file, without prompting the user.
With an xls file, you don't know whether your workbook contains macros or not.
xlsX workbooks have no macro. xlsM yes.
Extension of the working area.
What are the benefits of an XLSX file?
A lot of tools are online available with a file xlsx
- The Table
- Embed file in a website (like all the exercises in this blog)
- Themes for color or font
- Better file size