FILTERXML function. Get data by specifying XPath in XML.(Microsoft Excel)


Japanese version.

This function is to get data for a string in XML format by specifying XPath.

It can also be used for HTML.

Often used in conjunction with the WEBSERVICE function to access WebAPI from Excel.

How it works

XMLRequired argument.XML string from which to extract.
XPathRequired argument.Xpath indicating the target data.


Sample XML and XPath and FILTERXML function results.

If XML or XPath is not parsable, a #VALUE! error will result.

Xpath rules vary widely, but at a minimum, the following rules should be used.

Specify the hierarchy of tags by starting with // and separating with /.

Use @ to specify tag attributes.


If you specify the argument "XPath" the cell range, it will be Spil.



Microsoft Excel Functions Web