How do I extract annotation IDs in an XSD file using Excel formula?

Hi,

Possible way is to use Power Query which has connector to XML files. First step is to generate XML schema for your XSD file, e.g. here http://xmlgrid.net/genXml.html

I tried with your file, but received parser error, thus modified it a bit manually

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<xsd:annotation id="disney">
<xsd:documentation>This is the Disney.</xsd:documentation>
</xsd:annotation>

<xsd:annotation id="disney.mickeyFamily">
<xsd:documentation>This is the Mickey Family.</xsd:documentation>
<xsd:attribute name="version" use="required"/>
</xsd:annotation>


<xsd:annotation id="disney.mickeyFamily.mickeyMouse">
<xsd:documentation>This is the Mickey Mouse.</xsd:documentation>
<xsd:attribute name="version" use="required"/>
</xsd:annotation>

</xsd:schema>

I'm not a specialist in XSD and XML and not sure how exactly that shall be.

After that query above XML file and Power Query in couple of steps

let
    Source = Xml.Tables(File.Contents("C:\Tests\test.xsd"), null, 1252),
    RemoveUnused = Table.SelectColumns(Source,{"Table"}),
    ExpandTable = Table.ExpandTableColumn(RemoveUnused, "Table", {"Attribute:id","documentation"}, {"Annotation ID", "Documentation"})
in
    ExpandTable

generates result like this