Convert JSON to SQL Online
Convert JSON to SQL online, free and private: your data never leaves your browser. Paste a JSON array of objects, edit in a real spreadsheet grid, then export INSERT statements for MySQL, PostgreSQL, SQLite or SQL Server.
Drop a CSV or Excel file here
CSV · XLSX · XLS · XLSM · XLSB
Ready to download as a binary file.
How to convert JSON to SQL
Three steps from JSON to INSERT statements.
1. Paste JSON
Paste an array of objects, a 2D array, a keyed object or JSONLines, or drop a .json file.
2. Edit in the grid
Fix values, reorder columns, add rows. The output updates in real time as you edit the spreadsheet.
3. Copy the SQL
Pick a dialect and table name, then copy or download the INSERT statements. Your data never left your browser.
Need this conversion in your own app?
The file parsing behind this page is powered by TabularJS: a zero-dependency JavaScript library that converts spreadsheet files to JSON in Node.js and the browser. 16+ formats, formulas, styles and merged cells included.
Frequently asked questions
Is this JSON to SQL converter free?
Yes. No account, no sign-up, no watermark. Open the page and start converting.
Is my data private?
Yes. Everything runs in your browser. Your JSON is read and processed on your device. Nothing is uploaded, nothing is logged.
Which JSON input shapes are accepted?
An array of objects (most common), a 2D array, a keyed object, and JSONLines (one JSON object per line). The tool detects the shape automatically.
Which SQL dialects are supported?
MySQL (backtick quoting), PostgreSQL, SQLite (double-quote quoting) and SQL Server (bracket quoting). Column types are inferred as INTEGER, REAL or TEXT.
How are empty values handled?
Empty cells and null values are exported as NULL in the SQL output.
Can I embed this converter in my own app?
Yes. The engine that powers this page is the TabularJS JavaScript library. You can embed it in React, Vue, Angular or plain JavaScript.