Convert JSON Lines to SQL
Turn JSON Lines / NDJSON files (.jsonl) 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 Lines to SQL
- 1Drop your JSON Lines 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
- 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 Lines 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 Lines to SQL?
No noticeable loss: the conversion keeps the content of your JSON Lines file intact.
Can I convert several files at once?
Yes. Drop as many JSON Lines 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 Lines?
JSON Lines stores one JSON record per line, which is handy for logs, streaming and large datasets.
What is SQL?
SQL INSERT statements let you load table data straight into a database.