Query CSV with SQL - write SQL to query CSV data

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

Result Data:

Save your result:EOL:

You can Save the complete data and settings, and then later Load them from your saved file.
Load Saved Form
Save Form (data and settings)