Use SQL to Query CSV

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

What can this tool do?

    Query CSV with SQL:
  • Query CSV via SQL and output CSV or JSON results

What else?



Step 1: Select your input


Option 1 - Choose a CSV/Excel file
Encoding
Option 2 - Enter a URL
Option 3 - Paste content into text box below:

 
 

Step 2: Choose input options (optional)


Input Options
Field Separator:



Step 3: Choose output options

Generate SQL via Output Options


         
Or write your own SQL below

Step 4: Write SQL and Run


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





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