SQL INSERT Generator from CSV, JSON, Excel or Parquet

Generate CREATE TABLE and INSERT from CSV, JSON, Excel or Parquet for Snowflake, BigQuery, Databricks, Redshift, PostgreSQL and more, plus a dbt schema.yml.

Quick answer: Generate CREATE TABLE and INSERT statements from sample data.

Related: CSV to Snowflake CREATE TABLE Generator · CSV to BigQuery Schema and CREATE TABLE Generator · CSV to Databricks Delta DDL Generator · CSV to Redshift CREATE TABLE Generator · Parquet Guides and Free Parquet Tools

How to use the SQL INSERT Generator from CSV, JSON, Excel or Parquet

Generate CREATE TABLE and INSERT statements from sample data.

The SQL Generator turns a CSV, JSON, Excel or Parquet file into CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQL Server, Oracle or SQLite. It guesses a type for each column, lets you edit names, types, lengths and keys, and writes scripts you can run right away. It is useful for loading spreadsheets into a database and for building test fixtures.

  1. Load sample data
  2. Review the column types
  3. Pick a database and copy

Tips

Example

Input: id,name,age 1,Ada,36 2,Alan,41

Output: CREATE TABLE people (id INT, name VARCHAR(10), age INT); INSERT INTO people VALUES (1, 'Ada', 36);

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Does it connect to my database?

No. It only writes the SQL for you to run yourself.

Which databases does the SQL Generator support?

PostgreSQL, MySQL and MariaDB, SQL Server, Oracle and SQLite. It writes CREATE TABLE and INSERT statements from a CSV, JSON, Excel or Parquet file, and guesses column types from your data.

Related pages

Topic guides

Guides