Query CSV with SQL

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

Query CSV with SQL:

Choose File Encoding

Enter URL as data source

Input Options

First row is column names

Limit # of lines: Skip # of Lines

Field Separator:

Auto Detect , ; : Bar-| Tab Caret-^ Space

Replace Accents/Diacriticals

Treat all Quoting Character as data

Input CSV Quoting Character is Apostrophe

CSV contains backslash escaping like \n, \t, and \,

Generate SQL via Output Options Replace value of NULL in CSV with an empty value

Output Format: CSV(Delimited) JSON
Display Output Header on CSV
Output Field Separator on CSV: , ; : Bar-| Tab Other-Choose

Or write your own SQL below

Note - Table name is ?. INTO CSV() produces CSV, JSON is produced without it.
SQL documentation available at AlaSQL.org

Result Data:

Save your result: EOL:

Save the complete data and settings, and then later Load them from your saved file.

Load Form
Save Form (data and settings)