JSON Formatter
Pretty-print JSON with configurable indentation — big numbers preserved exactly, entirely on this device.
86 tools in this domain
Format, convert, diff and repair structured data — JSON, CSV, XML, YAML and friends — entirely in your browser, nothing uploaded.
Pretty-print JSON with configurable indentation — big numbers preserved exactly, entirely on this device.
Syntax-check JSON with the exact line, column and probable cause of every error — entirely on this device.
Strip insignificant whitespace from JSON — values and key order byte-identical, gzip savings measured, entirely on this device.
Navigate huge JSON as a collapsible, searchable tree — copy any value or path, entirely on this device.
Edit JSON in a tree, table or text view — every change re-renders the other two and big numbers stay exact, entirely on this device.
Compare two JSON documents structurally — key order ignored, big numbers exact, RFC 6902 patch export — entirely on this device.
Turn almost-JSON into valid JSON with a logged, visible fix for every change — entirely on this device.
Sort JSON object keys recursively — ascending or descending, on this device.
Backslash-escape text into a JSON string body — or unescape one back to text — entirely on this device.
Wrap a JSON document as a quoted, escaped JSON string token — and unstringify it back — entirely on this device.
Collapse JSON to a single line for logs, env vars and inline config — readable spacing or fully compact, big numbers preserved exactly, entirely on this device.
Flatten nested JSON to dot- or bracket-path keys and unflatten it back — big numbers exact, entirely on this device.
See any JSON document as an interactive, collapsible node graph — pan, zoom and copy any path, entirely on this device.
Reshape JSON between a single array and one-record-per-line NDJSON — losslessly, with every line validated, entirely on this device.
Evaluate a JSONPath expression against your JSON and see every match highlighted in the source — RFC 9535 semantics, entirely on this device.
Click any node in a JSON tree to copy its JSONPath, jq, JS, or RFC 6901 JSON Pointer path — entirely on this device.
Run jq filters over your JSON in-browser — jq 1.8.2 on WebAssembly, stdout and errors verbatim, entirely on this device.
Check a JSON document against a JSON Schema and see every violation with its data path and schema path — entirely on this device.
Paste sample JSON, get a JSON Schema in the draft you target — required derived from what the samples actually show, entirely on this device.
Turn a JSON Schema into valid example data — one integer seed makes it reproducible, entirely on this device.
Paste a JSON Schema, get TypeScript types — local $ref and $defs resolved, every dropped keyword named, entirely on this device.
Turn a JSON Schema into Zod source with z.infer types — every dropped constraint named, entirely on this device.
Paste sample JSON, get idiomatic TypeScript interfaces — multi-sample optionality and real unions, entirely on this device.
Generate idiomatic Go structs with correct json tags and initialisms from sample JSON — entirely on this device.
Generate C# classes or records from sample JSON, matched to System.Text.Json or Newtonsoft — entirely on this device.
Generate Java POJOs or records with the right annotation stack from sample JSON — entirely on this device.
Generate Pydantic v2 models, dataclasses or TypedDicts from sample JSON — entirely on this device.
Generate Rust serde structs from sample JSON with correct Option<T> optionality and exact 64-bit integers — entirely on this device.
Generate Kotlin data classes with kotlinx.serialization or Jackson annotations from sample JSON — entirely on this device.
Generate Swift Codable structs or classes from sample JSON, with CodingKeys for wire names — entirely on this device.
Paste sample JSON, get a Zod schema plus z.infer types — optionality from multiple samples, entirely on this device.
Paste sample JSON, get GraphQL SDL types — nullability read from your samples, entirely on this device.
Generate CREATE TABLE DDL from sample JSON for four SQL dialects, with three honest shapes for nested data — entirely on this device.
Turn TypeScript interfaces and type aliases into a JSON Schema or Zod schema — unsupported types are named, never guessed — entirely on this device.
Turn sample JSON into a proto3 .proto message with stable field numbers — entirely on this device.
Syntax-check YAML with the exact line, column and cause of every error — plus lint warnings on valid files, entirely on this device.
Re-indent YAML without losing comments or rewriting your numbers — entirely on this device.
Convert YAML to JSON or JSON to YAML with anchors, multi-document streams and type quirks handled honestly — entirely on this device.
Convert YAML to XML, XML back to YAML, or list-shaped YAML to CSV/TSV — every dropped construct counted — entirely on this device.
Compare two YAML documents structurally — added, removed, changed and retyped keys, order-insensitive by default, entirely on this device.
Pretty-print XML without corrupting mixed content, CDATA or comments — entirely on this device.
Check XML well-formedness with the exact line, column and paired open-tag position of every error — entirely on this device.
Strip insignificant whitespace from XML — mixed content, CDATA and preserved subtrees byte-identical, savings measured, entirely on this device.
Navigate large XML as a collapsible tree — search names, see namespaces, copy any node's XPath, entirely on this device.
Evaluate an XPath 1.0 expression against your XML and see every matched node with its line and path — namespace prefixes bound explicitly, on this device.
Compare two XML documents by structure — added, removed and changed elements, attributes and text, addressed by node path — entirely on this device.
Escape text for XML element or attribute contexts — or unescape entities and character references — entirely on this device.
Convert XML to JSON — and back — with explicit attribute, array, and mixed-content semantics, entirely on this device.
Turn repeating XML records into CSV, TSV or an .xlsx workbook — you pick the row element — entirely on this device.
Convert CSV to JSON or JSON to CSV — streaming to 100 MB, type-safe by default — entirely on this device.
Open a CSV in a grid, edit cells, rows and columns, then export it with your delimiter and quoting intact — entirely on this device.
Generate CREATE TABLE and batched INSERT statements from CSV or JSON, with dialect-correct quoting and escaping — entirely on this device.
CSV to XLSX and back without Excel's mangling — leading zeros, IDs and dates survive, entirely on this device.
Turn CSV or TSV into a GitHub-ready Markdown pipe table — or paste a Markdown table and get CSV back — entirely on this device.
Turn CSV or TSV into a semantic, injection-safe HTML table — or paste a table back and get CSV — entirely on this device.
Change a CSV's delimiter to tab, semicolon, pipe or anything you type — re-quoted correctly, entirely on this device.
Check a CSV against RFC 4180 and get every ragged row, stray quote and encoding problem with its row and column — on this device.
Compare two CSV exports row by row — added, removed and changed rows, cell-level detail, optional key-column match — entirely on this device.
Drop repeated CSV rows by whole row or chosen columns, then sort and filter what is left — header kept, counts shown, all on this device.
Split a CSV into parts by rows, part count or size — header repeated in every part — and merge exports back into one file, entirely on this device.
Pull one column out of a CSV as a plain list, or drop, reorder, rename and insert columns and download the new file — entirely on this device.
Turn a range copied from Excel, Google Sheets or Numbers into JSON or a Markdown table — entirely on this device.
Convert TOML to JSON or JSON to TOML with tables, dotted keys and all four datetime types handled honestly — entirely on this device.
Convert TOML to YAML or YAML to TOML with datetimes, nulls, anchors and comments all accounted for — entirely on this device.
Convert .properties to nested YAML or YAML back to .properties — dotted keys, indexed lists and \uXXXX escapes handled honestly — entirely on this device.
Decode protobuf bytes with no .proto — field numbers, wire types and ranked value guesses, entirely on this device.
Paste sample JSON, get a valid Avro .avsc — nullable unions with defaults and honest int-versus-long, entirely on this device.
Pretty-print or minify SQL across 13 dialects with configurable style — entirely on this device.
Generate placeholder text by paragraphs, sentences, words, or an exact character budget — entirely on this device.
Generate themed placeholder text — hipster, corporate, tech, pirate, or bacon — by paragraphs, sentences, or words, entirely on this device.
Generate random names by locale and gender — seeded, reproducible, entirely on this device.
Generate synthetic street addresses by locale — components and a formatted block, seeded and reproducible, entirely on this device.
Generate a complete fake identity — name, email, avatar, address, phone, company — as a card or JSON, seeded and reproducible, entirely on this device.
Build a schema and generate realistic fake data as CSV, JSON, SQL, or XML — seeded, reproducible, entirely on this device.
Generate fake JSON from a small template of Faker tokens and repeat() — seeded, reproducible, entirely on this device.
Turn CREATE TABLE DDL into a crow's-foot ER diagram — keys, foreign-key cardinality and SVG export, entirely on this device.
Build or parse PostgreSQL, MySQL, MongoDB, Redis, SQL Server and JDBC connection strings with correct percent-encoding — entirely on this device.
Open a .sqlite file, browse tables and run real SQL in your browser — SQLite compiled to WebAssembly, nothing uploaded.
Run real SQL on CSV and Parquet files in your browser with DuckDB — joins, group-bys and window functions, nothing uploaded.
Check SQL syntax per dialect — unbalanced quotes, clause order and dialect slips flagged with line and column, entirely on this device.
Paste EXPLAIN ANALYZE output and see the plan as a tree with per-node timing, rows and hot spots — entirely on this device.
Convert CREATE TABLE DDL into Prisma schema, SQLAlchemy models or TypeORM entities — with a cited type mapping, entirely on this device.
Translate SQL SELECT statements into MongoDB find() or aggregation pipelines for mongosh — entirely on this device.
Format MongoDB shell queries with ISODate, ObjectId and NumberLong kept intact — where plain JSON formatters choke, entirely on this device.
Search every Redis 7.2 command with syntax, complexity and since-version, and build common commands for redis-cli — entirely on this device.
Convert DynamoDB marshalled JSON to plain JSON and back — S, N, B, M, L and set types handled with number precision preserved, on this device.