Issue: Unsupported XML schema constructs

Excel supports importing and exporting XML data through a number of XML schema constructs. However, there are some XML schema constructs that Excel does not support. The following list details the XML schema constructs that cannot be imported into Excel:

  • <any>    These elements allow you to include elements that are not declared by the schema.

  • <anyAttribute>    These elements allow you to include attributes that are not declared by the schema.

  • Recursive structures    These structures are used to create a hierarchy of data, such as the management structure in an organization, in which the same XML elements are nested several levels. Recursive structures cannot be nested more than one level deep.

  • Abstract elements    These elements are meant to be declared in the schema, but never used as elements. Abstract elements depend on other elements being substituted for the abstract element.

  • Substitution groups     These groups allow an element to be swapped wherever another element is referenced. An element indicates that it is a member of another element's substitution group through the <substitutionGroup> attribute.

  • Mixed content This content occurs when an element contains a child element and simple text outside of a child element. One common case is where formatting tags (such as the bold tags) are being used to mark up data within an element.

For more information, see Connect to an XML file (Power Query).

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×