JSON & Data

Format, validate, compare and convert structured data.

JSON FormatterFormat and beautify JSON with configurable indentation and optional key sorting. Runs entirely in your browser.Open tool
JSON ValidatorCheck whether JSON is valid and get the exact line and column of any syntax error, plus size, key count and nesting depth.Open tool
CSV to JSON ConverterConvert CSV to JSON with a real RFC 4180 parser that handles quoted commas, embedded newlines and escaped quotes, and keeps 007 and long ids as text.Open tool
SQL FormatterFormat SQL with one clause per line and indented conditions. Strings, comments and quoted identifiers are never modified.Open tool
XML FormatterIndent XML, or collapse it to one line. Comments, CDATA and attribute values are never modified, and structural problems are named.Open tool
JSON Schema GeneratorGenerate a JSON Schema from a sample document. Array elements are merged properly, so a field missing from one element is not marked required.Open tool
JSON DiffCompare two JSON documents structurally rather than as text. Reports which paths were added, removed or changed, ignoring key order and formatting.Open tool
JSONPath TesterTest JSONPath queries on your JSON exactly as RFC 9535 defines them, with the Normalized Path of every match and where Jayway and Goessner differ.Open tool
JSON to CSV ConverterConvert JSON to CSV with nested objects flattened into columns, arrays kept or expanded, spreadsheet formulas escaped, and an optional BOM for Excel.Open tool
JSON to YAML ConverterConvert JSON to YAML and YAML to JSON with a YAML 1.2 parser that flags yes/no/on values, tab indentation and duplicate keys by line.Open tool
TOML to JSON ConverterConvert TOML to JSON and JSON to TOML with a TOML 1.0 parser that finds duplicate tables, bad escapes and unquoted strings by line. Runs in your browser.Open tool
XML to JSON ConverterConvert XML to JSON and JSON to XML, with attributes, repeated elements and namespaces mapped by a documented convention. Runs in your browser.Open tool
JSON to SQL ConverterConvert a JSON array to SQL INSERT statements and a CREATE TABLE with inferred types for PostgreSQL, MySQL, SQLite or SQL Server, every value escaped.Open tool
JSON to String ConverterTurn JSON into an escaped string for JavaScript, Java, C#, Python, a JSON string or a .env file, or unescape a stringified JSON string back to JSON.Open tool
Excel to JSON ConverterConvert an Excel .xlsx file to JSON: one sheet or all of them, the first row as keys, dates as ISO strings. The file is read in your browser, never uploaded.Open tool
JSON to Excel ConverterConvert a JSON array to an Excel .xlsx file with typed cells: numbers stay numbers, nested objects become columns. Built in your browser; nothing is uploaded.Open tool
CSV to Excel ConverterConvert CSV to an Excel .xlsx file that keeps 007, phone numbers, long IDs and codes like 1-2 exactly as written. Built in your browser; nothing is uploaded.Open tool
Excel to CSV ConverterConvert an Excel .xlsx sheet to CSV with the values Excel stores, not its display rounding: UTF-8 with or without a BOM, any delimiter. Nothing is uploaded.Open tool