XLSX
Dan Tobias (Talk | contribs) (→Incompatibility with earlier versions) |
Dan Tobias (Talk | contribs) |
||
| (16 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
|formattype=electronic | |formattype=electronic | ||
|subcat=Document | |subcat=Document | ||
| + | |subcat2=Spreadsheet | ||
|extensions={{ext|xlsx}} | |extensions={{ext|xlsx}} | ||
| + | |mimetypes={{mimetype|application/vnd.openxmlformats-officedocument.spreadsheetml.sheet}} | ||
| + | |pronom={{PRONOM|fmt/214}} | ||
| + | |wikidata={{wikidata|Q63082925}} | ||
}} | }} | ||
| + | [[Office Open XML]] Spreadsheet ('''.XLSX''') is the default file format for documents used by [[Microsoft Excel]] as of Excel 2007. In prior versions, the default version was [[XLS]]. | ||
| − | + | This format (or the XML components of it) has been referred to as [[SpreadsheetML]], a name also used for the standalone XML files the earlier Excel 2003 was able to generate. | |
| + | |||
| + | Graphical inserted elements may be stored in the form of [[DrawingML]], embedded in the XML. | ||
== History == | == History == | ||
| Line 14: | Line 21: | ||
Attempting to open XLSX files with earlier versions of Excel (pre-2007) results in garbage instead of a proper spreadsheet. A [http://www.microsoft.com/en-us/download/details.aspx?id=3 compatibility pack] supposedly adds the ability to load the newer format into the older versions, but this doesn't necessarily work well in all cases. This can be a problem when people insist on e-mailing you files in the newest proprietary Microsoft formats when, most of the time, whatever they're sending could have been done fine in an entirely nonproprietary keep-it-simple-stupid format such as [[CSV]] or [[TXT|plain text]]. [http://www.openoffice.org/download/ Open Office] can open XLSX files, however. | Attempting to open XLSX files with earlier versions of Excel (pre-2007) results in garbage instead of a proper spreadsheet. A [http://www.microsoft.com/en-us/download/details.aspx?id=3 compatibility pack] supposedly adds the ability to load the newer format into the older versions, but this doesn't necessarily work well in all cases. This can be a problem when people insist on e-mailing you files in the newest proprietary Microsoft formats when, most of the time, whatever they're sending could have been done fine in an entirely nonproprietary keep-it-simple-stupid format such as [[CSV]] or [[TXT|plain text]]. [http://www.openoffice.org/download/ Open Office] can open XLSX files, however. | ||
| + | |||
| + | This form of XML-based spreadsheet is also different from the (also XML-based) [[SpreadsheetML]] available as a save option in earlier Excel versions, though this sort of file can still be read and written by current Excel versions. | ||
== Format == | == Format == | ||
| Line 19: | Line 28: | ||
Like the other "Open XML" formats, this file format actually consists of various files (mostly [[XML]]) compressed into a [[ZIP]] archive, with this fact obscured from the end user by the use of a different file extension. | Like the other "Open XML" formats, this file format actually consists of various files (mostly [[XML]]) compressed into a [[ZIP]] archive, with this fact obscured from the end user by the use of a different file extension. | ||
| − | == | + | == Software == |
| + | * [https://pypi.python.org/pypi/Python-OOXML/0.12 Python library for parsing Office Open XML files] | ||
| + | |||
| + | == Links and references == | ||
* [http://www.ecma-international.org/publications/standards/Ecma-376.htm ECMA-376 specification ] | * [http://www.ecma-international.org/publications/standards/Ecma-376.htm ECMA-376 specification ] | ||
* [http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html ISO/IEC 29500 specification] | * [http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html ISO/IEC 29500 specification] | ||
* [http://support.microsoft.com/kb/924074 How to open new file formats in earlier versions of Microsoft Office] | * [http://support.microsoft.com/kb/924074 How to open new file formats in earlier versions of Microsoft Office] | ||
| + | * [http://boingboing.net/2013/09/20/implementing-a-turing-machine.html Implementing a Turing machine in Excel] | ||
| + | * [http://www.digitalpreservation.gov/formats/fdd/fdd000395.shtml?loclr=blogsig OOXML Format Family -- ISO/IEC 29500 and ECMA 376 (Library of Congress)] | ||
| + | * [http://www.digitalpreservation.gov/formats/fdd/fdd000398.shtml?loclr=blogsig XLSX Transitional (Office Open XML), Library of Congress] | ||
| + | * [http://www.digitalpreservation.gov/formats/fdd/fdd000401.shtml?loclr=blogsig XLSX Strict (Office Open XML), Library of Congress] | ||
| + | * [http://www.digitalpreservation.gov/formats/fdd/fdd000396.shtml?loclr=blogsig Markup Compatibility and Extensibility (Office Open XML), Library of Congress] | ||
| + | * [https://bitwizards.com/blog/november-2010/how-to-export-an-excel-2010-worksheet-to-xml How To Export an Excel 2010 Worksheet to XML] | ||
[[Category:XML based file formats]] | [[Category:XML based file formats]] | ||
| + | [[Category:ZIP based file formats]] | ||
| + | [[Category:Microsoft]] | ||
Latest revision as of 00:27, 2 June 2019
Office Open XML Spreadsheet (.XLSX) is the default file format for documents used by Microsoft Excel as of Excel 2007. In prior versions, the default version was XLS.
This format (or the XML components of it) has been referred to as SpreadsheetML, a name also used for the standalone XML files the earlier Excel 2003 was able to generate.
Graphical inserted elements may be stored in the form of DrawingML, embedded in the XML.
Contents |
[edit] History
This (along with the other Office Open XML items DOCX and PPTX) was initially standardized as ECMA-376 in 2006. Three formats of this standard have been produced; the second version also corresponds to ISO/IEC 29500.
[edit] Incompatibility with earlier versions
Attempting to open XLSX files with earlier versions of Excel (pre-2007) results in garbage instead of a proper spreadsheet. A compatibility pack supposedly adds the ability to load the newer format into the older versions, but this doesn't necessarily work well in all cases. This can be a problem when people insist on e-mailing you files in the newest proprietary Microsoft formats when, most of the time, whatever they're sending could have been done fine in an entirely nonproprietary keep-it-simple-stupid format such as CSV or plain text. Open Office can open XLSX files, however.
This form of XML-based spreadsheet is also different from the (also XML-based) SpreadsheetML available as a save option in earlier Excel versions, though this sort of file can still be read and written by current Excel versions.
[edit] Format
Like the other "Open XML" formats, this file format actually consists of various files (mostly XML) compressed into a ZIP archive, with this fact obscured from the end user by the use of a different file extension.
[edit] Software
[edit] Links and references
- ECMA-376 specification
- ISO/IEC 29500 specification
- How to open new file formats in earlier versions of Microsoft Office
- Implementing a Turing machine in Excel
- OOXML Format Family -- ISO/IEC 29500 and ECMA 376 (Library of Congress)
- XLSX Transitional (Office Open XML), Library of Congress
- XLSX Strict (Office Open XML), Library of Congress
- Markup Compatibility and Extensibility (Office Open XML), Library of Congress
- How To Export an Excel 2010 Worksheet to XML
