Numbers

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
 
(6 intermediate revisions by 4 users not shown)
Line 7: Line 7:
 
|released=2005
 
|released=2005
 
}}
 
}}
 +
:''This article is about the spreadsheet format. For number formats, see [[:Category:Number formats]].''
 +
 
'''Numbers''' is part of [[iWork]], an Apple application suite available as apps for OS-X and iOS as well as in a cloud-based version on iCloud. It is a spreadsheet program.
 
'''Numbers''' is part of [[iWork]], an Apple application suite available as apps for OS-X and iOS as well as in a cloud-based version on iCloud. It is a spreadsheet program.
  
The web-based cloud version can be run in a browser (Not all browsers are fully supported; when you try it in Firefox, it says that it is an unsupported browser, but seems to work anyway, though it is possible some features aren't fully functional), and is free for iCloud users. The app version is paid, though apparently it comes free with newly-purchased iOS devices since late 2013; it will sync automatically with iCloud to access cloud-stored documents.
+
The web-based cloud version can be run in a browser (Not all browsers are fully supported; when you try it in Firefox, it says that it is an unsupported browser, but seems to work anyway, though it is possible some features aren't fully functional), and is free for iCloud users. The app is currently free across all Apple devices. it will sync automatically with iCloud to access cloud-stored documents.
  
 
The current version can load and save the corresponding Microsoft Excel [[XLS]] file type (using, apparently, the 2003 file version). It can also save as [[PDF]], producing a static document that can be useful for viewing, but not so much for editing or import into other software. And then there is the native iWork format, bearing a .numbers extension, or a double extension .numbers.zip when saved in a [[ZIP]] file.
 
The current version can load and save the corresponding Microsoft Excel [[XLS]] file type (using, apparently, the 2003 file version). It can also save as [[PDF]], producing a static document that can be useful for viewing, but not so much for editing or import into other software. And then there is the native iWork format, bearing a .numbers extension, or a double extension .numbers.zip when saved in a [[ZIP]] file.
Line 20: Line 22:
  
 
Numbers (2013) files include <code>DocumentStylesheet.iwa</code>, <code>ThemeStylesheet.iwa</code>, <code>Document.iwa</code>, <code>Metadata.iwa</code>, <code>CalculationEngine.iwa</code>, and <code>AnnotationAuthorStorage.iwa</code>. The <code>Tables</code> subdirectory has <code>DataList.iwa</code> and a series of numbered files like <code>DataList-1.iwa</code>, <code>DataList-2.iwa</code>, and so on. There is also <code>HeaderStorageBucket.iwa</code>, <code>HeaderStorageBucket-1.iwa</code>, etc., and <code>Tile-iwa</code>, <code>Tile-1.iwa</code>, etc.
 
Numbers (2013) files include <code>DocumentStylesheet.iwa</code>, <code>ThemeStylesheet.iwa</code>, <code>Document.iwa</code>, <code>Metadata.iwa</code>, <code>CalculationEngine.iwa</code>, and <code>AnnotationAuthorStorage.iwa</code>. The <code>Tables</code> subdirectory has <code>DataList.iwa</code> and a series of numbered files like <code>DataList-1.iwa</code>, <code>DataList-2.iwa</code>, and so on. There is also <code>HeaderStorageBucket.iwa</code>, <code>HeaderStorageBucket-1.iwa</code>, etc., and <code>Tile-iwa</code>, <code>Tile-1.iwa</code>, etc.
 +
 +
===Compatibility===
 +
 +
* Numbers version 2.6 released on Oct 15, 2015 added compatibility with Numbers ’08 documents
  
 
== See also ==
 
== See also ==
Line 26: Line 32:
  
 
== Sample files ==
 
== Sample files ==
* [http://www.dan.info/sampledata/iwork/TestSpreadsheet.numbers.zip TestSpreadsheet.numbers.zip]
+
* [https://www.dan.info/sampledata/iwork/TestSpreadsheet.numbers.zip TestSpreadsheet.numbers.zip]
  
 
== Links ==
 
== Links ==
 
* [[Wikipedia:Numbers (spreadsheet)|Wikipedia article]]
 
* [[Wikipedia:Numbers (spreadsheet)|Wikipedia article]]
 +
* [https://apps.apple.com/us/app/numbers/id409203825?mt=12 Mac App Store Download & Version History]
 
* [http://apple.stackexchange.com/questions/142356/why-does-numbers-hide-a-huge-png-file-in-exported-excel-sheets Why does Numbers hide a huge PNG file in exported Excel sheets?]
 
* [http://apple.stackexchange.com/questions/142356/why-does-numbers-hide-a-huge-png-file-in-exported-excel-sheets Why does Numbers hide a huge PNG file in exported Excel sheets?]
  
 
[[Category:Apple]]
 
[[Category:Apple]]
 +
[[Category:Apple bundle files]]
 +
[[Category:ZIP based file formats]]

Latest revision as of 16:12, 16 May 2023

File Format
Name Numbers
Ontology
Extension(s) .numbers, .numbers.zip
PRONOM fmt/825
Released 2005
This article is about the spreadsheet format. For number formats, see Category:Number formats.

Numbers is part of iWork, an Apple application suite available as apps for OS-X and iOS as well as in a cloud-based version on iCloud. It is a spreadsheet program.

The web-based cloud version can be run in a browser (Not all browsers are fully supported; when you try it in Firefox, it says that it is an unsupported browser, but seems to work anyway, though it is possible some features aren't fully functional), and is free for iCloud users. The app is currently free across all Apple devices. it will sync automatically with iCloud to access cloud-stored documents.

The current version can load and save the corresponding Microsoft Excel XLS file type (using, apparently, the 2003 file version). It can also save as PDF, producing a static document that can be useful for viewing, but not so much for editing or import into other software. And then there is the native iWork format, bearing a .numbers extension, or a double extension .numbers.zip when saved in a ZIP file.

iWork files, when saved under Mac OS-X, are in a bundle format that is actually a directory/folder. Saved in other systems, or exported as e-mail attachments, they are ZIPped and use the double extension as noted above.

Contents

[edit] File format info

The basic file format is consistent across the iWork suite, and is documented more fully in the iWork article. In the 2013 version of the format, the different apps mostly differ in what IWA files are stored in the Index.zip file (a ZIP within the bundle).

Numbers (2013) files include DocumentStylesheet.iwa, ThemeStylesheet.iwa, Document.iwa, Metadata.iwa, CalculationEngine.iwa, and AnnotationAuthorStorage.iwa. The Tables subdirectory has DataList.iwa and a series of numbered files like DataList-1.iwa, DataList-2.iwa, and so on. There is also HeaderStorageBucket.iwa, HeaderStorageBucket-1.iwa, etc., and Tile-iwa, Tile-1.iwa, etc.

[edit] Compatibility

  • Numbers version 2.6 released on Oct 15, 2015 added compatibility with Numbers ’08 documents

[edit] See also

[edit] Sample files

[edit] Links

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox