JSON Tools

ArrayKit's JSON tools cover the whole workflow of building and debugging with JSON, from cleaning up an API response to querying, diffing and turning a payload into typed code. Use the JSON Formatter to beautify, minify and validate with exact error locations, and the JSON Viewer and JSON Tree Viewer to explore deeply nested data as a collapsible, typed tree with node paths. Query documents with the JSONPath Evaluator or the jq Playground, compare two payloads with the semantic JSON Diff, and generate or validate contracts with the JSON Schema Generator & Validator. Reshape data with JSON Flatten / Unflatten, JSON to CSV and JSON to TOON. Need code instead? JSON to TypeScript, JSON to Zod, JSON to Pydantic and JSON to Code produce types for Go, Rust, Python, Java, Kotlin, C# and more. JSON Escape handles stringifying. Everything runs in your browser, so your data stays on your device.

• 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 and SQLite.
• 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.

Frequently asked questions

What can I do with ArrayKit's JSON tools?

You can format, minify and validate JSON, explore it as a collapsible tree, query it with JSONPath or jq, compare two documents with a semantic diff, generate and validate JSON Schema, flatten or unflatten nested data, convert to CSV or TOON, and generate types for TypeScript, Zod, Pydantic, Go, Rust, Python and more.

Are these JSON tools safe to use with sensitive data?

Yes. Every JSON tool runs in your browser. Your JSON is parsed and processed on your device and is never uploaded, so even sensitive API payloads, config and credentials stay local.

How do I query or filter a JSON document?

Use the JSONPath Evaluator to run JSONPath expressions like $.store.book[*].author and see matched values and paths live, or the jq Playground to run jq filters such as .users | map(.name) and select(.active) with instant results.

Can I compare two JSON files or validate a schema?

Yes. JSON Diff shows a structural, key-order-independent comparison of what was added, removed or changed, each with a path. The JSON Schema Generator & Validator builds a draft-07 or 2020-12 schema from a sample and checks any document against a schema.

Which languages can I generate types for from JSON?

JSON to TypeScript creates interfaces, JSON to Zod builds Zod schemas, JSON to Pydantic emits Pydantic v2 models, and JSON to Code produces Go, Rust, Python, Java, Kotlin, C# and TypeScript types from a sample payload.

How do I convert JSON to CSV or other formats?

JSON to CSV flattens an array of objects into a spreadsheet with a header row, JSON to TOON packs data into a compact token-oriented notation for LLM prompts, and JSON Flatten / Unflatten converts between nested JSON and dot-notation keys.