JSONPath tester New
Query JSON with JSONPath: select fields, filter arrays on conditions and sort the results. Includes examples and a cheat sheet.
Toolbox has been completely renewed. What do you think? Share your feedback
See a JSON array as a spreadsheet. Sort on any column, filter the rows, pick the columns you need and export the result as CSV, or paste CSV to get JSON.
Runs in your browser. Nothing is uploaded.
Loading the JSON to CSV converter…
Paste a JSON array of objects, or switch to CSV to JSON.
Sort by clicking a column header and filter the rows with the search field.
Choose the separator and download or copy the CSV.
Nested objects are flattened into columns with dotted names, such as address.city. Arrays inside a row are written as JSON text in one cell.
Excel in most European languages expects a semicolon, in English a comma. Toolbox lets you choose, and the download opens directly in Excel with the right characters.
Query JSON with JSONPath: select fields, filter arrays on conditions and sort the results. Includes examples and a cheat sheet.
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.
Generate TypeScript interfaces or types from a JSON example, with nested objects, arrays, optional keys and union types. Copy them in one click.
Compare two JSON documents and see every added, removed and changed value with its path. The order of keys does not matter. Runs locally.
May Toolbox count visits with Google Analytics, to see which tools are used and what to improve? A cookie is stored only if you allow it, and what you enter in the tools is never part of it. Read more about privacy