CSV
CSV Tools

Convert CSV to SQL

Generate SQL INSERT statements from CSV data

CSV Input

SQL

SQL output will appear here...

Options

CSV Format

SQL Table

SQL Output

How to Use This Tool

This tool generates SQL statements from CSV data directly in your browser. No data is uploaded or sent to any server.

You can provide CSV input in three ways: paste it directly, upload a file, or fetch it from a URL. The SQL output updates in real time as you make changes.

  1. Provide your CSV — Paste CSV text into the input area, drop a CSV file onto the File tab, or enter a URL on the URL tab to fetch remote data.
  2. Configure options — Open the Options panel to adjust CSV parsing settings, choose your database type, set the table name, and toggle CREATE TABLE, DROP TABLE, and batch insert modes.
  3. Get your SQL — Copy the SQL output to your clipboard or save it as a .sql file using the buttons above the output preview.

FAQ

5 questions
Does this CSV to SQL converter upload my data?
No. All conversion happens entirely in your browser using JavaScript. Your CSV data never leaves your device — no server receives, stores, or processes it.
Which databases are supported?
You can generate SQL for SQLite, MySQL, and PostgreSQL. The tool adjusts identifier quoting, type names, and boolean literals to match each database's syntax.
How are column types detected?
The tool scans all values in each column. If every non-empty value is an integer, it uses INTEGER. If all values have decimal points, it uses REAL/DOUBLE/NUMERIC. If all values are true/false, it uses BOOLEAN. Otherwise it defaults to TEXT or VARCHAR.
What happens with empty cells?
Empty CSV cells are output as NULL in the generated SQL. They are also skipped during type detection, so a column with some empty cells and some integers will still be detected as INTEGER.
What is the difference between batch and per-row inserts?
Batch insert generates a single INSERT statement with all rows in one VALUES clause. Per-row insert generates a separate INSERT statement for each row. Batch mode produces more compact output.

More Conversion Tools

30 tools

CSV to JSON

Convert CSV files to clean, structured JSON

CSV to XML

Transform CSV into well-formed XML documents

CSV to JSON Lines

Convert CSV rows into newline-delimited JSON (JSONL/NDJSON)

CSV to YAML

Transform CSV data into clean, readable YAML documents

CSV to TSV

Convert comma-separated values to tab-separated format

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

CSV to Markdown

Convert CSV data into GitHub-flavored Markdown tables

CSV to Fixed Width

Convert CSV data into fixed-width column format

JSON to CSV

Soon

Convert JSON arrays to downloadable CSV

CSV to Excel

Soon

Export CSV data to .xlsx spreadsheets

Excel to CSV

Soon

Import .xlsx files and convert to CSV

TSV to JSON

Soon

Convert tab-separated data into structured JSON output

CSV to QBO

Soon

Convert CSV bank transactions into QuickBooks Online format

CSV to vCard

Soon

Transform CSV contact lists into vCard (.vcf) files

CSV to QIF

Soon

Convert CSV financial data into Quicken Interchange Format

CSV to VCF

Soon

Export CSV contacts as VCF files for email and phone import

CSV to TXT

Soon

Convert CSV data into plain text with customizable formatting

CSV to IIF

Soon

Convert CSV transactions into Intuit Interchange Format for QuickBooks

CSV to KML

Soon

Generate KML geographic data files from CSV coordinates

CSV to YNAB

Soon

Convert CSV bank statements into YNAB-compatible import format

CSV to Base64

Soon

Encode CSV data as a Base64 string for safe transport

CSV to SPSS

Soon

Convert CSV datasets into SPSS-compatible format for statistical analysis

CSV to SAS

Soon

Transform CSV data into SAS dataset format

CSV to Stata

Soon

Convert CSV data into Stata .dta format for econometric analysis

CSV to ORC

Soon

Convert CSV into Optimized Row Columnar format for big data

CSV to Feather

Soon

Convert CSV into Apache Arrow Feather format for fast analytics

CSV to Parquet

Soon

Convert CSV into columnar Parquet format for efficient storage

CSV to LaTeX

Soon

Generate LaTeX table markup from CSV data

CSV to Xero

Soon

Convert CSV bank statements into Xero-compatible import format

CSV to OFX

Soon

Convert CSV financial data into Open Financial Exchange format

More CSV Tools

40 tools

CSV to JSON

Convert CSV files to clean, structured JSON

CSV to XML

Transform CSV into well-formed XML documents

CSV to JSON Lines

Convert CSV rows into newline-delimited JSON (JSONL/NDJSON)

CSV to YAML

Transform CSV data into clean, readable YAML documents

CSV to TSV

Convert comma-separated values to tab-separated format

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

CSV to Markdown

Convert CSV data into GitHub-flavored Markdown tables

CSV to Fixed Width

Convert CSV data into fixed-width column format

CSV Viewer

Soon

View and explore CSV files in a sortable table

Merge CSVs

Soon

Combine multiple CSV files into one

Column Stats

Soon

Get min, max, mean, and distribution per column

JSON to CSV

Soon

Convert JSON arrays to downloadable CSV

Split CSV

Soon

Break large CSVs into smaller chunks

CSV Editor

Soon

Edit cells, add rows, and fix data inline

CSV to Excel

Soon

Export CSV data to .xlsx spreadsheets

Data Profiler

Soon

Automatic data type detection and quality report

Excel to CSV

Soon

Import .xlsx files and convert to CSV

Remove Duplicates

Soon

Find and eliminate duplicate rows

Row Counter

Soon

Quick count of rows, columns, and empty cells

Sort CSV

Soon

Sort rows by any column, ascending or descending

Filter Rows

Soon

Keep only rows that match your criteria

TSV to JSON

Soon

Convert tab-separated data into structured JSON output

CSV to QBO

Soon

Convert CSV bank transactions into QuickBooks Online format

CSV to vCard

Soon

Transform CSV contact lists into vCard (.vcf) files

CSV to QIF

Soon

Convert CSV financial data into Quicken Interchange Format

CSV to VCF

Soon

Export CSV contacts as VCF files for email and phone import

CSV to TXT

Soon

Convert CSV data into plain text with customizable formatting

CSV to IIF

Soon

Convert CSV transactions into Intuit Interchange Format for QuickBooks

CSV to KML

Soon

Generate KML geographic data files from CSV coordinates

CSV to YNAB

Soon

Convert CSV bank statements into YNAB-compatible import format

CSV to Base64

Soon

Encode CSV data as a Base64 string for safe transport

CSV to SPSS

Soon

Convert CSV datasets into SPSS-compatible format for statistical analysis

CSV to SAS

Soon

Transform CSV data into SAS dataset format

CSV to Stata

Soon

Convert CSV data into Stata .dta format for econometric analysis

CSV to ORC

Soon

Convert CSV into Optimized Row Columnar format for big data

CSV to Feather

Soon

Convert CSV into Apache Arrow Feather format for fast analytics

CSV to Parquet

Soon

Convert CSV into columnar Parquet format for efficient storage

CSV to LaTeX

Soon

Generate LaTeX table markup from CSV data

CSV to Xero

Soon

Convert CSV bank statements into Xero-compatible import format

CSV to OFX

Soon

Convert CSV financial data into Open Financial Exchange format