CSV to SQL INSERT Converter

Developer Tools

Turn CSV rows into SQL INSERT statements

FreePrivateInstant
Add a file · .txt .md .csv .json … · up to 2.00 MB
Table name

Similar tools you may like

History

All history →

CSV to SQL INSERT Converter — at a glance

Load spreadsheet data into a database by turning each CSV row into an INSERT statement.

Input
id,name
1,Asha
Run
Result
INSERT INTO my_table (`id`, `name`) VALUES (1, 'Asha');

How to use it — step by step

CSV text where the first row contains the column names.

1

Paste your input

Paste or type your content into the big input box.

2

Choose options

Pick the mode and options that fit what you need.

3

Generate SQL

Press the button. The result is created instantly on your device.

4

Copy the result

Check the output and press Copy to use it anywhere.

Pro tips

Small things that make the result better.

✦Use a multi-row INSERT for faster imports of big files.
✦Empty cells become NULL and numbers stay unquoted.
✦Always test the SQL on a copy of your database first.

Quick facts

Escapesquotes handled
NULLempty cells
Batchmulti-row option
Freeno signup

Frequently Asked Questions

Which databases does it work with?+

The statements are standard SQL and work with MySQL and MariaDB (backtick column names). For PostgreSQL, replace backticks with double quotes.

Are quoted commas supported?+

Yes. Values inside double quotes can contain commas and line breaks.

Is my data safe?+

Yes. Everything runs inside your own browser. Your text, files and images are never uploaded to any server.

More Free Tools