# FILTERXML

web · from excel · excel: differs in detail · no sheets equivalent

selects values from an xml STRING with an xpath

## signature

```
FILTERXML(xml, xpath)
```

returns: `array`

## arguments

- xml: text — required
- xpath: text — required

## examples

formula and result, asserted in the engine test suite.

| formula | result | with |
| --- | --- | --- |
| `=FILTERXML("<r><t>alpha</t></r>", "//t")` | `alpha` | — |

## errors

error values observed from the engine — each with a call that produces it.

| error | produced by |
| --- | --- |
| `#VALUE!` | `=FILTERXML(2, 2)` |

## related

- [DECODEURL](https://deepcalc.com/functions/decodeurl.md) — decodes URL-encoded text
- [ENCODEURL](https://deepcalc.com/functions/encodeurl.md) — encodes text for use in URLs using percent encoding
- [QUERY](https://deepcalc.com/functions/query.md) — runs SQL-like query on data range

## navigate

- [all web functions](https://deepcalc.com/functions/web-functions.md)
- [function index](https://deepcalc.com/functions.md) — all 600 functions
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)
- [everything in one file](https://deepcalc.com/llms-full.txt)

source: https://deepcalc.com/functions/filterxml