Numbers to Excel

Opening a Numbers file without a Mac

Apple Numbers writes a format that only Apple software reads. There is no Numbers for Windows, Excel has never shipped an import filter for it, and double-clicking a .numbers attachment on a PC achieves nothing at all. This tool puts the file through LibreOffice, which does carry an iWork import filter, and returns an .xlsx that Excel, Google Sheets, Calc and every other spreadsheet application can open normally.

First, a word about how the file is packaged

A .numbers document is a package: a small bundle of compressed records, embedded media and preview images that macOS presents to the user as though it were a single file. Depending on the version of Numbers and how the document travelled, what lands on a Windows machine is either that bundle as one tidy file or an expanded folder full of parts. Only the single-file form can be uploaded. If you are staring at a folder, there is nothing here to hand over — ask the sender to re-save the document from Numbers, which produces the compact form again.

Numbers and Excel do not model a sheet the same way

This is the genuinely interesting difference, and the source of almost every surprise. An Excel worksheet is one grid: a single lattice of cells that fills the sheet edge to edge. A Numbers sheet is a canvas, and a table is an object placed on it. One sheet can hold four unrelated tables, two charts, a text box and a photograph arranged wherever the author wanted them, each table with its own name, its own header rows and its own footer.

Nothing in the .xlsx format can express that, so the tables have to be set down into a shared grid, one below another. Your data comes through; the arrangement does not. If the original document leaned on that free layout — a dashboard sheet, say, with small summary tables dotted around a chart — treat the conversion as a data rescue rather than a faithful reproduction, and expect to rebuild the presentation.

Formulas are rewritten, not copied

Numbers addresses cells through names rather than coordinates. A formula in a well-built Numbers document reads SUM(Expenses::Amount) — table name, then column header — where Excel wants SUM(Sheet1!C2:C40). Since the tables are being relocated into a common grid, every one of those references has to be resolved to the cells it points at and then written out in Excel’s coordinate style. Arithmetic and the familiar function names survive this well. The formulas worth checking first are the ones that referenced a whole named column, because the column they meant is now simply a range that happens to sit somewhere on a worksheet.

Cell types that Excel has no name for

Numbers lets a cell be a small control rather than a value: a checkbox, a star rating, a slider, a stepper or a pop-up menu with a fixed list of choices. Excel’s file format has no cell type for any of them, so each arrives as the value underneath — a checkbox becomes TRUE or FALSE, a rating or a slider becomes the number it was set to, a pop-up menu becomes whichever option was showing. Durations behave in the same spirit: Numbers has a real duration type that displays as 3h 20m, and Excel has to hold that as a number or a time value, so the arithmetic keeps working while the neat display does not.

How dependable is the import, honestly?

Worth being straight about. Apple has never published a specification for the Numbers format; the importer LibreOffice relies on was written by reverse-engineering it. In practice that makes it very capable with ordinary documents and less certain with the newest or most exotic features. When it cannot make sense of a document it refuses outright instead of quietly handing you a mangled workbook, which is the failure mode you want. If that happens and you can reach a Mac, Numbers exports to Excel directly under File → Export To → Excel. If you only need the figures to be readable rather than editable, a PDF exported from Numbers is the simplest answer of all. And if the file you are wrestling with turns out to be a Pages document rather than a spreadsheet, Pages to Word is the tool you want; for a read-only copy of one, Pages to PDF.

Why a browser cannot do this

The records inside a Numbers package are compressed binary structures, not text, and turning them into an Office workbook requires the compiled iWork import library that LibreOffice bundles. No browser contains it and no web page can load it, so the file is uploaded to our server, converted there in a sandboxed working directory created for that single request, and wiped — original and .xlsx together — the moment the download reaches you. From there the workbook behaves like any other: Excel to CSV strips it down to raw data, and Excel to PDF turns it into something you can circulate without anybody editing it.