The FILTERXML function uses XPath to match and extract data from text in XML format.
In the example shown cell B5 contains XML data that describes 10 music albums.
For each album, there is information about the title, the artist, and the year.
Parse XML with formula
To parse XML with a formula, you can use the FILTERXML function. In the example shown, the formula in D5 is: =FILTERXML(B5,"//album/title") which returns the ten album titles in the XML. Note: FILTERXML is not available in Excel on the Mac, or in Excel Online.
