CSV to Delimited CSV to Flat File CSV to GeoJSON CSV to HTML Table CSV to JSON CSV to KML CSV to Markdown CSV to PDF CSV to SQL CSV to XML CSV to YAML

Flat File to CSV GeoJSON to CSV HTML Links to CSV HTML Table to CSV JSON to CSV KML to CSV SQL to CSV XML to CSV YAML to CSV

CSV Escape Tool CSV Pivot Tool CSV Viewer and Editor CSV Transpose Tool CSV Template Engine Generate Test Data Email Extractor Phone Number Extractor URL Extractor Query CSV Split PDF

Restore Data

You can save the complete data and settings, and then load them from your saved file.

Choose File

Convert CSV to SQL

Use this tool to convert CSV to SQL.

Step 1: Choose Your Input Method

Paste/Enter Data
Choose File
Enter URL

Enter or paste CSV:

First row is column names

Get CSV data from file:

Drag and drop your file or click here

Encoding:

Enter URL as data source and press Load URL:

Field Separator Options:

Auto Detect

Caret ( ^ )

Space

;

Bar ( | )

Tab

Line Options:

Limit number of lines:

Skip number of lines:

Other Options:

Replace Accents/Diacriticals

Treat Quoting Characters as Data

Input Quoting Characters is Apostrophe

CSV contains backslash escaping

Step 2: Generate Output

Display & Sorting Options:

Display which field positions? (Comma separated list where 1 is 1st field, 2=2nd,... i.e. 2,1,3,4):

Ignore Case

	Field #	Type	Direction
First By
Then By
Then By

SQL Options:

Keep original field names as column names

NOTE - you can change the column names below by overwriting the Field Name value.

Enclose field names below with:

Quotes ("name")

Backtick (`name`)

Brackets ([name])

Schema.Table or View Name:

Drop Table/View

IF EXISTS

Create Table/View

IF NOT EXISTS

Include Auto Increment Clause on single numeric Primary Key using:

For INSERT:

Use REPLACE instead (REPLACE INTO tablename ....)

Use one INSERT/REPLACE statement with multiple VALUES clauses -

How many?:

Add phrase after INSERT/UPDATE keyword (INSERT phrase INTO ...):

SELECT and MERGE:

System TABLE needed to SELECT from?

Table Name:

Batch how many rows together via UNION ALL? Valid if not creating VIEW for SELECT:

Escape SQL Strings With Backslash (MySql style)

NULL value:

Output Format for Dates See Moment.js:

Choose Conversion Format:

Converted Data:

Save Results:

.json

EOL: