ConvertJson.com
From JSON
JSON To XML
JSON To HTML Table
JSON To SQL
JSON To YAML
JSON To CSV
GeoJSON To CSV
JSON To JSON Lines
JSON To JSON Schema
To JSON
CSV To JSON
XML To JSON
Flat File to JSON
HTML Table To JSON
Javascript Object To JSON
JSON Lines To JSON
SQL To JSON
TOML To JSON
YAML To JSON
Tools
JSON Lint
JSON Viewer
JSON Formatter
JSON Path Analyzer
JSONPath Tester
Reduce JSON
XML Validator
Convert JSON to SQL
Use this tool to convert JSON into SQL. This tool works well with record like JSON objects in an array. It will flatten nested objects.
See also Convert
SQL to JSON
Step 1: Select your input
Option 1 - Choose JSON file
Encoding
Option 2 - Enter an URL
Option 3 - paste into Text Box below
Examples:
Step 2: Choose output options
Output Options
Not working?
If JSON variable A, name the array to convert:
Still not happy - try an alternative conversion
NOTE - you can change the column names below by overwriting the Field Name value.
Enclose field names below with
Quotes ("name")
Backtick (`name`)
Brackets ([name])
Schema.Table or View Name:
Drop Table/View
IF EXISTS
Create Table/View
IF NOT EXISTS
Escape SQL Strings With Backslash (MySql style)
Include Auto Increment Clause on single numeric Primary Key using
-- Choose --
MySQL AUTO_INCREMENT
Sql Server IDENTITY(1,1)
Access AUTOINCREMENT
For INSERT
Use REPLACE instead
(REPLACE INTO tablename ....)
Use one INSERT/REPLACE statement with multiple VALUES clauses -
How many?
Add phrase after INSERT/UPDATE keyword:
(INSERT phrase INTO ...)
For SELECT and MERGE
System TABLE needed to SELECT from?
Table Name:
Batch how many rows together via UNION ALL?
All
1
10
100
1000
Valid if not creating VIEW for SELECT
Step 3: Generate output
Result Data:
Save your result:
.sql
EOL:
CRLF
LF