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 ',';