Filter & Query JSON Data
Extract data from JSON using JMESPath expressions. Filter arrays, map objects, reshape data structures. Live expression tester with instant results.
Query JSON (JMESPath)
📁 Drag and drop a .json file or paste JSON
How to Use JSON Formatter
- 1 Paste your JSON data in the main editor
- 2 Type a JMESPath expression in the query bar
- 3 Results update live as you type
- 4 Click examples to try common expressions
- 5 Copy the filtered result
What You Get
Live JMESPath expression tester. JMESPath is the query language used by AWS CLI and many APIs for filtering and transforming JSON.
Input: people[*].name
Output: Extract all names from array of people
Input: people[?age > `21`]
Output: Filter people older than 21
Input: sort_by(people, &age)
Output: Sort people by age
How do I filter JSON data?
Paste your JSON, type a JMESPath expression like "people[*].name" to extract all names. Results update live as you type the expression.
What is JMESPath and how do I learn it?
JMESPath is a query language for JSON used in AWS CLI, Azure CLI, and many tools. Visit jmespath.org for the full specification and interactive tutorial.
How do I filter an array in JSON?
Use filter expressions: people[?age > `21`] returns people older than 21. The backticks around 21 indicate a literal number.
How do I extract nested values from JSON?
Use dot notation: user.profile.name extracts the name from nested objects. Use [*] to iterate arrays: items[*].price gets all prices.
How do I sort JSON array data?
Use sort_by function: sort_by(people, &age) sorts the people array by age. Use reverse() to sort descending.
Why use JMESPath instead of JSONPath?
JMESPath has better support for projections, filtering, and functions. It is more powerful for complex transformations and is the standard for cloud CLIs.
100% client-side processing - your JSON never leaves your browser.