How to use the CSV to SQL converter
- Drop your CSV or paste it.
- Type the table name you want.
- Click Convert and run the SQL in your database.
What to know
- Columns are created as TEXT so every value fits. Change the types afterward if you need numbers or dates.
- Single quotes in values are escaped, and empty cells become NULL.
- Whole numbers and decimals are inserted without quotes.
Questions
Which databases does it work with?
The statements use standard SQL with double-quoted column names, which works in PostgreSQL, SQLite and most others. For MySQL, run SET sql_mode = ANSI_QUOTES first.