+3 votes
35 views
in Sell ​​on the Internet by (76.4k points)
reopened
XLSX: how to open these files with Excel

1 Answer

+4 votes
by (506k points)
edited
 
Best answer

image

XLSX: how to open these files with Excel

File extensions give clues about their format and the programs with which they can be opened. XLSX is the standard format for Microsoft Excel , which is Microsoft's popular spreadsheet program and part of the Microsoft 365 package..

Index
  1. What is an XLSX file?
  2. How do you open an XLSX file?
    1. Step 1. Double click on the XLSX file
    2. Step 2. Drag and drop: open the XLSX file by dragging it into an Excel window
    3. Step 3.? Open with ...?: Open the XLSX file with Excel by clicking the right mouse button
  3. How can you open an XLSX file with an old version of Excel?

What is an XLSX file?

The XLSX file has been the usual saving format for tables without macros in Microsoft Excel since 2007 . Therefore, it is a completely normal spreadsheet on whose tables you can perform operations or create diagrams, for example.

Before the Office 2007 version, Excel tables were saved as an XLS file with the extension .xls . Starting with this version, Excel uses the XML-based XLSX file format by default . Compared to XLS, an XLSX file is a kind of file. The different parts of the document, such as tables or text, are saved individually and consolidated in the file..

How do you open an XLSX file?

The easiest way to open a file with the extension. xlsx is using a relatively current version of Microsoft Excel. As of version 2007, there are no problems when opening files in the XLSX format.

advice

The current version of the Excel spreadsheet program is in Microsoft 365. The Office solution offers you all the advantages of the estimated properties of Windows: Excel, Word and PowerPoint..

Step 1. Double click on the XLSX file

To open the XLSX files with Excel, double-click the file . If the computer has a compatible version of Excel installed, that is, from 2007, the file will open by itself.

Step 2. Drag and drop: open the XLSX file by dragging it into an Excel window

If Excel is already open, you can also drag the XLSX file with the mouse to the open program window . To do this, click on the XLSX file, hold down the mouse key, drag the file into the Excel window, and release the mouse key. The XLSX file will open.

Step 3.? Open with ...?: Open the XLSX file with Excel by clicking the right mouse button

If a compatible version of Excel is installed but the program does not automatically open the XLSX file, the context menu may be of help. Click on the XLSX file with the right mouse button and select the option? Open with ?. A window opens, suggesting a list of programs that can open this file. Click Excel and the software will open the file. If Excel is not on this list, it may not be installed on your computer.

How can you open an XLSX file with an old version of Excel?

For earlier versions of Excel like Excel 2003 a compatibility pack could be downloaded from the Microsoft home page, but this option is no longer officially available. Likewise, the manufacturer of the free Excel Viewer tool, which up to now was used by many users to open the new format, does not offer it officially either. It is no longer possible to open and work with the new format in older versions of Excel.

However, it is not necessary to purchase a new version of Excel to open an XLSX file. There are free alternatives : Microsoft itself offers Excel online as a solution that can be used directly in the browser. You only need a user account for this. Also third-party programs can work with XLSX files. For example, the free source program LibreOffice is compatible with current Microsoft extensions. However, it could be the case that the content (especially as regards the format) does not correspond exactly to the original.

In contrast, in all new versions of Excel it is still possible to save a file in the old XLS format . For this you must use the option? Save as? and, in? Book file type ?, select the option? Excel 97-2003 book (* .xls) ?. In this way, all Excel versions since 1997 can open this file. However, some functions in the XLSX file may no longer be available in the XLS file or the format appears changed. Therefore, it is recommended to use this option only if it is known that the recipient of the file does not have a current version of Excel.

advice

There are other possibilities to convert an XLSX file to XLS so that it can be opened in earlier versions of Excel.


...