What is the NUMBERS file format?
Files with the .numbers extension contain ZIP-compressed packages comprising a spreadsheet: an index folder with binary IWA files (iWork Archive format, using Snappy-compressed Protocol Buffers), a metadata folder with PLIST files, and a graphic preview image for quick document thumbnails. .numbers files are stored in a proprietary format developed by Apple, used by the Numbers application - a program designed for creating spreadsheets. Numbers is a component of the iWork office suite, available on macOS since 2007 and for iPad since 2010.
A .numbers spreadsheet may include on its so-called canvas such elements as:
- Data tables
- Charts
- Graphics and images
- Text boxes
- Formulas and functions based on data ranges
.numbers spreadsheets differ from classic spreadsheets in their approach to data. They do not have to contain tables, and elements such as charts and images are not placed in fixed cells but positioned freely in the space of the document - the so-called canvas. Such files can be converted into spreadsheet formats used by other programs, but their appearance or functionality are usually not fully preserved.
Opening .numbers files outside Apple platforms
Files with the .numbers extension are not natively supported by the standard Windows equivalent - Microsoft Excel. To open a .numbers file on a Windows computer, you need to export it from Apple Numbers using File → Export To → Excel…, which produces an XLSX file. If you do not have access to Apple Numbers, you can use Numbers for iCloud, which runs in any modern web browser on Windows, Linux, and Android. LibreOffice Calc (version 7.4 and later) can also open .numbers files directly without an Apple account, providing a practical offline option. For maximum compatibility, Numbers on any platform can export data to CSV.
Security & safety
RISK: LOWNumbers documents are data files without a macro language (unlike Excel's XLSM), so they carry essentially no executable threat - a notable Apple design choice. Practical issues are privacy (spreadsheets often contain personal/financial data; uploading to iCloud or converter sites shares that data) and trust in third-party online 'numbers to excel' converters - prefer Apple's own iCloud export. A file that looks like a folder or ZIP is normal (macOS package form), not malware.
Format details
in a nutshellPrograms that open NUMBERS files
Technical details
deep spec| Container format | ZIP archive; any ZIP-capable tool can inspect the internal file tree |
| Internal data encoding | IWA (iWork Archive) - binary Protocol Buffers compressed with Google Snappy |
| MIME type | application/vnd.apple.numbers |
| Magic bytes | 50 4B 03 04 ("PK") at offset 0 - standard ZIP local file header; identified internally by Index/*.iwa entries |
| Internal package structure | Index/*.iwa (sheet data), metadata/*.plist (document properties), preview.jpg / preview-micro.jpg (thumbnails) |
| Layout model | Free-form canvas; tables, charts, and media objects float independently and are not anchored to a cell grid |
| Multi-sheet support | Multiple sheets per document, each with its own independent canvas and objects |
| Formula engine | Over 250 built-in functions with syntax broadly compatible with Excel; functions reference named ranges and table columns, not raw cell addresses |
| Chart types | Bar, column, line, area, pie, donut, scatter, bubble, 2-axis mixed, and interactive touch-driven charts |
| Password protection | AES-256 encryption applied to document contents within the ZIP package; set via File → Set Password in Numbers |
| Export formats | XLSX, PDF, CSV, TSV, ODS, and Numbers '09 (legacy) |
| Collaboration | Real-time co-editing via iCloud with participant presence indicators; changes sync across macOS, iOS, and browser |
| Template extension | Custom templates are saved as .nmbtemplate files, sharing the same ZIP/IWA internal structure |
| Native platforms | macOS (Numbers app), iOS and iPadOS (Numbers app), web browser via iCloud.com (Numbers for iCloud) |
| Third-party support | LibreOffice Calc 7.4+ can open .numbers files directly; older tools typically require an XLSX export first |
| Backward compatibility | Pre-Numbers 3.0 documents used an earlier package layout; current Numbers opens them but resaves in the IWA-based format |
| Released | 2007 (Numbers 1.0, iWork '08); current single-file IWA-based format since Numbers 3.0 (2013) |
| Specification | support.apple.com |
NUMBERS conversions
Community Q&A
asked by usersNo questions yet - be the first to ask about NUMBERS files.