JSON Formatter & Validator

How to Use the JSON Formatter & Validator

1. Paste your JSON into the input box, or press Load Example to start from a sample document.
2. Press Format JSON to re-indent it with 2 spaces, 4 spaces or tabs, Minify JSON to remove all optional whitespace, or Validate JSON to check the syntax without changing anything. Invalid input shows your browser's parser error so you can find the problem.
3. Open Explore to browse the document as a searchable tree and copy any node's path or value, or Statistics to see counts of objects, arrays, keys and values, the maximum nesting depth and the size.
4. Open Transform to convert the document to CSV, YAML, XML, TypeScript interfaces or tab-separated rows for a spreadsheet, or Advanced to run simple JSONPath/JMESPath queries, compare it with a second JSON document, or mask values that look sensitive.

Technical Notes

• Validation checks JSON syntax only — it does not check your data against a schema. Any valid JSON value is accepted at the top level, including a single number, string, true, false or null. Comments, trailing commas and single-quoted strings are not valid JSON and are reported as errors.
• Format and Minify parse your JSON into JavaScript values and write them out again, so the output is re-serialized data rather than an edited copy of your text. Some changes are only textual — for example, numbers are written in their shortest form, so 1.0 becomes 1 and 1e2 becomes 100. Others change the data itself: if an object repeats a key, only the last value is kept; numbers JavaScript cannot represent exactly may change, including integers above 9007199254740991 and high-precision decimals; and numbers too large for JavaScript, such as 1e400, become null. If exact numbers or duplicate keys matter, review the result before replacing your source data.
• The JSONPath and JMESPath queries in Advanced support only a limited subset: property access (.key), array indexes ([n]) and wildcards ([*] in JSONPath, [] in JMESPath). Filters, recursive descent (..), slices and functions are not supported, so expressions written for other tools may return nothing or a different result.
• The Data Anonymizer is pattern-based. It replaces string values that are entirely an email address, a phone number or an IPv4 address, and the values of keys whose names suggest secrets, such as password, secret, token or api_key. Because it only matches patterns, it can miss sensitive data — names, street addresses or an email inside a longer sentence, for example — so review the anonymized result before sharing it.
• CSV and the spreadsheet rows of the Excel option turn an array of objects into one row per object, or a single object into one row, with a column for every key found. Nested objects become dotted column names such as address.city, and arrays are written into a single cell as JSON text. The Excel option currently produces tab-separated text to paste into a spreadsheet, not an .xlsx file.