SQL INSERT Generator: Turn CSV, Excel or Parquet into SQL
Load a spreadsheet into a database without writing SQL by hand. Upload a file and copy the finished script.
Moving spreadsheet data into a database usually means writing many INSERT statements. Doing it by hand is slow, and a single quote inside a name can break the whole script.
The SQL Generator reads your CSV, JSON, Excel or Parquet file, picks a type for each column and writes the CREATE TABLE and INSERT statements for you. Special characters are escaped correctly.
Pick your database first, because each one has its own rules for types and quotes. Your data stays in your browser.
How to use the SQL Generator: step by step
- Open the SQL Generator.
- Upload a CSV, JSON, Excel or Parquet file.
- Pick your database: PostgreSQL, MySQL, SQL Server, Oracle or SQLite.
- Check the column types, then copy the CREATE TABLE and INSERT statements.
When to use the SQL Generator
- Loading a spreadsheet into PostgreSQL or MySQL
- Creating starter data for a new project
- Sharing sample data as a SQL script
- Moving a small table between databases
- Loading a Parquet file from a data lake into a database
Tip: Name the table first. The name is used in every statement.