Convert JSON to SQL
Turn JavaScript Object Notation files (.json) into SQL INSERT statements (.sql) in seconds. Drop one file or a whole batch: the conversion happens right in your browser, with no sign-up, no watermark and no upload.
How to convert JSON to SQL
- 1Drop your JSON files into the box above, or click to choose them.
- 2SQL is already selected. Adjust the options if you like.
- 3Click Convert and download your SQL files.
Good to know
- The JSON should be a list of objects. Nested objects are flattened into columns like "address.city".
- Creates a CREATE TABLE statement and INSERT rows with a table name you choose, ready to paste into your database.
- Column types such as numbers and true/false values are detected, and you can set the delimiter and header row.
Frequently asked questions
Is converting JSON to SQL free?
Yes. There is no sign-up, no watermark and no limit on the number of files.
Are my files uploaded?
No. Everything runs in your browser, so your files are never uploaded to a server. That also makes it fast, because nothing has to travel over the network.
Will I lose quality converting JSON to SQL?
No noticeable loss: the conversion keeps the content of your JSON file intact.
Can I convert several files at once?
Yes. Drop as many JSON files as you like. They are converted one after another and you can download them individually or as a ZIP.
Is there a file size limit?
There is no fixed limit. Very large files depend on your device's memory, since the conversion runs locally.
What is JSON?
JSON is the standard data format of the web and APIs, able to hold nested objects and lists.
What is SQL?
SQL INSERT statements let you load table data straight into a database.