XLSX

From Just Solve the File Format Problem
Revision as of 22:56, 31 May 2016 by Dan Tobias (Talk | contribs)

Jump to: navigation, search
File Format
Name XLSX
Ontology
Extension(s) .xlsx
MIME Type(s) application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

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.

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.

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.

Software

Links and references

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox