AI · 1 min read

FILTERXML

FILTERXML function in Excel: Extracts data from XML via XPath.

Web function · Excel

FILTERXML function

Extracts data from XML via XPath.

Availability

PlatformStatus
ExcelListed
Google SheetsNot listed
On Google Sheets: use IMPORTXML. IMPORTXML reads from a URL, not from a text value.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.