Table to SQL – Free CSV/JSON to INSERT Statement Converter

Convert CSV or JSON data to SQL INSERT statements. Supports 5 database dialects. Auto-infers column types.

Try it Free →

Features

📊

CSV & JSON Support

Paste CSV data or JSON array. Both formats are parsed correctly.

🏛️

5 Database Dialects

Generate SQL for MySQL, PostgreSQL, SQLite, Oracle, and SQL Server.

📝

Auto Type Inference

Automatically infers column types: INTEGER, VARCHAR, etc. based on the data values.

📋

CREATE TABLE Option

Also generates CREATE TABLE statement with inferred column types.

🔒

Privacy First

All processing is local in your browser. Your data never leaves your device.

📥

Batch Insert

Generate a single INSERT with multiple VALUES for efficient batch inserts.

How to Use

1

Paste Data

Paste your CSV data or JSON array into the input area.

2

Choose Database

Select your target database dialect from MySQL, PostgreSQL, SQLite, Oracle, or SQL Server.

3

Set Table Name

Enter the name for your database table.

4

Generate & Copy

Click Generate to create SQL. Copy the CREATE TABLE and INSERT statements.

Frequently Asked Questions

How does type inference work?
The tool scans your data values to guess types: pure digits become INTEGER, decimal numbers become REAL, dates are detected, and everything else becomes TEXT/VARCHAR.
Can I generate CREATE TABLE too?
Yes. Toggle 'Include CREATE TABLE' to also generate the table definition with inferred column types.
What SQL dialects are supported?
MySQL, PostgreSQL, SQLite, Oracle, and SQL Server. Each has slightly different syntax for types and string escaping.
How are values escaped?
String values are properly escaped for each dialect — single quotes are doubled (' → ''), and special characters are handled correctly.
Is my data sent to a server?
No. All SQL generation is done locally in the browser. Your data never leaves your device.

← Back to pudone! home