JSONPath Tester – Query & Filter JSON Online

Q: Can I export the query results?

Yes. The matches behave like normal output: copy or download them, or pick a Convert option such as CSV or YAML.

Q: Is my data uploaded to a server?

No. The JSONPath Tester runs entirely in your browser using JavaScript. Your data is never uploaded, logged or stored, and the tool keeps working offline after your first visit.

Input

Output

Ready

Ln 1, Col 1

Run JSONPath queries against your JSON

Type an expression starting with $ into the search box above the output. The result updates as you type and shows every matching value. The example query selects the names of all active users. Every conversion works on the matches, so you can export them as CSV, YAML or code.

How to use it

Paste your JSON into the Input panel.
Type a JSONPath expression starting with $ in the output search box.
Check the matches and the match count in the status bar, then copy, download or convert them.

Supported JSONPath syntax

$.store.book or $['store']['book']: child keys
$..price: recursive descent (any depth)
[*] and .*: all items or values
[0], [-1], [0,2], [1:3], [::2]: indexes and slices
[?(@.price < 10)], [?(@.tags)], [?(@.a == 'x' && @.b > 1)]: filters
[?(@.email =~ /@example\.com$/i)]: regular-expression filters

More JSON tools

All tools are free and run privately in your browser.

JSON FormatterBeautify, validate & convert JSON ValidatorFind errors by line and column JSON ViewerCollapsible tree with search JSON MinifierCompress JSON, see bytes saved JSON RepairFix broken JSON automatically JSONPath TesterQuery and filter JSON JSON EscapeStringify and unescape JSON JSON to YAMLReadable YAML for configs JSON to CSVArrays to spreadsheet rows JSON to XMLWell-formed XML output CSV to JSONSpreadsheets to JSON arrays JSON Schema GeneratorInfer a draft 2020-12 schema JSON to TypeScriptInterfaces with optional fields JSON to GoStructs with json tags JSON to JavaRecords with Jackson annotations JSON to KotlinData classes for kotlinx.serialization JSON to SwiftCodable structs with CodingKeys JSON to DartFlutter models with fromJson JSON to C#Classes for System.Text.Json JSON to C++Structs for nlohmann/json JSON to CTyped structs for C JSON to PHPReadonly DTO classes JSON to PythonDataclasses with type hints

JSONPath Tester FAQ

What is JSONPath?

JSONPath is a query language for JSON, similar to XPath for XML. An expression like $.users[*].email selects the email of every user. It is standardised as RFC 9535.

How do I filter an array in JSONPath?

Use a filter expression: $.items[?(@.price < 10)] returns items whose price is below 10. Combine conditions with && and ||.

Can I export the query results?

Yes. The matches behave like normal output: copy or download them, or pick a Convert option such as CSV or YAML.

Is my data uploaded to a server?

No. The JSONPath Tester runs entirely in your browser using JavaScript. Your data is never uploaded, logged or stored, and the tool keeps working offline after your first visit.