File Formats & Media

XLSX File

Definition

XLSX is the spreadsheet half of Office Open XML, the family standardised as ECMA-376 and ISO/IEC 29500. The container is an ordinary ZIP, and unzipping a workbook makes the shape obvious: xl/workbook.xml lists the sheets, xl/worksheets/sheet1.xml holds the cells of the first one, and xl/sharedStrings.xml stores each distinct piece of text once so that a column repeating the word Pending ten thousand times costs ten thousand small references rather than ten thousand copies. Formulas are stored alongside the last computed value, which is why a workbook opened in a different tool sometimes shows numbers that no longer match the formulas. A single sheet tops out at 1,048,576 rows and 16,384 columns, limits that have not moved since Excel 2007. The content type is application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, and .xlsm is the same container with macros allowed.

Why It Matters

A spreadsheet published for other people is nearly always published for the wrong reason. If the audience only needs to read the numbers, an XLSX makes them download a file, open a desktop application and trust a workbook from a stranger, where a table on a web page would have taken one click. If they genuinely need to compute with it, the workbook is right — but then the hidden contents matter, because sheets you have hidden rather than deleted travel with it, as do pivot caches holding a full copy of source data you may not have meant to share. Size is rarely the issue: a 12,000-row sales export is typically under 1 MB, since the XML compresses extremely well inside the ZIP.

How It Works

Serving an XLSX correctly means one long Content-Type line, spreadsheetml.sheet for a normal workbook, and a Content-Disposition header naming the file so it saves as something a human recognises. The browser has no spreadsheet engine, so it writes the bytes to disk and hands the file to whatever the operating system has registered for the extension — Excel, LibreOffice Calc, Numbers, or Google Sheets after an upload. Because the parts inside are already deflate-compressed, a further compression layer on the response gains nothing. When the goal is people reading rather than editing, the common alternatives are exporting a CSV for tools, a PDF for reading, or generating a plain HTML table, all of which open without a download.

Real-World Example

A trade body publishes its annual benchmark workbook at benchmarks.99helpers.site/2026-costs.xlsx, a 780 KB file with four sheets and a formula-driven summary tab. Hosted on 99helpers it downloads under its own name in one click, and version history keeps the 2025 and 2024 editions reachable rather than overwritten. They pair it with a small HTML page showing the headline figures, and the analytics separate the two clearly: 3,400 page views, 290 workbook downloads. The people who needed to model something got the workbook; everyone else got their answer without leaving the browser.

Common Mistakes

  • Publishing a workbook when a table would do — every reader pays a download and an application launch to see numbers that could have rendered in place
  • Leaving hidden sheets, pivot caches or personal ranges in the file — they are part of the archive and open along with everything else
  • Shipping .xlsm when nothing needs a macro — many organisations block macro-enabled workbooks at the mail gateway or open them in protected view
  • Assuming the recipient sees the same numbers — formulas referencing an external workbook resolve to stale cached values on anyone else's machine

Related Terms

Put a file online in seconds

Drop in a document, an image, a page or a whole static website and share the link — free, with no build step and no server to set up.

Host a file free →