JSON & Data
Diff, format, query and convert structured data.
In this chapter
- D1JSON Diff144
Compare two JSON documents side by side and export the changes as a JSON Patch.
- D2JSON Formatter146
Format, validate or minify JSON with exact error positions, sorted keys and size stats.
- D3JSON Viewer148
Browse JSON as a collapsible tree, copy node paths, and query it with JSONPath or jq.
- D4JSON ⇄ YAML ⇄ TOML ⇄ XML150
Convert between JSON, YAML, TOML and XML in any direction, with clear errors and lossy-case warnings.
- D5JSON ⇄ CSV / Excel152
Flatten JSON arrays into CSV or .xlsx, or turn CSV and Excel sheets back into nested JSON.
- D6JSON to Types154
Generate TypeScript, Go, Python, Rust, Kotlin, Java or C# types from sample JSON.
- D7JSON Schema Validator156
Validate JSON against a JSON Schema (draft 2020-12 to 04) or infer a schema from sample data.
- D8Text Diff158
Compare two texts side by side or inline with word-level highlights, and export a unified diff.
- D9CSV Editor160
View, sort, filter, edit and clean CSV files, then download them with any delimiter.
- D10XML Formatter & XPath162
Format or minify XML with parse errors by line, and run XPath queries against it.
- D11YAML Validator164
Validate multi-document YAML, catch duplicate keys with line numbers, and convert it to JSON.
- D12SQL Formatter166
Format SQL for 19 dialects with your choice of keyword case and indentation.
- D13Markdown Preview168
Render Markdown with GitHub extensions in a sanitised preview and copy the HTML.
- D14HTML to Markdown170
Convert HTML to clean Markdown with pipe tables, fenced code and a sanitised preview.
- D15Mock Data Generator172
Generate up to 10,000 rows of realistic fake data as JSON, CSV or SQL INSERTs, reproducible by seed.
- D16Escape / Unescape174
Escape or unescape strings for JSON, JavaScript, Java, C, SQL, CSV, XML and URLs.
- D17Protobuf & MessagePack Decoder176
Decode protobuf wire format without a schema, and convert MessagePack to and from JSON.