SQL INSERT Statement Generator
Generate SQL INSERT statements from a CSV, JSON, Excel or Parquet file in seconds, with escaping handled for you. Free, in your browser.
How to use the SQL INSERT Statement Generator
Generate CREATE TABLE and INSERT statements from sample data.
- Load sample data
- Review the column types
- Pick a database and copy
Tips
- Works for PostgreSQL, MySQL, SQL Server, SQLite and Oracle.
- Set a primary key and edit any type the tool guessed.
- Copy and Download contain the full script.
Example
Input: orders.csv
Output: INSERT INTO orders (...) VALUES (...);
Frequently asked questions
How do I generate INSERT statements?
Load your file, choose a database and copy the INSERT script.
Are quotes escaped?
Yes. Single quotes and special characters are escaped correctly.
Does it connect to my database?
No. It only writes the SQL for you to run yourself.
Guides