Online JSON To SQL Converter

Input data

Browse

Table name

Output data

JSON To SQL Converter helps you to convert JSON to SQL online.

JSON to SQL converter simplest

This free online tool lets you convert a JSON file into a SQL file.Just paste your JSON in the form below and it will instantly get converted to SQL No need to download or install any software. Free

Tool what is a JSON to SQL converter?

This JSON to SQL converter transforms JSON data and files into SQL data and files. This converter allows customizing input JSON and output SQL It also accepts JSON files with custom column delimiter characters and field quote characters. It supports comment lines and you can optionally ignore empty lines. You can also change how many spaces to use in the output SQL indentation.

How to Convert JSON to SQL?

Step 1: Select your input. Enter Data.
Step 2: Choose output options (optional) Output Options.
Step 3: Generate output.

JSON to SQL converter examples

JSON

[
    {
        "pin": "0001",
        "time": "1524810082"
    },
    {
        "pin": "0002",
        "time": "1524810082"
    },
    {
        "pin": "0003",
        "time": "1524810082"
    },
    {
        "pin": "0004",
        "time": "1524810082"
    }
]

SQL

/* INSERT QUERY NO: 1 */
INSERT INTO table_name (pin, time) VALUES (0001, 1524810082);

/* INSERT QUERY NO: 2 */
INSERT INTO table_name (pin, time) VALUES (0002, 1524810082);

/* INSERT QUERY NO: 3 */
INSERT INTO table_name (pin, time) VALUES (0003, 1524810082);

/* INSERT QUERY NO: 4 */
INSERT INTO table_name (pin, time) VALUES (0004, 1524810082);