SQL to JSON
Extract rows from SQL INSERT statements and export them as JSON in your browser.
Enabling local controls…
Parsed locally. Up to 1 MiB, 20,000 rows, 200 columns and 100,000 cells including headers.
JSON output
Output appears after conversion.
How to use this tool
Paste one or more INSERT INTO … VALUES statements for a single table, or open a UTF-8 file. The result uses the column names in the query. When they are omitted, it uses column_1, column_2, and so on.
When not to use it
Uses single-quoted text, numbers, booleans and NULL. Keep the table and column names, capitalization, quoting and column order identical. Use explicit E'…' escapes for strings containing backslashes. SQL is parsed as text. Statements with comments, functions, casts, conflict clauses, or other SQL commands are rejected. NULL stays null. Numbers that would lose precision as JSON values are exported as strings.