JSONPath & XPath Evaluator
Run JSONPath or XPath queries on your data and see every match and the match count.
Initializing Data Studio Workspace...
Query Tool
JSONPath & XPath Query Evaluator Guide
Pull specific values out of a large JSON, XML or CSV file with a JSONPath expression or an XPath selector. Results and the match count update as you type.
- 01
Enter Payload & Query
Paste your raw data payload into the editor and enter any valid JSONPath expression (e.g. `$.users[*].email`).
- 02
Read the Matches
Every matching value is listed, along with how many there are. Change the expression to narrow or widen the result.
Frequently Asked Questions
Answers about this tool.
Can I evaluate JSONPath on XML or CSV files?
Yes. XML and CSV are read into the same structure as JSON first, so the same JSONPath expressions work on them.
Related tools
JSON Schema Generator
Generate a Draft-07 JSON Schema from a sample payload, with types detected from your data.
Open toolJSON to TypeScript Interface
Generate TypeScript interfaces from JSON, including nested objects.
Open toolJSON to Go Structs
Generate Go struct definitions with json field tags.
Open toolJSON to Python Dict
Convert JSON into a Python dict or list literal you can paste into your code.
Open toolJSON to SQL INSERT Statements
Convert an array of JSON objects into SQL INSERT statements, with columns taken from your keys.
Open toolAll Data Studio tools
Convert between 27 data formats in either direction, filter and reshape records, run simple JSONPath queries, generate JSON Schema, and create TypeScript, Go, C#, or Rust types. It all runs in your browser.
Open tool
