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?



NEW -You can now Save the complete data and settings, and then later Load them from your saved file.
 

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 ?. SQL documentation at AlaSQL.org
Choose Conversion Type:


Blue Hosting