CSV to BigQuery Schema and CREATE TABLE Generator

Generate a BigQuery CREATE TABLE and INSERT script (INT64, STRING, DATETIME) from a CSV, JSON, Excel or Parquet file. 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 Databricks Delta DDL Generator · CSV to Redshift CREATE TABLE Generator · CSV Guides and Free CSV Tools

How to use the CSV to BigQuery Schema and 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` INT64 NOT NULL, `name` STRING );

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Does it handle BigQuery primary keys?

Yes. A primary key is written as PRIMARY KEY (...) NOT ENFORCED, because BigQuery does not enforce keys.

How are quotes in text escaped?

With a backslash before the quote, which is what BigQuery expects, not the doubled quote used by other databases.

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