Excel Function : FILTERXML
Category
Web
Description
Returns specific data from the XML content by using the specified XPath
Microsoft Excel Reference Page
https://support.office.com/en-us/article/FILTERXML-function-4df72efc-11ec-4951-86f5-c1374812f5b7
Syntax and Description of the FILTERXML Excel Function
to parse an XML string and return the value
About FILTERXML Excel Function
FILTERXML(xml, xpath) returns the results of applying an XPath expression to an XML document, and can be used to extract data from XML content that is embedded in a worksheet.