JSON to SQL Server INSERT Converter
Generate SQL Server INSERT statements from a JSON object or array of records, with safely quoted identifiers and Unicode values.
Start with your input
Edit the example or replace it with your own text.
How to use JSON to SQL Server INSERT Converter
- Paste or edit the json record or array of records.
- Select generate sql server inserts to process the input locally in your browser.
- Review the output, then copy it or download the converted file.
Convert JSON to SQL Server INSERT without losing useful fields
Creates one INSERT statement per record for the editable default target [dbo].[records]. Text is emitted as Unicode N strings, null stays NULL, and nested values are JSON text. Review the target table and column types before running generated SQL.
Check the output before importing it
The converter reports invalid or unsupported input rather than guessing silently. Review the generated values in the destination application, especially date formats, nested data and identifiers that may have special meaning there.
Example input
[{"first_name":"Ada","city":"London"},{"first_name":"Linus","city":"Helsinki"}]Is my input stored?
No. This conversion runs in your browser and your input is not uploaded.
Is input uploaded?
Processing takes place in your browser. This tool does not send your input or selected files to a conversion API.