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

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