Skip to content

CSV to SQL converter

Convert CSV to SQL as you type. Nothing is uploaded, and the result can be previewed as a table, copied or downloaded.

Loading the converter… It runs locally in your browser.

How to convert CSV to SQL

  1. Paste your CSV into the input panel, drop a file onto it, or press “Open file”.
  2. Adjust the options above the panels (delimiter, header row, alignment and so on).
  3. Check the result: switch the output to “Table” view to see it as a grid.
  4. Press “Copy” or “Download .sql”. The conversion runs on your device, so large files never leave it.

Column types (INTEGER, BIGINT, DOUBLE, BOOLEAN, VARCHAR/TEXT) are inferred from every value in the column, empty cells become NULL, strings are quoted and escaped for the chosen dialect, and inserts are batched 100 rows per statement.

About CSV

Comma-separated values: one record per line, fields split by a delimiter, and fields that contain the delimiter, quotes or line breaks wrapped in double quotes (RFC 4180).

About SQL

CREATE TABLE plus batched INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server, with column types inferred from the data.

Why some CSV fields get quotes

A CSV field only needs double quotes when it contains the delimiter, a double quote or a line break. A quote inside a field is written twice ("Katherine ""Kay"" Johnson"). Our interactive CSV format guide lets you type a value and watch exactly which rule applies.

Questions people ask

Is my CSV data uploaded anywhere?

No. The CSV to SQL conversion runs entirely in your browser with JavaScript. The page works offline once it has loaded, and TableForge never receives your data.

How large a file can I convert?

The limit is your device's memory. Files of tens of megabytes (hundreds of thousands of rows) convert fine on a typical laptop. The preview shows the first 200 rows, but the download always contains every row.

Does the converter keep special characters and commas?

Yes. Fields containing commas, quotes or line breaks are quoted and escaped according to each format's rules, and text is read and written as UTF-8, so accents, CJK characters and emoji survive.

Can I convert SQL back to CSV?

Yes, use the SQL to CSV converter at tableforge.io/sql-to-csv, or the universal converter on the home page.

Related converters