CSV to MySQL INSERT Generator — Free Online

Convert CSV data directly into MySQL INSERT statements with correct identifier quoting (`name`), dialect-specific type mapping, NULL handling, and batched output. Everything runs in your browser — no data leaves your machine.

👉 Open the full tool with MySQL pre-selected:

CSV to SQL INSERT Generator →

MySQL Type Mapping

Generic Type	MySQL Type
int	INT
float	DECIMAL(18,6)
bool	TINYINT(1)
string	TEXT

Uses backtick identifier quoting. Booleans map to TINYINT(1).

Example: CSV Input

id,name,email,amount,active
1,Alice,[email protected],250.00,true
2,Bob,[email protected],,false
3,Carol,[email protected],175.50,true

Example: MySQL Output

INSERT INTO `customers` (`id`, `name`, `email`, `amount`, `active`) VALUES
  (1, 'Alice', '[email protected]', 250.00, 1),
  (2, 'Bob', '[email protected]', NULL, 0),
  (3, 'Carol', '[email protected]', 175.50, 1);

Other Dialect Pages

Frequently Asked Questions

Why does MySQL use backticks instead of quotes?▼

MySQL uses backtick (`) for identifier quoting by default. This avoids conflicts with single and double quotes used for string literals. The ANSI_QUOTES mode allows double-quote identifier quoting but is not enabled by default.

What about ON DUPLICATE KEY UPDATE?▼

Upsert (ON DUPLICATE KEY UPDATE) support is planned for a future version. Currently the tool generates standard INSERT statements.

Does this tool upload my data?▼

No. All parsing and SQL generation runs in your browser. Your data never leaves your machine.