What is an XLSX file?
Short answer
An XLSX file is a spreadsheet saved in the Office Open XML format, the default for Microsoft Excel since Excel 2007. It is a ZIP package of XML files holding cell values, formulas, formatting and multiple worksheets. The format is standardized as ECMA-376 and ISO/IEC 29500, and Excel, LibreOffice, Google Sheets and Numbers can all open it.
XLSX is the standard Excel workbook format. Microsoft introduced it with Excel 2007 to replace the older binary .xls format. The underlying specification is Office Open XML, published as ECMA-376 and as ISO/IEC 29500. Because the format is documented, other programs can read and write it without Microsoft software.
What is inside an XLSX file?
An XLSX file is a ZIP archive. Rename a copy to .zip, unzip it, and you will find a folder of plain XML files. A small workbook typically contains:
| Part | What it holds |
|---|---|
[Content_Types].xml |
Declares the type of every part in the package |
_rels/.rels |
Points to the main workbook part |
xl/workbook.xml |
The list of sheets, defined names and calculation settings |
xl/worksheets/sheet1.xml |
The cells of the first sheet, including formulas and frozen panes |
xl/styles.xml |
Number formats, fonts, fills and borders |
xl/sharedStrings.xml |
Text values that are reused across cells (written by Excel) |
docProps/ |
Title, author and other document properties |
Charts, images, comments and pivot tables each get their own parts in the same package.
How is a cell stored inside an XLSX file?
A cell is an XML element with an address and a value. A formula is stored together with its last computed result:
<c r="B2"><f>A2+1</f><v>2</v></c>
This is why a program that cannot calculate, such as a script that only reads the file, can still show the numbers. Dates are stored as serial numbers. The date October 8, 2026 is the number 46303 in the default 1900 date system, and a number format turns it back into a readable date.
What are the size and row limits of an XLSX file?
- 1,048,576 rows by 16,384 columns per sheet (column XFD is the last).
- 32,767 characters in a single cell.
- Numbers keep 15 significant digits. A 16-digit ID typed as a number loses its last digit, so store long IDs as text.
How do XLSM, XLSB and XLTX differ from XLSX?
.xlsmis the same package with a macro project (VBA) added..xlsbis a binary variant that opens faster on very large workbooks..xltxis a template.
Excel 2003 and earlier cannot open XLSX files unless the Office Compatibility Pack is installed.
When should I save a file as XLSX?
Use XLSX when the file must keep formulas, several sheets, number formats, charts or frozen header rows. Use CSV when you need plain rows of values for a database or script, and ODS when the recipient works mainly in LibreOffice. The format comparison on the blog goes through the trade-offs for each case.
What problems can come up when an XLSX file is shared?
- Opening an XLSX from an unknown source can trigger macro warnings only if it is
.xlsm. A plain.xlsxcannot contain VBA macros, but it can contain links to external workbooks. - Other programs may recalculate or drop features they do not support, such as some chart types, newer functions or conditional-formatting rules. Check the results after converting.
- File size is usually small because the ZIP compresses the XML. A workbook of several hundred thousand rows can still reach tens of megabytes.
For an example of a workbook that depends on live formulas, see the monthly household budget template, which downloads as XLSX among other formats.