Office Open XML spreadsheet · .xlsx

The XLSX format

A spreadsheet is a grid of cells where formulas reference other cells. XLSX stores that dependency graph, not a printed page.

What makes a spreadsheet a spreadsheet is not the grid but the references: a cell can hold a formula pointing at other cells, and changing one value ripples outward. XLSX is built around recording that relationship, which is why it is a poor fit for anything that needs a fixed printed appearance.

The format itself

What XLSX actually is

XLSX is the Office Open XML spreadsheet format, introduced alongside DOCX with Office 2007 and covered by the same ECMA-376 and ISO 29500 standardisation. Like its sibling it is a ZIP archive, but the parts inside describe an entirely different object: not flowing prose but an addressable coordinate space.

Each worksheet is its own XML part listing rows and, within them, only the cells that actually contain something — a sparse representation, which is how a sheet nominally a million rows deep stays small. A cell records its type, a style reference, optionally a formula, and typically the last computed value of that formula as a cached result. Text is not stored inline but pulled from a shared-strings table, so a label repeated down a column is stored once and referenced thousands of times.

Separate parts hold the styles — number formats, fonts, fills, borders — and a calculation chain that records the order in which formulas must be evaluated so that dependencies resolve correctly. This is the heart of the format: an XLSX is a dependency graph with presentation attached. It has no inherent pagination at all. Where the page breaks when you print depends on print areas, scaling settings, repeated header rows, margins and orientation, all of which are configuration rather than layout.

Where it is the right answer

Common uses

01
Financial models and budgets where assumptions feed calculated outputs
02
Data tables exported from databases, analytics tools and accounting systems
03
Trackers, schedules and registers maintained collaboratively over time
04
Source data behind charts and pivot tables that recalculate as the data changes
05
Structured interchange between business systems that both understand the format
06
Reports assembled from formulas and then exported to PDF for circulation

Both sides

What XLSX does well, and where it stops.

Strengths

Live calculation: formulas make relationships explicit and keep derived figures correct as inputs change
Sparse storage means very large grids remain compact on disk
The shared-strings table makes repetitive textual data compress efficiently
Open, standardised XML that many applications and libraries can read and write
Multiple worksheets in one file, with cross-sheet references tying them together

Limitations

No fixed pagination. Print output depends on print areas, scaling, repeated headers and margins — settings, not stored page geometry.
We deliberately offer no spreadsheet-to-PDF conversion. A faithful conversion means resolving formulas, honouring print areas and scaling, deciding pagination and reproducing every cell style; a browser-side implementation would produce output too unreliable to ship, so we would rather not ship it.
Cached formula values can be stale if a file was written by a tool that did not recalculate, so a reader may show figures that no longer follow from the inputs.
Formula support varies between applications, and functions specific to one vendor may not evaluate elsewhere.
The macro-enabled .xlsm variant can carry executable code, which is a real security consideration when files arrive from outside.

Specification

Technical detail

The facts worth knowing before choosing XLSX for a job, rather than after.

Full name: Office Open XML spreadsheet
MIME type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Extension: .xlsx
Introduced: Office 2007, by Microsoft
Standards: ECMA-376, ISO 29500
Container: ZIP archive of XML parts
Key parts: Worksheets, shared-strings table, styles, calculation chain
Document model: Cell grid with formulas, references and cached computed values
Macros: Not permitted; macro-enabled workbooks use .xlsm

Questions about XLSX

Why do you not offer an XLSX to PDF tool?

Because we could not make it trustworthy in a browser. Converting a spreadsheet to a page means evaluating every formula, applying the workbook’s print areas and scaling, choosing where the grid breaks across pages, repeating header rows, and reproducing number formats, fills and borders faithfully. Getting any of that subtly wrong produces a document that looks plausible and reports the wrong figures. Export the PDF from your spreadsheet application, which already has all of that logic, and then use our PDF tools on the result.

What should I do instead?

Use Print or Export to PDF in Excel, LibreOffice Calc, Numbers or Google Sheets — check the print area and scaling first. Once you have the PDF you can merge, split, compress, protect or watermark it here, entirely in your browser.

Why does a spreadsheet print across so many pages?

Because nothing in the file says where a page should end. The application decides from the print area, scaling and orientation you have set, and an unbounded grid with no print area defined will happily spill columns onto extra sheets. Setting a print area and fit-to-width scaling before exporting solves it.

Are the numbers in an XLSX stored, or calculated when opened?

Both. The formula is stored, and so is the value it last produced, as a cached result. That is why a file can open showing figures instantly, and also why a workbook written by a tool that did not recalculate can display values inconsistent with its own formulas.

Compare with