DataSwitch: convert tables to JSON, build array-of-objects for JS/Python/PHP/Java, rebuild tables from raw JSON, and auto-generate SQL IN (...) clauses

DataSwitch - Free Table to JSON Converter - Two-Way JSON / Arrays / Table / SQL IN

Table → Array
Table → Objects
JSON → Table
SQL IN Builder

Fill the table on the left, choose options here, then generate.

2D array (rows)
One array per column
JavaScript
JSON
Java
PHP
Python
Single quote
Double quote
Minified
Pretty
"" (empty string)
null
undefined

Turn table rows into [{...},{...}] style objects.

Use first row as keys
Use column letters (A,B,C...)
Set manually
JavaScript
JSON
Java
PHP
Python
Single quote
Double quote
Minified
Pretty
"" (empty string)
null
undefined

Paste JSON / array data here. We'll rebuild the live table on the left.

Auto detect
2D array (rows × cols)
Array-per-column
Array of objects [{...},{...}]
Grouped columns (3D)
"" (empty string)
null → ""
undefined → ""

We read values from the first column in the table. If a cell has multiple IDs, you can split them by delimiter.

Comma ,
Pipe |
Semicolon ;
Whitespace
Custom
Tip: "Whitespace" also splits by newlines. Custom supports RegExp like \\s*[;]\\s*.
Single quote '
Double quote "
Most SQL dialects expect single quotes for string literals.
Just values ('a','b','c')
IN (...) (IN ('a','b'))
field IN (...) (field IN ('a','b'))