JSON & CSV Tools
JSON & CSV Tools
Format, validate, flatten, and query JSON. Clean and repair CSV files. Generate SQL INSERT statements from both formats. Everything runs in your browser.
Pretty-print JSON with 2-space, 4-space, or tab indentation. Or minify it for production. Validates syntax as a side effect.
Validate JSON and see exact line-level syntax errors. Catches trailing commas, single-quoted strings, unquoted keys, and missing brackets.
Collapse deeply nested JSON objects into a single level of dot-notation keys. Configurable depth, separator, and array handling.
Click any value in the JSON tree to get its path expression. Supports JSONPath ($.user.name), dot notation, and bracket notation.
Fix BOM characters, mixed delimiters, ragged rows, trailing commas, and bad quoting in broken CSV files.
Generate SQL INSERT statements from CSV data. Configurable table name, batch size, and optional CREATE TABLE output.
Generate SQL INSERTs from a JSON array. Handles missing fields (NULL), booleans (1/0), nulls, and nested objects.
Validate any JSON document against a JSON Schema. All errors shown with field path and keyword. Draft-07 via AJV.
View CSV as an interactive table. Sort columns, filter rows, edit cells inline, add/delete rows, and export to CSV.
Build and validate cron expressions with live English descriptions and next 5 run times. 12 presets included.
How these tools work together
Parsing as validation
JSON formatting, flattening, and path-finding all require parsing. If the input has a syntax error — trailing comma, mismatched bracket, single-quoted string — you'll see the exact error before the tool runs. Formatting is the easiest way to validate.
CSV cleaning before conversion
Broken CSV files fail silently in most parsers. The cleaner identifies and fixes common issues before you convert: BOM bytes, Windows vs Unix line endings, inconsistent column counts, and unbalanced quotes. Fix first, convert second.
SQL generation for data import
Converting CSV or JSON to SQL INSERT statements bridges the gap between exported data and database import. Type inference ensures numbers stay unquoted, empty values become NULL, and reserved-word column names get backtick-quoted automatically.