An XLSX file is an Excel spreadsheet created by Microsoft Excel or another spreadsheet program, such as OpenOffice Calc or Apple Numbers. It stores data in worksheets, which contain cells arranged in a grid of rows and columns, and may also contain charts, mathematical functions, styles, and formatting. XLSX files are commonly used to store financial data and to save simple or complex mathematical models.
XLSX file open in Microsoft Excel 2019
The Microsoft Excel Open XML Spreadsheet format was introduced with the release of Microsoft Excel 2007. Since the introduction of the format, XLSX files have become one of the most common file types for saving data in spreadsheets.
With the release of Excel 2007, XLSX files replaced .XLS files as the standard file for saving spreadsheets in Excel. Unlike XLS files, which store spreadsheet data in a single binary file, XLSX files are saved in the Open XML format, which stores data as separate files and folders in a compressed Zip package. The archive includes the [Content_Types].xml file, which describes the spreadsheet, and an .XML file for each worksheet within the spreadsheet.
Each cell in an XLSX spreadsheet may be formatted individually. For example, cells may have a number, text, currency, or another format, as well as color, border style, custom font, and size. Cells may also reference other cells to compute a resulting value.
NOTE: To explore the contents of an XLSX file, rename the .xlsx extension to .zip and then decompress the resulting file with any Zip decompression utility.
You can open XLSX files with Microsoft Excel in Windows and in macOS. Excel is the best option for opening XLSX files because it fully supports the formatting of Excel spreadsheets, which includes images, graphs, and spacing of data fields. Excel is also available for Android and iOS devices.
There are a large number of other spreadsheet programs that can open and edit XLSX files but they may not fully support the formatting of the original spreadsheets. Alternative programs include Corel Quattro Pro (Windows), Apple Numbers (Mac), and OpenOffice Calc (multiplatform).
You can also open XLSX files with various web programs. Google Sheets is a great free option that allows you to upload an XLSX file and view, edit, save, and convert the spreadsheet.