JSONPath
PARSEJSON
Extracts values from JSON strings or ranges using JSONPath-style paths.
Syntax
=PARSEJSON(json, path)Parameters
NameTypeDescription
Name
jsonTypetext or range
DescriptionJSON string or range containing JSON strings.
Name
pathTypetext
DescriptionPath to extract, such as "user.name", "items[0].price", or "[*].id".
Returns
A scalar value, JSON string for arrays/objects, spill result for ranges, blank for missing values, or #JSONERROR! for invalid JSON.
Example
=PARSEJSON(A1, "items[1].price")Result: 15
For JSON like {"items":[{"price":10},{"price":15}]}.
Notes
The root marker $ is optional.
Dot paths, array indexes, wildcards, recursive descent, slices, and filters are supported.
When a result is an object or array, PARSEJSON returns it as a JSON string so it fits in a cell.