JSON Tools

Thirteen tools for working with JSON, from the everyday JSON Formatter and JSON Validator to converters for CSV, YAML, XML and TypeScript. Everything runs in your browser — the data you paste is parsed locally and never sent to a server.

Format, validate and inspect JSON

Paste anything into the JSON Formatter to pretty-print it with 2-space, 4-space or tab indentation, or run it through the JSON Minifier to strip whitespace and see exactly how many bytes you saved. When a document won’t parse, the JSON Validator points at the exact line and column of the error instead of leaving you to hunt for a stray comma. And for payloads too large to read top to bottom, the JSON Viewer renders a collapsible tree with type highlighting, so you can drill into just the branch you care about.

Three more tools cover the editing chores around JSON. The JSON Diff compares two documents and lists every added, removed or changed value — the quickest way to see what actually differs between two API responses. The JSON Sorter orders all object keys alphabetically, which makes documents stable and diff-friendly in version control. And when you need to embed one JSON string inside another, or paste JSON into source code as a string literal, the JSON Escape / Unescape tool handles the backslashes in both directions.

Convert JSON to CSV, YAML, XML, TypeScript and SQL

Six converters turn JSON into whatever the next system expects. The JSON to CSV Converter flattens an array of objects into a downloadable file that opens straight in a spreadsheet, and the CSV to JSON Converter goes the other way with automatic type detection. JSON to YAML and JSON to XML produce cleanly indented output for config files and older APIs. Developers get two shortcuts on top: JSON to TypeScript generates interfaces from a sample payload, and the JSON Array to SQL IN Statement turns an array — or one key plucked from an array of objects — into a quoted IN (…) list ready for a query.

Frequently asked questions

Is it safe to paste private JSON, like real API responses, into these tools?

Yes. Every JSON tool on this site parses and transforms your input with JavaScript running in your browser — nothing you paste is transmitted anywhere. You can confirm it yourself: load a tool, disconnect from the internet, and it keeps working.

Why does my JSON fail validation when it looks fine?

The usual culprits are trailing commas, single quotes instead of double quotes, unquoted keys, or comments — all legal in JavaScript but forbidden in JSON. The JSON Validator reports the exact line and column of the first error, which usually makes the fix obvious.

Can I convert JSON into a spreadsheet?

Yes — the JSON to CSV Converter turns a JSON array of objects into a CSV file that Excel, Google Sheets and Numbers open directly. When someone sends the spreadsheet back, the CSV to JSON Converter covers the return trip, with automatic type detection for numbers and booleans.

Looking for something else? Browse all 67 tools, or jump to CSV & Data Tools, Encoders & Converters and CSS & Color Tools.