Executing SQL Queries in Notepad++ using CSVQuery

In order to run queries against .csv files in Notepad++ you will need to first make sure to get the CSVQuery Plugin installed using Plugin Admin.

Once you have the plugin installed, you should find it under Menu: Plugins > CSVQuery

The first thing you do is open your CSV file and open "Toggle CSV Query Window"

Let's take a simple .csv file.

Now you can execute queries under "CSV Query" as follows.

Examples:

The data is stored in an SQLite database, so you can run simple SQL queries against the tables named "THIS".

SELECT * FROM THIS

SELECT * FROM THIS WHERE Day>=1

SELECT * FROM THIS WHERE Day>=1 AND Visits > 2000