Developer tools
JSONPath Query Tool
Extract values from JSON using common JSONPath expressions. Nothing you enter leaves your browser.
Your result will appear here.
What this tool does
About the JSONPath Query Tool
Extract values from JSON using common JSONPath expressions. It is intended for development and debugging workflows where a small, inspectable transformation is faster than setting up a script.
It is intended for development and debugging workflows where a small, inspectable transformation is faster than setting up a script.
How to use it
- Enter a JSONPath, then --- and JSON in the input pane. Use the example button if you want to see the expected syntax.
- Review the input for the structure shown in the example. Then select “Run JSONPath.”
- Inspect the result for warnings or structural differences, then copy it into the destination system.
Practical example
Start with a known input
Try this sample input:
$.users[*].name
---
{"users":[{"name":"Avery"},{"name":"Jordan"}]}
Select “Run JSONPath” and compare the result with the source before using it elsewhere. What to know about the result
- JSON preserves nested objects, arrays, numbers, booleans, and null values, but it requires quoted property names and does not allow comments.
- Processing happens in this browser. Your entered text and selected files are not sent to FormatCalc for conversion.
Common questions
Using the JSONPath Query Tool
Is the JSONPath Query Tool free to use?
Yes. FormatCalc's JSONPath Query Tool is free to use with no account required.
Is my data private when I use the JSONPath Query Tool?
Yes. This tool processes your input locally in your browser. FormatCalc does not upload or store what you enter.
How do I use the JSONPath Query Tool?
Paste or type your input, select any available options, and choose Run JSONPath. You can then copy the result.
What should I check before using the result?
JSON preserves nested objects, arrays, numbers, booleans, and null values, but it requires quoted property names and does not allow comments. Processing happens in this browser. Your entered text and selected files are not sent to FormatCalc for conversion.