Microsoft Office XML formats

Last updated
WordProcessingML
Filename extension .XML (XML document)
Developed by Microsoft
Type of format Document file format
Extended from XML, DOC
DataDiagramingML
Filename extension .VDX (XML Drawing),
.VSX (XML Stencil),
.VTX (XML Template)
Developed by Microsoft
Type of format Diagramming vector graphics
Extended from XML, VSD, VSS, VST
SpreadsheetML
Filename extension .XML (XML Spreadsheet)
Developed by Microsoft
Type of format Spreadsheet
Extended from XML, XLS

The Microsoft Office XML formats are XML-based document formats (or XML schemas) introduced in versions of Microsoft Office prior to Office 2007. Microsoft Office XP introduced a new XML format for storing Excel spreadsheets and Office 2003 added an XML-based format for Word documents.

Contents

These formats were succeeded by Office Open XML (ECMA-376) in Microsoft Office 2007.

File formats

Limitations and differences with Office Open XML

Besides differences in the schema, there are several other differences between the earlier Office XML schema formats and Office Open XML.

Word XML format example

<?xml version="1.0" encoding="utf-8" standalone="yes"?><?mso-application progid="Word.Document"?><w:wordDocumentxmlns:w="http://schemas.microsoft.com/office/word/2003/wordml"xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint"xmlns:o="urn:schemas-microsoft-com:office:office"w:macrosPresent="no"w:embeddedObjPresent="no"w:ocxPresent="no"xml:space="preserve"><o:DocumentProperties><o:Title>Thisisthetitle</o:Title><o:Author>DarlMcBride</o:Author><o:LastAuthor>BillGates</o:LastAuthor><o:Revision>1</o:Revision><o:TotalTime>0</o:TotalTime><o:Created>2007-03-15T23:05:00Z</o:Created><o:LastSaved>2007-03-15T23:05:00Z</o:LastSaved><o:Pages>1</o:Pages><o:Words>6</o:Words><o:Characters>40</o:Characters><o:Company>SCOGroup,Inc.</o:Company><o:Lines>1</o:Lines><o:Paragraphs>1</o:Paragraphs><o:CharactersWithSpaces>45</o:CharactersWithSpaces><o:Version>11.6359</o:Version></o:DocumentProperties><w:fonts><w:defaultFontsw:ascii="Times New Roman"w:fareast="Times New Roman"w:h-ansi="Times New Roman"w:cs="Times New Roman"/></w:fonts><w:styles><w:versionOfBuiltInStylenamesw:val="4"/><w:latentStylesw:defLockedState="off"w:latentStyleCount="156"/><w:stylew:type="paragraph"w:default="on"w:styleId="Normal"><w:namew:val="Normal"/><w:rPr><wx:fontwx:val="Times New Roman"/><w:szw:val="24"/><w:sz-csw:val="24"/><w:langw:val="EN-US"w:fareast="EN-US"w:bidi="AR-SA"/></w:rPr></w:style><w:stylew:type="paragraph"w:styleId="Heading1"><w:namew:val="heading 1"/><wx:uiNamewx:val="Heading 1"/><w:basedOnw:val="Normal"/><w:nextw:val="Normal"/><w:rsidw:val="00D93B94"/><w:pPr><w:pStylew:val="Heading1"/><w:keepNext/><w:spacingw:before="240"w:after="60"/><w:outlineLvlw:val="0"/></w:pPr><w:rPr><w:rFontsw:ascii="Arial"w:h-ansi="Arial"w:cs="Arial"/><wx:fontwx:val="Arial"/><w:b/><w:b-cs/><w:kernw:val="32"/><w:szw:val="32"/><w:sz-csw:val="32"/></w:rPr></w:style><w:stylew:type="character"w:default="on"w:styleId="DefaultParagraphFont"><w:namew:val="Default Paragraph Font"/><w:semiHidden/></w:style><w:stylew:type="table"w:default="on"w:styleId="TableNormal"><w:namew:val="Normal Table"/><wx:uiNamewx:val="Table Normal"/><w:semiHidden/><w:rPr><wx:fontwx:val="Times New Roman"/></w:rPr><w:tblPr><w:tblIndw:w="0"w:type="dxa"/><w:tblCellMar><w:topw:w="0"w:type="dxa"/><w:leftw:w="108"w:type="dxa"/><w:bottomw:w="0"w:type="dxa"/><w:rightw:w="108"w:type="dxa"/></w:tblCellMar></w:tblPr></w:style><w:stylew:type="list"w:default="on"w:styleId="NoList"><w:namew:val="No List"/><w:semiHidden/></w:style></w:styles><w:docPr><w:vieww:val="print"/><w:zoomw:percent="100"/><w:doNotEmbedSystemFonts/><w:proofStatew:spelling="clean"w:grammar="clean"/><w:attachedTemplatew:val=""/><w:defaultTabStopw:val="720"/><w:punctuationKerning/><w:characterSpacingControlw:val="DontCompress"/><w:optimizeForBrowser/><w:validateAgainstSchema/><w:saveInvalidXMLw:val="off"/><w:ignoreMixedContentw:val="off"/><w:alwaysShowPlaceholderTextw:val="off"/><w:compat><w:breakWrappedTables/><w:snapToGridInCell/><w:wrapTextWithPunct/><w:useAsianBreakRules/><w:dontGrowAutofit/></w:compat></w:docPr><w:body><wx:sect><w:p><w:r><w:t>Thisisthefirstparagraph</w:t></w:r></w:p><wx:sub-section><w:p><w:pPr><w:pStylew:val="Heading1"/></w:pPr><w:r><w:t>Thisisaheading</w:t></w:r></w:p><w:sectPr><w:pgSzw:w="12240"w:h="15840"/><w:pgMarw:top="1440"w:right="1800"w:bottom="1440"w:left="1800"w:header="720"w:footer="720"w:gutter="0"/><w:colsw:space="720"/><w:docGridw:line-pitch="360"/></w:sectPr></wx:sub-section></wx:sect></w:body></w:wordDocument>

Excel XML spreadsheet example

<?xml version="1.0" encoding="UTF-8"?><?mso-application progid="Excel.Sheet"?><Workbookxmlns="urn:schemas-microsoft-com:office:spreadsheet"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"xmlns:html="https://www.w3.org/TR/html401/"><Worksheetss:Name="CognaLearn+Intedashboard"><Table><Columnss:Index="1"ss:AutoFitWidth="0"ss:Width="110"/><Row><Cell><Datass:Type="String">ID</Data></Cell><Cell><Datass:Type="String">Project</Data></Cell><Cell><Datass:Type="String">Reporter</Data></Cell><Cell><Datass:Type="String">Assigned To</Data></Cell><Cell><Datass:Type="String">Priority</Data></Cell><Cell><Datass:Type="String">Severity</Data></Cell><Cell><Datass:Type="String">Reproducibility</Data></Cell><Cell><Datass:Type="String">Product Version</Data></Cell><Cell><Datass:Type="String">Category</Data></Cell><Cell><Datass:Type="String">Date Submitted</Data></Cell><Cell><Datass:Type="String">OS</Data></Cell><Cell><Datass:Type="String">OS Version</Data></Cell><Cell><Datass:Type="String">Platform</Data></Cell><Cell><Datass:Type="String">View Status</Data></Cell><Cell><Datass:Type="String">Updated</Data></Cell><Cell><Datass:Type="String">Summary</Data></Cell><Cell><Datass:Type="String">Status</Data></Cell><Cell><Datass:Type="String">Resolution</Data></Cell><Cell><Datass:Type="String">Fixed in Version</Data></Cell></Row><Row><Cell><Datass:Type="Number">0000033</Data></Cell><Cell><Datass:Type="String">CognaLearn Intedashboard</Data></Cell><Cell><Datass:Type="String">janardhana.l</Data></Cell><Cell><Datass:Type="String"></Data></Cell><Cell><Datass:Type="String">normal</Data></Cell><Cell><Datass:Type="String">text</Data></Cell><Cell><Datass:Type="String">always</Data></Cell><Cell><Datass:Type="String"></Data></Cell><Cell><Datass:Type="String">GUI</Data></Cell><Cell><Datass:Type="String">2016-10-14</Data></Cell><Cell><Datass:Type="String"></Data></Cell><Cell><Datass:Type="String"></Data></Cell><Cell><Datass:Type="String"></Data></Cell><Cell><Datass:Type="String">public</Data></Cell><Cell><Datass:Type="String">2016-10-14</Data></Cell><Cell><Datass:Type="String">IE8 browser_Modules screen tool tip text is shown twice</Data></Cell><Cell><Datass:Type="String">new</Data></Cell><Cell><Datass:Type="String">open</Data></Cell><Cell><Datass:Type="String"></Data></Cell></Row></Table></Worksheet></Workbook>

See also

Related Research Articles

<span class="mw-page-title-main">Microsoft Excel</span> Spreadsheet editor, part of Microsoft 365

Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 suite of software.

<span class="mw-page-title-main">Geography Markup Language</span> XML grammar for geographical features

The Geography Markup Language (GML) is the XML grammar defined by the Open Geospatial Consortium (OGC) to express geographical features. GML serves as a modeling language for geographic systems as well as an open interchange format for geographic transactions on the Internet. Key to GML's utility is its ability to integrate all forms of geographic information, including not only conventional "vector" or discrete objects, but coverages and sensor data.

Vector Markup Language (VML) is an obsolete XML-based file format for two-dimensional vector graphics. It was specified in Part 4 of the Office Open XML standards ISO/IEC 29500 and ECMA-376. According to the specification, VML is a deprecated format included in Office Open XML for legacy reasons only.

The Open Document Format for Office Applications (ODF), also known as OpenDocument, standardized as ISO 26300, is an open file format for word processing documents, spreadsheets, presentations and graphics and using ZIP-compressed XML files. It was developed with the aim of providing an open, XML-based file format specification for office applications.

<span class="mw-page-title-main">NeoOffice</span> macOS office suite

NeoOffice was an office suite for the macOS operating system developed by Planamesa Inc. It was a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program, and graphics program. It added some features not present in the macOS versions of LibreOffice and Apache OpenOffice. The last few versions were based on LibreOffice 4.4, which was released mid-2014.

<span class="mw-page-title-main">XBRL</span> Exchange format for business information

XBRL is a freely available and global framework for exchanging business information. XBRL allows the expression of semantics commonly required in business reporting. The standard was originally based on XML, but now additionally supports reports in JSON and CSV formats, as well as the original XML-based syntax. XBRL is also increasingly used in its Inline XBRL variant, which embeds XBRL tags into an HTML document. One common use of XBRL is the exchange of financial information, such as in a company's annual financial report. The XBRL standard is developed and published by XBRL International, Inc. (XII).

SpreadsheetML is the XML schema for Microsoft Office Excel 2003.

The Extensible Metadata Platform (XMP) is an ISO standard, originally created by Adobe Systems Inc., for the creation, processing and interchange of standardized and custom metadata for digital documents and data sets.

<span class="mw-page-title-main">Microsoft Office 2007</span> Version of Microsoft Office

Microsoft Office 2007 is an office suite for Windows, developed and published by Microsoft. It was officially revealed on March 9, 2006 and was the 12th version of Microsoft Office. It was released to manufacturing on November 3, 2006; it was subsequently made available to volume license customers on November 30, 2006, and later to retail on January 30, 2007, shortly after the completion of Windows Vista. The ninth major release of Office for Windows, Office 2007 was preceded by Office 2003 and succeeded by Office 2010. The Mac OS X equivalent, Microsoft Office 2008 for Mac, was released on January 15, 2008.

Office Open XML is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version as ECMA-376. ISO and IEC standardized later versions as ISO/IEC 29500.

This article describes the technical specifications of the OpenDocument office document standard, as developed by the OASIS industry consortium. A variety of organizations developed the standard publicly and make it publicly accessible, meaning it can be implemented by anyone without restriction. The OpenDocument format aims to provide an open alternative to proprietary document formats.

The Office Open XML file formats are a set of file formats that can be used to represent electronic office documents. There are formats for word processing documents, spreadsheets and presentations as well as specific formats for material such as mathematical formulas, graphics, bibliographies etc.

<span class="mw-page-title-main">FarPoint Spread</span> Computer software

FarPoint Spread is a suite of Microsoft Excel-compatible spreadsheet components available for .NET, COM, and Microsoft BizTalk Server. Software developers use the components to embed Microsoft Excel-compatible spreadsheet features into their applications, such as importing and exporting Microsoft Excel files, displaying, modifying, analyzing, and visualizing data. Spread components handle spreadsheet data at the cell, row, column, or worksheet level.

In computing, Open Data Protocol (OData) is an open protocol that allows the creation and consumption of queryable and interoperable Web service APIs in a standard way. Microsoft initiated OData in 2007. Versions 1.0, 2.0, and 3.0 are released under the Microsoft Open Specification Promise. Version 4.0 was standardized at OASIS, with a release in March 2014. In April 2015 OASIS submitted OData v4 and OData JSON Format v4 to ISO/IEC JTC 1 for approval as an international standard. In December 2016, ISO/IEC published OData 4.0 Core as ISO/IEC 20802-1:2016 and the OData JSON Format as ISO/IEC 20802-2:2016.

Directed Graph Markup Language (DGML) is an XML-based file format for directed graphs.

Data Format Description Language is a modeling language for describing general text and binary data in a standard way. It was published as an Open Grid Forum Recommendation in February 2021, and in April 2024 was published as an ISO standard.

References

  1. "Features and limitations of XML Spreadsheet format (broken)". Archived from the original on 2007-10-09. Retrieved 2007-11-01.
  2. "Polar WordML add-in (broken)". Archived from the original on 2009-04-11. Retrieved 2007-11-01.
  3. Word 2003 XML Viewer