CSV to Snowflake CREATE TABLE Generator

Generate a Snowflake CREATE TABLE and INSERT script from a CSV, JSON, Excel or Parquet file. Free, runs in your browser.

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

Related: SQL INSERT Generator from CSV, JSON, Excel or Parquet · CSV to BigQuery Schema and CREATE TABLE Generator · CSV to Databricks Delta DDL Generator · CSV to Redshift CREATE TABLE Generator · CSV Guides and Free CSV Tools

How to use the CSV to Snowflake CREATE TABLE Generator

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" INTEGER NOT NULL, "name" VARCHAR(255) );

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Which Snowflake types does it use?

INTEGER, BIGINT, FLOAT, BOOLEAN, DATE, TIMESTAMP_NTZ and VARCHAR. You can change any column type before copying the script.

Can I load the data with INSERT?

Yes. The script includes batched INSERT statements. For very large files, use COPY INTO with the CSV instead.

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