A .numbers file is a zip. Inside it, when the spreadsheet was saved with previews on, sits a PDF of the sheets rendered by Numbers itself. Taking it out is an extraction rather than a conversion, so it is exact.
What it is exact about is the sender's print layout. A spreadsheet has no pages until somebody decides where they fall, and that decision is saved into the file. If you need the figures rather than the look of them, a PDF is the wrong thing to be asking for.
Numbers is the odd one of the three Apple formats here. A document has pages and a deck has slides, so both have an obvious shape to render. A spreadsheet has a canvas, and turning a canvas into paper is a set of choices that somebody has to make before the render exists.
What is inside a .numbers package
Index/*.iwa
The sheets, formulas and formatting, in Apple's private binary format.
QuickLook/Preview.pdf
The sheets as they would print, rendered by Numbers. This is the part worth having.
Data/
Images and media placed on the sheets, in their original form.
Metadata/
Which version of Numbers wrote the file, and the identifiers it syncs with.
The formulas and the cell values live in the first entry, in a format with an undocumented schema. That is why no tool outside Apple's software can hand you a working spreadsheet from a .numbers file, and why anything promising one is guessing at a moving target.
A spreadsheet has no pages until somebody puts them there
Numbers does not work the way Excel does. A sheet is a free canvas, and tables are objects placed on it rather than a grid that fills the window. You can have four unrelated tables and a chart scattered across one sheet, which is pleasant to work in and means nothing at all about where a page should break.
So the usual complaints about an extracted Numbers PDF are not faults. A table split down the middle across two pages, a sheet that came out at ten per cent scale, a document that is one enormous page: each is the print setup as the sender left it. Nobody re-laid it out for your screen, because the render was made before anyone knew you would see it.
It follows that a sheet the sender excluded from printing is not in the file at all, and neither are hidden rows and columns. If a figure you expected is missing, that is the likeliest reason and it is worth asking about before treating the document as incomplete.
When a PDF is the wrong thing to ask for
This page exists because people are sent .numbers files and need to read them. Reading is what a PDF is good for. If what you actually need is the figures, stop here and ask for a different file, because every route from a PDF back to data loses something.
You need to read it, check it or file it.
The layout carries meaning, as in an invoice or a report.
You are forwarding it to somebody who only needs to look.
You want to sign it or mark it up.
You need to sort, filter or total the figures.
You will paste the numbers into something else.
You need the formulas, which no render preserves.
The document is long and you only want part of it.
Exporting either takes the sender two clicks in Numbers, under File and then Export To. It is a far better trade than any of us pulling a table back out of a rendered page, which is guesswork even when it is done well. If you are stuck with a PDF and the figures matter anyway, PDF to Excel makes a best effort at it and is honest about where that effort ends.
When the preview is not there
Some packages arrive without one, either because the spreadsheet was saved with previews switched off, because it came from an older version of Numbers, or because a mail client re-zipped the package in transit and dropped what it thought was spare.
No tool can help with that, and the reason is worth stating rather than dressing up: the sheets exist only in Apple's private format and reading it needs Apple's software. The fix belongs to the sender and takes about ten seconds. Open the file, then File, Export To, and choose PDF, or better still CSV or Excel. On an iPhone or iPad, open it, tap the three dots, then Export.
Questions people actually ask
01Can I open a .numbers file on Windows?
Yes, when it was saved with previews on, which is the default. The package holds a PDF of the sheets that Apple rendered, and the tool above extracts it without converting anything.
02Why is the layout split across pages so oddly?
Because the split is the sender's print setup, saved into the file. A spreadsheet has no natural page boundaries, so Numbers uses whatever scale and page order was last set, and that travels with the document.
03Can I get the numbers back out as data?
Not from the PDF in any reliable way, and it is the wrong thing to ask for. If you need the figures rather than the layout, ask the sender to export CSV or Excel, which Numbers does in two clicks.
04Are all the sheets included?
Every sheet that the print setup includes. A sheet the sender excluded from printing is not in the render, so a document that looks short is usually complete as far as its author was concerned.
05Are hidden rows and columns in there?
No. The render shows the sheets as they would print, so anything hidden stays hidden. That is worth knowing if you are checking a figure that seems to be missing.
06What if there is no preview inside?
Then nothing outside Apple's software can read the spreadsheet, because the sheets are stored in Apple's private format. Ask the sender to export a PDF, or better, a CSV or Excel file.