CSV to Redshift CREATE TABLE Generator

Generate an Amazon Redshift CREATE TABLE and INSERT script from a CSV, JSON, Excel or Parquet file. Types are chosen for you. Free, 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 Snowflake CREATE TABLE Generator · CSV to BigQuery Schema and CREATE TABLE Generator · CSV to Databricks Delta DDL Generator · CSV Guides and Free CSV Tools

How to use the CSV to Redshift 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

Is it good for large loads?

INSERT is fine for samples and tests. For big files, upload to S3 and use COPY.

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