What SQL dialects are supported?

MySQL (backtick-quoted identifiers, backslash string escaping), PostgreSQL (double-quoted identifiers, standard SQL string escaping), and SQLite (double-quoted identifiers, standard SQL string escaping). The VALUES syntax is identical across all three dialects.

What does "batch size" do?

A batch size of 1 produces one INSERT statement per row. A larger batch size groups multiple rows into a single INSERT ... VALUES (...), (...) statement, which is significantly faster to execute because it reduces round-trips to the database.

How are string values escaped?

For MySQL, single quotes inside string values are escaped with a backslash ('). For PostgreSQL and SQLite, single quotes are doubled ('') per the SQL standard. Backslashes in MySQL strings are also escaped.

What happens to empty fields?

With "Empty fields as NULL" enabled, any blank CSV field is emitted as the SQL keyword NULL. With the option disabled, blank fields are emitted as empty strings ('').

Are numbers and booleans handled specially?

Yes. Values that are valid integers or decimals are emitted without quotes so the database receives them as numeric literals. The strings "true" and "false" (case-insensitive) are emitted as 1 and 0 for maximum compatibility across dialects.

Is my data sent to a server?

No. All parsing and SQL generation happens entirely in your browser using JavaScript. Your CSV data never leaves your device.

CSV to SQL INSERT Converter

Name: CSV to SQL INSERT Converter
Availability: InStock
Author: Nham Vu

Paste CSV data and instantly generate SQL INSERT statements for MySQL, PostgreSQL, or SQLite with a configurable table name and batch size.

CSV Input

Load File

Options

Table Name

SQL Dialect

Delimiter

Batch Size

Empty fields as NULL Auto-detect numbers & booleans (emit unquoted) Trim whitespace from fields

SQL Output

Paste CSV above and click Generate SQL.

A sample CSV has been pre-loaded — click Generate SQL to try it.

Copied!

Summary

Paste CSV data and instantly generate SQL INSERT statements for MySQL, PostgreSQL, or SQLite with a configurable table name and batch size.

How it works

The tool parses CSV input using a full RFC 4180 parser running entirely in your browser. Column names are taken from the first row. Each subsequent row is converted to a parameterized VALUES tuple. Strings are escaped per the selected dialect, numbers are emitted unquoted, and empty fields can optionally become NULL. Rows are grouped into batches of the configured size to produce efficient multi-row INSERT statements.

Use cases

Seeding a development or test database from a CSV export.
Migrating spreadsheet data into a relational database.
Generating SQL fixture files for integration tests.
Bulk-loading data into MySQL, PostgreSQL, or SQLite without needing a CLI import tool.
Converting data warehouse CSV exports into INSERT scripts for a different database engine.
Quickly populating a lookup or reference table from a manually authored CSV.

Frequently Asked Questions

Last updated: 2026-06-09 · Reviewed by Nham Vu