JSON Tools

ArrayKit's JSON tools cover the jobs that come up whenever an API response, config file or data export lands in front of you. To read, fix and compare JSON, the JSON Formatter beautifies, minifies and validates it with the exact line and column of the first error, the JSON Viewer shows a collapsible tree and the path of any node you click, JSON Repair fixes the trailing commas, single quotes, unquoted keys and comments that break hand-edited or AI-generated JSON, and JSON Diff shows what changed between two versions while ignoring key order. To move data between formats, JSON to CSV, CSV to JSON and Excel to JSON handle spreadsheets and exports, and JSON to SQL writes CREATE TABLE and INSERT statements. To query and patch, the JSONPath Evaluator and jq Playground pull out or reshape the values you need, and the JSON Patch Generator turns a change into an RFC 6902 patch. For typed code, JSON to TypeScript, JSON to Zod, JSON to Pydantic and JSON to Code write types and models from a sample, and the JSON Schema Generator & Validator builds a schema or checks a document against one. They are built for backend and frontend developers, QA engineers and data analysts. Everything runs in your browser, so the JSON, CSV and spreadsheets you paste or drop stay on your device and are never uploaded.

  • JSON Formatter — Beautify, minify and validate JSON with error locations.
  • JSON Tree Viewer — Explore JSON as a collapsible, typed tree.
  • JSON Viewer — Text + collapsible tree viewer with expand/collapse and node paths.
  • JSON to TypeScript — Generate TypeScript interfaces from a JSON sample.
  • JSON to CSV — Convert an array of flat JSON objects to CSV.
  • JSON Escape / Unescape — Escape text into a JSON string or unescape a JSON string back to raw text.
  • JSON to Code — Generate Go, Rust, Python, Java, Kotlin, C# and TypeScript types from JSON.
  • JSON Diff — Compare two JSON documents and see a structural, key-order-independent diff.
  • JSON Schema Generator & Validator — Generate a JSON Schema from a sample or validate JSON against a schema.
  • JSON Flatten / Unflatten — Flatten nested JSON to dot-notation keys, or unflatten it back.
  • JSON to Zod — Generate a Zod schema (TypeScript) from a JSON sample.
  • JSON to Pydantic — Generate Pydantic v2 model classes from a JSON sample.
  • JSONPath Evaluator — Query JSON with a JSONPath expression and see matched values and paths live.
  • JSON to TOON — Convert JSON to TOON (Token-Oriented Object Notation) and back, with an LLM token savings estimate.
  • jq Playground — Run jq filters against JSON in your browser — map, select, group_by and more, with the real jq engine.
  • TypeScript to Mock JSON — Generate realistic mock JSON from a TypeScript interface or type.
  • JSON Schema Sample Data Generator — Generate realistic sample JSON that conforms to a JSON Schema.
  • JSON to XML Converter — Convert JSON to XML and XML back to JSON, in your browser.
  • NDJSON to JSON — Convert NDJSON / JSON Lines to a JSON array and back, line by line.
  • Sort JSON Keys — Recursively sort JSON object keys alphabetically, with pretty-print and reverse options.
  • CSV to JSON — Convert CSV or TSV to JSON with type inference and nested keys, in your browser.
  • Excel to JSON — Convert an .xlsx or .xls spreadsheet to JSON, with sheet and header options, in your browser.
  • Excel to CSV — Convert an .xlsx or .xls spreadsheet to clean CSV or TSV, in your browser.
  • CSV to SQL — Convert CSV to SQL INSERT and CREATE TABLE statements for MySQL, PostgreSQL, SQLite and SQL Server.
  • HTML Table to JSON — Extract HTML tables into JSON or CSV, honoring headers and colspan, in your browser.
  • JSON Patch Generator — Generate an RFC 6902 JSON Patch between two JSON documents and apply a patch to a source.
  • JSON Repair — Fix broken or LLM-generated JSON: trailing commas, single quotes, unquoted keys and comments.
  • JSON to GraphQL Schema — Generate GraphQL SDL types from a JSON sample, inferring fields and nested types.
  • JSON to SQL — Turn a JSON array into CREATE TABLE and batched INSERTs with inferred column types.

Guides

  • JSON Formatting, Explained — A complete guide to JSON: what it is, its data types and syntax rules, beautify vs minify, validation and JSON Schema, common errors, and best practices.

Frequently asked questions

What can I do with ArrayKit's JSON tools?
Format, minify, validate and repair JSON, view it as a tree, sort or flatten it, escape strings, query it with JSONPath or jq, and compare two documents or turn the difference into a JSON Patch. Converters bring CSV, Excel, HTML tables, XML and NDJSON into JSON and turn JSON into CSV, XML, SQL or TOON. Generators write TypeScript, Zod, Pydantic, GraphQL, Go, Rust, Java, Kotlin and C# types from a sample, TypeScript to Mock JSON goes the other way, and the schema tools build a JSON Schema, check documents against it or produce sample data that fits it.
How do I format and validate JSON, or fix JSON that will not parse?
Paste it into the JSON Formatter, which pretty-prints with 2-space, 4-space or tab indentation, minifies to one line and reports the exact line and column of the first syntax error. If the text is close to JSON but not valid, such as a JavaScript object, a config file with comments or an AI reply wrapped in code fences, run it through JSON Repair. It strips the fences and comments, fixes trailing commas, single quotes, unquoted keys and Python-style True, False and None, closes truncated brackets and summarizes each fix it made.
Can I convert JSON to CSV, or CSV and Excel files to JSON?
Yes. JSON to CSV turns an array of objects into CSV with a header row built from every key, and CSV to JSON goes the other way, detecting numbers, booleans, dates and empty cells and nesting dotted headers such as user.name. Excel to JSON and Excel to CSV read any sheet of an .xlsx or .xls workbook, while the JSON to XML Converter, NDJSON to JSON and HTML Table to JSON cover XML, JSON Lines and HTML table markup. To build a formatted Excel workbook from JSON, use the JSON to Excel Converter in the Excel & Spreadsheets tools.
Is my data private when I use these JSON tools?
Yes. Every JSON tool runs in your browser, so the API responses, config files, spreadsheets and logs you paste or drop are processed on your device and never uploaded to a server. Even so, handle production secrets with care and clear the page when you finish on a shared computer.
Which JSON standards and versions do the tools support?
The JSON Schema Generator & Validator writes and checks draft-07 and 2020-12 schemas, and the JSON Schema Sample Data Generator also reads 2019-09. The JSON Patch Generator creates and applies RFC 6902 patches as well as RFC 7386 merge patches, and the jq Playground runs real jq 1.8, so a filter gives the same result it would on the command line. JSON Diff compares structure rather than text, so reordered keys are not reported as changes.