← All tools

SQL to JSON

Extract rows from SQL INSERT statements and export them as JSON in your browser.

sql-to-jsonLOCAL WORKSPACE

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.

Generate SQL INSERT · SQL to CSV

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.