The JSON hub is no longer just format and compare—recent batches added row export formats, SQL-style joins, field-level stats, and array slicing pages. Everything below runs in your browser; start from the output shape you need.
Export JSON rows to flat text
When you have an array of objects and need a file Excel, a log pipeline, or a script can consume, pick the delimiter first.
- JSON to TSV, JSON to CSV, and JSON to pipe lines — spreadsheet and log-friendly exports.
- JSON to NDJSON and JSON to plain lines — one JSON object or readable summary per line.
Join, union, and diff row sets
- JSON anti-join, JSON cross join, and JSON union all — combine two pasted arrays on keys or by Cartesian product.
- Symmetric difference by key — rows unique to either side when reconciling two exports.
- Group by field and Sort array — reshape before export or compare.
Field stats, padding, and cleanup
- IQR stats on field and JSON stats — quartiles and column summaries on numeric fields.
- Pad array to length, Skip first N rows, and JSON prune nulls — align batch sizes and drop empty values.
- Replace values, Pick keys, and Rename keys — surgical edits before codegen or export.
Still start with format, tree, and compare
- JSON formatter, JSON tree viewer, and Compare JSON — readable structure before row operations.
- YAML ↔ JSON, CSV ↔ JSON, and JSON to Excel — interchange with configs and spreadsheets.
For the full symptom-first map (repair, JSON5, codegen), see which JSON tool do I need? Export and join neighbors from the GSC cluster batch are also summarized in GSC cluster long-tail guide.