Without doubt 99% of all Excel files are saved in the XLSX format today. However you still have some other file formats available: For instance XLSM, XLSB, or even “older” Excel users can still use the XLS file type. What are the main differences of such file formats? And even more significant: Which one should you use?
If you save an Excel file for the very first time or use the “Save As” command, you will be asked for a folder, file name along with the file type. By default, the system suggests the XLSX file format. So which file extension will you use? The answer – depends on your needs. Before we make a decision, we take a look at the most significant file formats in Excel with their pros and cons first.