JSON formatter New
Format, validate and minify JSON, and explore it in a collapsible tree with a filter for keys and values. Errors are shown by line and column.
JSONPath tester: query and filter JSON
Pick exactly the data you need from a JSON document. Write a JSONPath expression such as $.store.book[?(@.price < 10)].title and see the matches while you type.
Runs in your browser. Nothing is uploaded.
Loading the JSONPath tester…
How to use the JSONPath tester
-
Paste your JSON.
-
Write a JSONPath expression, or start from one of the examples.
-
Sort the results on a field if you like, then copy them as JSON.
Frequently asked questions
What is JSONPath?
A query language for JSON, like XPath for XML. $ is the document, .name selects a key, [0] an array item, [*] every item, .. searches at any depth, and [?(@.age > 30)] filters on a condition.
Which filter conditions are supported?
Comparisons with ==, !=, <, <=, > and >=, checks whether a key exists, and combinations with && and ||. Values can be numbers, strings in quotes, true, false and null.
Related tools
-
-
JSON to CSV converter New
Turn a JSON array into a table you can sort and filter, and download it as CSV for Excel or Google Sheets. Converts CSV back to JSON too.
-
JSON diff New
Compare two JSON documents and see every added, removed and changed value with its path. The order of keys does not matter. Runs locally.
-
JSON to TypeScript New
Generate TypeScript interfaces or types from a JSON example, with nested objects, arrays, optional keys and union types. Copy them in one click.