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
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

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