Excel Function : FILTERXML

Download now!

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.