CSVからSQL変換ツール

CSVデータをSQL文に変換します。自動型検出でCREATE TABLEおよびINSERT文を生成。

Table Name

SQL Dialect

Batch Size

Include CREATE TABLE

CSV Input

Type Detection

Column types are automatically inferred from data values
Dates (YYYY-MM-DD) and timestamps are detected
Boolean values: true/false, 1/0, yes/no
Empty values and "NULL" are converted to NULL

CSV to SQL Conversion - 技術的な詳細

Converting CSV to SQL is useful for importing spreadsheet data into databases. This tool automatically detects column types (integer, decimal, boolean, date, string) and generates properly escaped SQL statements.

コマンドラインでの代替方法

# Import CSV directly in PostgreSQL\n\\copy my_table FROM 'data.csv' WITH CSV HEADER;\n\n# MySQL\nLOAD DATA INFILE 'data.csv' INTO TABLE my_table\nFIELDS TERMINATED BY ',';