Opening XLSX files with Excel

File ex­ten­sions indicate what format the file is in and which programs can be used to open the files. XLSX is the default format used in Microsoft Excel and is a popular spread­sheet program that is part of the Microsoft 365 package.

The XLSX file has been the default format to save spread­sheets without macros in Microsoft Excel since 2007. It is, thus, the standard spread­sheet format. These types of spread­sheets can be used to perform cal­cu­la­tions or create diagrams, for example.

Before Office 2007, Excel used to save spread­sheets as XLS files using the .xls extension. Since the pub­li­ca­tion of Office 2007, Excel has used the XML-based file format XLSX by default. Unlike XLS, XLSX is a kind of archive. The in­di­vid­ual parts of a document are saved sep­a­rate­ly and bundled together in the file.

The easiest way to open a file with the XLSX extension is to use a rel­a­tive­ly recent version of Microsoft Excel. You will have no trouble opening files in the XLSX format if you use version 2007 or higher.

To open XLSX files in Excel, simply double click on the file. If you have a com­pat­i­ble version of Excel installed on your computer (i.e. 2007 or higher), the file will au­to­mat­i­cal­ly open.

If Excel is already open, you can use your mouse to drag the XLSX file onto the open spread­sheet. To do so, click on the XLSX file, keep the mouse button held down, drag the file onto the open Excel spread­sheet and then release the button. This will also open the XLSX file.

If the XLSX file does not au­to­mat­i­cal­ly open in Excel despite there being a com­pat­i­ble version of Excel installed on your computer, the pop-up menu can help. Use your mouse to right-click on the XLSX file and select the “Open with” option. A window will open rec­om­mend­ing programs that could open the file. From there, click on Excel and the software will open the file. If you do not see Excel on the list, you probably have not installed it.

For older versions, such as Excel 2003, you used to be able to download a com­pat­i­bil­i­ty pack from the Microsoft homepage. However, this download is no longer of­fi­cial­ly available. The free-to-use Excel Viewer, which was used by many to open the new file format, is also no longer of­fi­cial­ly provided by the publisher. That means it is no longer possible to open and work with the new format in older versions of Excel.

However, you do not nec­es­sar­i­ly need to buy a new version of Excel to open XLSX files. There are free-to-use al­ter­na­tives. Microsoft itself offers a solution through Excel Online which you can use directly in your browser. All you need is a user account. Programs from other pub­lish­ers can also handle XLSX files. For example, the open source software Li­bre­Of­fice is com­pat­i­ble with Microsoft’s current file ex­ten­sions. However, sometimes the content may not match the original exactly, es­pe­cial­ly in terms of the format.

On the other hand, you can still save a file in the old XLS format in all new versions of Excel. To do so, use the “Save as” option and select the “Excel 97-2003 Workbook (*.xls)” option under “File type”. This will allow all Excel versions published since 1997 to open the file. However, some functions of the XLSX file may not be available in the XLS file, or the for­mat­ting may look slightly different. Therefore, this option is only rec­om­mend­ed if you know that the recipient of the file does not have any of the newer Excel versions.