Guide

Apple Numbers: The Complete Guide to .numbers Spreadsheet Format

PC By Pablo Cirre • Updated May 7, 2026

Apple Numbers: The Complete Guide to .numbers Spreadsheet Format

Apple Numbers is the spreadsheet application in Apple's iWork suite, positioned as the Mac and iOS alternative to Microsoft Excel. The .numbers file format it uses is as far from Excel's .xlsx as it can be — a completely proprietary package with its own data model, canvas-based layout philosophy, and tight integration with Apple's ecosystem. Understanding the format helps you work with Numbers files effectively across different platforms and convert them when Excel is the destination.

History and Philosophy

Numbers launched in 2007 as part of iWork '08, alongside Pages (word processor) and Keynote (presentations). Unlike Excel, which inherited the grid-first paradigm from VisiCalc and Lotus 1-2-3, Numbers was designed around a canvas model: instead of the spreadsheet being one giant grid, a Numbers document is a freeform canvas where you place multiple independent tables, charts, text boxes, and images wherever you want.

This philosophy has practical implications:

A single Numbers sheet can contain multiple tables at different positions
Tables don't have to start at cell A1
Charts and images float freely as objects, not tied to a specific cell range
The result is often visually polished but structurally different from Excel

The .numbers File Format

A .numbers file is not a simple binary or XML document — it is a ZIP archive. Rename any .numbers file to .zip, extract it, and you will find:

Document.numbers/
├── Index/
│   ├── Document.iwa        (main document structure)
│   ├── Tables/
│   │   ├── DataStore.iwa   (cell data)
│   │   └── ...
│   └── ...
├── preview.jpg             (thumbnail for Finder preview)
├── preview-micro.jpg       (smaller thumbnail)
└── buildVersionHistory.plist

The .iwa files use Snappy-compressed Protocol Buffers (Google's protobuf format). This is why .numbers files are not easily readable by generic XML parsers — the data is binary-encoded protobuf, not XML. Apple has published some schema information, but the format is largely reverse-engineered rather than officially documented for third parties.

This architecture means:

File sizes are generally smaller than Excel because protobuf is compact
Opening .numbers files in non-Apple software requires dedicated parsing libraries
The format has changed between iWork versions, breaking some older files

Features Unique to Numbers

Freeform Canvas

Numbers' signature feature: multiple tables on a free canvas, each independently sized and positioned. This makes Numbers excellent for financial dashboards, budget templates, and reports where visual presentation matters as much as data.

Smart Categories

Numbers can automatically group rows by a field value and show summary statistics (sum, average, count) for each group — similar to Excel's Subtotal or pivot table functionality but with a cleaner UI.

Formulas

Numbers uses the same formula language as Excel (SUM, VLOOKUP, IF, INDEX/MATCH, etc.) with minor syntax variations. Most Excel formulas work in Numbers without modification.

Templates

Numbers ships with over 30 built-in templates for budgets, invoices, schedules, and more — more polished than Excel's default templates.

Collaboration

Numbers documents stored in iCloud can be collaboratively edited in real-time from Mac, iPhone, iPad, and even Numbers for iCloud (browser-based) — similar to Google Sheets but within Apple's ecosystem.

Compatibility: The Fundamental Problem

The .numbers format's biggest weakness is compatibility:

Excel cannot open .numbers files directly — you must export to .xlsx first
Google Sheets cannot import .numbers files directly
LibreOffice does not support .numbers
Online converters can convert .numbers to .xlsx but may lose formatting

This lock-in is by design. Apple's strategy is to make Numbers documents look so good that users want to stay in the Apple ecosystem.

Converting .numbers to Excel (.xlsx)

Method 1: Numbers App on Mac (Best)

Open the file in Numbers
File → Export To → Excel
Choose format: .xlsx (recommended) or .xls (legacy)
Optional: check "Create a worksheet for each table" if your document has multiple tables on one canvas
Save the .xlsx file

What transfers well: cell data, basic formulas, number formatting, font styles, colors, charts (converted to static or embedded Excel charts).

What may be lost: custom table positioning (tables will stack vertically), complex image layouts, some advanced chart types, SmartCategories.

Method 2: Numbers for iCloud (No Mac Required)

Upload the .numbers file to icloud.com/numbers
Open it in Numbers for iCloud
Tools → Download a Copy → Excel

This works from any browser, including Windows and Linux, without any Apple software installed.

Method 3: Converting on iPhone/iPad

Numbers on iOS can export to Excel:

Open the file in Numbers
Tap the ... menu → Export → Excel
Share or save the .xlsx file

Converting Excel (.xlsx) to Numbers

Going the other direction is easier — Numbers can open .xlsx files directly:

Drag the .xlsx file onto the Numbers icon, or use File → Open
Numbers converts the file on import
Save as .numbers to preserve the Numbers format

What transfers well: cell data, formulas, basic formatting, charts. What changes: Excel's grid model maps to Numbers tables; complex Excel features (VBA macros, Power Query, conditional formatting with complex rules) are dropped or converted.

Numbers on Windows

Apple does not make Numbers for Windows. Your options:

Numbers for iCloud (icloud.com/numbers): browser-based, works on any OS, opens and edits .numbers files, exports to .xlsx
Convert .numbers to .xlsx first using Numbers on a Mac or iPhone
Third-party converters: several online services and desktop apps claim to convert .numbers files on Windows with varying fidelity

When to Use Numbers vs Excel

Scenario	Recommendation
Mac-only workflow, personal finance	Numbers — better looking, free
Sharing with Windows users	Excel — universal compatibility
Complex financial modeling	Excel — deeper formula library, Power Query
Visual dashboards and reports	Numbers — canvas layout excels here
Team collaboration (cross-platform)	Google Sheets — truly universal
iOS/iPhone use	Numbers — best native iOS spreadsheet

Apple Numbers is a capable spreadsheet application with a genuinely different design philosophy from Excel. Its .numbers format works beautifully within the Apple ecosystem but requires deliberate conversion steps whenever data needs to leave it. For Apple-centric workflows, the visual quality and iCloud collaboration make it worth learning; for cross-platform work, converting to .xlsx at the output stage is the practical choice.

Related conversions

Frequent conversions across the catalogue:

Frequently Asked Questions

Apple does not make Numbers for Windows, but you have options. The easiest is Numbers for iCloud (icloud.com/numbers) — a browser-based version that works on any OS and can open, edit, and export .numbers files to Excel. Alternatively, use an online converter to transform .numbers to .xlsx, then open the result in Excel. Note that some formatting may be lost in conversion, especially if the Numbers document uses multiple tables on a freeform canvas.

Apple does not make Numbers para Windows, mas you have options. The easiest is Numbers para iCloud (icloud.com/numbers) — um navegador-based version that funciona on any OS e can open, edit, e export .numbers arquivos to Excel. Alternatively, usar an online converter to transform .numbers to .xlsx, then abrir the result in Excel. Note that some formatoting may be lost in conversion, especially if the Numbers document uses multiple tables em um grátisform canvas.

Apple does not make Numbers für Windows, aber you have options. The easiest is Numbers für iCloud (icloud.com/numbers) — ein Browser-based version that works on any OS und can open, edit, und export .numbers Dateien to Excel. Alternatively, verwenden an online converter to transform .numbers to .xlsx, then öffnen the result in Excel. Note that some Formatting may be lost in conversion, especially if the Numbers document uses multiple tables auf einem kostenlosform canvas.

Apple does not make Numbers para Windows, pero you have options. The easiest is Numbers para iCloud (icloud.com/numbers) — un navegador-based version that works on any OS y can open, edit, y export .numbers archivos to Excel. Alternatively, usar an online converter to transform .numbers to .xlsx, then abrir the result in Excel. Note that some formatoting may be lost in conversion, especially if the Numbers document uses multiple tables en un gratisform canvas.

On KaijuConverter every file is processed inside an isolated container, encrypted in transit (TLS 1.3) and at rest, and automatically deleted after 60 minutes with multi-pass overwrite. We never train on, share, or analyze user content. For maximum privacy on extremely sensitive material, prefer offline tools (ImageMagick, FFmpeg, LibreOffice) that you control end-to-end.

On Mac: open in Numbers, then File → Export To → Excel → choose .xlsx. On iPhone/iPad: tap the ... menu in Numbers → Export → Excel. Without Apple hardware: upload the .numbers file to icloud.com/numbers, then Tools → Download a Copy → Excel. What converts well: cell data, basic formulas, number formatting, colors, and most chart types. What may be lost: custom table positioning (multiple tables stack vertically in Excel), complex image layouts, and Smart Categories.

On Mac: abrir in Numbers, then arquivo → Export To → Excel → choose .xlsx. no iPhone/iPad: tap the ... menu in Numbers → Export → Excel. sem Apple hardware: enviar the .numbers arquivo to icloud.com/numbers, then ferramentas → baixar a Copy → Excel. What converts well: cell data, basic formulas, number formatoting, colors, e most chart types. What may be lost: custom table positioning (multiple tables stack vertically in Excel), complexo image layouts, e Smart Categories.

On Mac: öffnen in Numbers, then Datei → Export To → Excel → choose .xlsx. auf iPhone/iPad: tap the ... menu in Numbers → Export → Excel. ohne Apple hardware: hochladen the .numbers Datei to icloud.com/numbers, then Werkzeuge → herunterladen a Copy → Excel. What converts well: cell data, basic formulas, number Formatting, colors, und most chart types. What may be lost: custom table positioning (multiple tables stack vertically in Excel), complex image layouts, und Smart Categories.

On Mac: abrir in Numbers, then archivo → Export To → Excel → choose .xlsx. en iPhone/iPad: tap the ... menu in Numbers → Export → Excel. sin Apple hardware: subir the .numbers archivo to icloud.com/numbers, then herramientas → descargar a Copy → Excel. What converts well: cell data, basic formulas, number formatoting, colors, y most chart types. What may be lost: custom table positioning (multiple tables stack vertically in Excel), complex image layouts, y Smart Categories.

For 95% of use cases, yes — server-side ImageMagick, FFmpeg and LibreOffice produce identical output to the same tools on your laptop. Desktop software wins for: extremely large files (multi-GB), batch jobs of thousands of files, scripted pipelines, or content too sensitive to upload. KaijuConverter caps at 25 MB per file on the free tier (up to 2 GB on paid plans).

No. Microsoft Excel cannot open .numbers files natively. You must first export the file from Numbers (on Mac, iPhone, or iCloud) as .xlsx, then open that Excel file. There is no third-party Excel plugin that adds native .numbers support. This is an intentional incompatibility — Apple keeps the .numbers format proprietary to maintain ecosystem lock-in.

No. Microsoft Excel cannot abrir .numbers arquivos natively. You must first export o arquivo de Numbers (on Mac, iPhone, ou iCloud) as .xlsx, then abrir that Excel file. Não há third-party Excel plugin that adds native .numbers support. This is an intentional incompatibility — Apple keeps the .numbers formato proprietary to maintain ecosystem lock-in.

No. Microsoft Excel cannot öffnen .numbers Dateien natively. You must first export die Datei von Numbers (on Mac, iPhone, oder iCloud) as .xlsx, then öffnen that Excel file. Es gibt kein third-party Excel plugin that adds native .numbers support. This is an intentional incompatibility — Apple keeps the .numbers Format proprietary to maintain ecosystem lock-in.

No. Microsoft Excel cannot abrir .numbers archivos natively. You must first export el archivo de Numbers (on Mac, iPhone, o iCloud) as .xlsx, then abrir that Excel file. No hay third-party Excel plugin that adds native .numbers support. This is an intentional incompatibility — Apple keeps the .numbers formato proprietary to maintain ecosystem lock-in.

Most format conversions are lossy by design — JPG, MP3, MP4, WebP all discard perceptual data to save bytes. Going through a lossy intermediate compounds the loss. To minimize visible/audible drift: convert from the original master, choose a higher quality setting, and avoid converting back and forth between lossy formats.

A .numbers file is a ZIP archive. Rename it to .zip and extract it to see the contents: an Index/ folder containing .iwa files (Snappy-compressed Protocol Buffer binary data — not XML), plus JPEG thumbnail previews for Finder. The protobuf-based format is compact and fast but is not openly documented, which is why third-party .numbers parsing is difficult. The format has also changed between iWork versions, so very old .numbers files may not open correctly in modern Numbers.

A .numbers Datei is a ZIP archive. Rename it to .zip und extract it to see the contents: an Index/ folder containing .iwa Dateien (Snappy-compressed Protocol Buffer binary data — not XML), plus JPEG thumbnail previews für Finder. The protobuf-based Format is compact und fast aber is not openly documented, which is why third-party .numbers parsing is schwierig. The Format has also changed between iWork versions, so very old .numbers Dateien may not öffnen correctly in modern Numbers.

A .numbers archivo is a ZIP archive. Rename it to .zip y extract it to see the contents: an Index/ folder containing .iwa archivos (Snappy-compressed Protocol Buffer binary data — not XML), plus JPEG thumbnail previews para Finder. The protobuf-based formato is compact y fast pero is not openly documented, which is why third-party .numbers parsing is difícil. The formato has also changed between iWork versions, so very old .numbers archivos may not abrir correctly in moderno Numbers.

Yes — KaijuConverter accepts multiple files in a single drop and returns a ZIP. For very large batches (thousands of files) consider command-line tools or our API: <code>find . -name "*.heic" -exec magick {} {.}.jpg \;</code> or similar one-liners scale to millions of files when run locally.