Data & Formats
Data & Formats
JSON, YAML, XML, CSV, TOML, SQL — validate, format, convert, generate schemas.
19 tools
JSON Validator
A real JSON validator: pinpoints the exact line and column of any parse error, prettifies output with your chosen indent, strips comments and trailing commas on demand (JSONC), and reports tree depth and key count.
OpenJSON Formatter / Diff / Path Tool
Format, minify, diff, query, and infer simple schemas from JSON in one workspace.
OpenYAML Validator
Paste YAML and get instant feedback: parse errors with line and column, duplicate-key detection, tab/space mixing warnings, plus a formatted re-emit and a JSON view of the parsed tree.
OpenJSON Schema to TypeScript
Generates TypeScript interfaces and type aliases from JSON Schema (draft-07 subset) documents. Supports objects, arrays, enums, $ref definitions, oneOf/anyOf unions and additional properties.
OpenJSON to SQL Converter
Free online tool that converts a JSON array into CREATE TABLE and INSERT statements with inferred column types. Supports Postgres, MySQL, and SQLite.
OpenJSON to TypeScript
Paste JSON, get strongly-typed TypeScript interfaces with merged samples, optional keys, unions, and named nested types.
OpenSQL Formatter + Beautifier
Format raw SQL into a cleaner multiline shape and minify it again when needed.
OpenJSONPath / JMESPath Playground
Run JSONPath or a practical JMESPath-lite subset against pasted JSON payloads.
OpenJSON Diff
Compare two JSON documents semantically — handles nested objects, arrays, type mismatches, key order, and emits RFC 6902 / RFC 7396 patches.
OpenMock Data Generator
Build a schema with 30+ field types (names, emails, addresses, UUIDs, dates, enums…) and generate seeded, deterministic mock datasets — export as JSON, CSV, SQL INSERT, or TypeScript.
OpenCSV ↔ JSON Converter
Bidirectional CSV / TSV / JSON converter with delimiter auto-detect, type inference, null handling, flatten option, and live conversion.
OpenJSON to Zod Schema
Generate Zod v3 / v4-rc schemas from JSON samples — merge multiple payloads, detect formats, lengths, ranges, and export the inferred TypeScript type.
OpenJSON-LD Schema Generator
Generate Schema.org JSON-LD structured data with form-based UI for 12 common types (Article, Product, LocalBusiness, Recipe, FAQ, HowTo, Person, Organization…).
OpenJSON Schema Generator
Paste JSON and get a draft-07 or draft-2020-12 schema, plus matching TypeScript interfaces.
OpenTOML ↔ JSON Converter
Bidirectional TOML ↔ JSON converter using smol-toml. Handles nested tables, array-of-tables, inline tables, RFC 3339 datetimes, and key-sorting.
OpenXML ↔ JSON Converter
Bidirectional XML ↔ JSON converter using the browser DOMParser. Configurable attribute prefix, text key, CDATA handling, always-array list, and pretty printing.
OpenSchema Markup Generator
Copy-paste-ready JSON-LD for FAQ, Article, Product, Local Business, Breadcrumbs, How-To, Recipe, and Event.
OpenJSON to Go
Generate starter Go structs from pasted JSON payloads with sensible field names and tags.
OpenXML Formatter
Pretty-print and validate XML. Tokenizer-based formatter handles tags, attributes, CDATA, comments, processing instructions and DOCTYPEs. Reports well-formedness errors with line and column.
Open