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

Query CSV with SQL

Use the tool on this page to write SQL to query CSV data

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

Field Separator:

;

Bar

Tab

Other:

Generate CSV via Output Options:

Output Format:

CSV(Delimited)

JSON

Replace value of NULL in CSV with an empty value

Include header in first row

See Output Options above for help with writing SQL
Note - Column names are case-sensitive. Table name is ?. INTO CSV() produces CSV, JSON is produced without it.
SQL documentation available at AlaSQL.org

Or write your own SQL below

Converted Data:

Output Table:

Save Results:

EOL: