JSON
Format, inspect, and query JSON with configurable indentation, key sorting, validation, and JSONPath selection.
Open JSONDeveloper tool category
Use this collection when a payload needs to be inspected, validated, repaired, compared, or converted between common developer data formats. Start with the source format, confirm the structure is valid, then move to the transformation or export step you actually need.
Common workflow
4 recommended starting points
Format, inspect, and query JSON with configurable indentation, key sorting, validation, and JSONPath selection.
Open JSONCheck JSON syntax, locate errors, and review parser details without uploading the payload.
Open JSON ValidatorRepair common JSON syntax problems locally, review every change, and compare the fixed output before you use it.
Open JSON RepairConvert JSON objects and arrays to CSV, flatten nested fields, and download the result locally.
Open JSON to CSVBrowse by subject
1 focused topics
Work across JSON formatting, validation, repair, inspection, conversion, schema workflows, troubleshooting, and practical guides from one topic-focused entry point.
Explore JSONRepresentative utilities
6 additional tools
Format, validate, and convert YAML and JSON locally with YAML 1.2 parsing.
Format and validate XML, convert XML to JSON, or create XML from JSON entirely in your browser.
Format and validate CSV, convert CSV to JSON, or turn JSON into spreadsheet-ready CSV locally.
Compare two JSON documents and review added, removed, and changed paths.
Validate newline-delimited JSON, preview it as an array, normalize one record per line, or convert a JSON array to JSONL.
Parse query parameters into JSON, build encoded query strings, clean and sort parameters in one pass, or run focused sorting and cleanup operations.
Calculate
3 resources
Calculate JSON compression ratio and percentage savings from original and compressed byte sizes, even when the two inputs use different units.
Calculate total JSON payload size from one measured payload and a payload count, with byte, KiB, and MiB breakdowns. Runs locally in your browser.
Estimate ideal JSON payload transfer time from bytes, KB, KiB, MB, MiB, GB, or GiB and network throughput in bits/s or bytes/s. Runs locally.
Understand the concepts
8 resources
Understand CSV quoting, comma, semicolon, and tab delimiters, consistent column counts, header rules, multiline fields, and safe CSV-to-JSON conversion.
Learn how to find and fix missing commas, unquoted keys, trailing commas, invalid escapes, hidden characters, and other common JSON errors.
Learn how JSON escaping works for quotes, backslashes, control characters, newlines, Unicode escapes, and double-encoded JSON with practical examples.
Compare JSON and JSONL structure, examples, streaming behavior, error handling, and the situations where each format is the better choice.
Understand query string percent encoding, plus signs, repeated parameters, empty values, fragments, and how JSON arrays map to repeated query keys.
Learn the difference between formatting SQL and validating it, including dialect syntax, schema checks, execution errors, query safety, and a practical review workflow.