CSV Query 1.2.6
CSV Query : A Notepad++ plugin that enables you to execute SQL queries against opened CSV files using the standard syntax of the SQL languageCSV is a popular file format that can store tabular data in a structured manner, which is fit for tables in spreadsheets or database contents. Notepad++ offers support for opening CSV files but manipulating data in a way similar to a dedicated CSV editor is not possible. Fortunately, this issue can be addressed using a simple plugin that goes by the name of CSV Query.
A built-in SQL query window in Notepad++
Installing CSV Query is extremely easy, as you just have to place the DLL file in the "Plugins" folder of Notepad++ and the editor detects it automatically, displaying it in the dedicated menu after restart.The query window is only visible if you toggle it active. CSV Query parses the content of the CSV file in focus based on a separator. It can recognize quotes inside text prefix and comments, column types, as well as first-row headers. If automatic detection fails, you are prompted to customize these settings.Uses the standard SQL syntax to run queries against CSV files
At first, CSV Query executes a simple SQL query to select all the data in the input file (SELECT * FROM this). You will notice that the data is then displayed as a table in the CSV Query window.Provided you are familiar with the standard SQL syntax of SQLite, you can use CSV Query to execute all kinds of queries against the data in the CSV file. The reason that this is possible is that the CSV data is migrated to an in-memory SQLite or MSSQL database.Execute SQL queries in Notepad++
If you store large data sets in CSV files, CSV Query can become a real asset. Not just that it enables you to view the data in an organized table, but it also allows you to execute SQL queries against the CSV database, extracting rows that match the criteria in the query.Conclusion
To conclude CSV Query works on Windows operating system(s) and can be easily downloaded using the below download link according to GPLv3 license. CSV Query download file is only 314 KB in size.CSV Query was filed under the Word Processing category and was reviewed in softlookup.com and receive 4.9/5 Score.
CSV Query has been tested by our team against viruses, spyware, adware, trojan, backdoors and was found to be 100% clean. We will recheck CSV Query when updated to assure that it remains clean.
CSV Query user Review
Please review CSV Query application and submit your comments below. We will collect all comments in an effort to determine whether the CSV Query software is reliable, perform as expected and deliver the promised features and functionalities.Popularity 9.8/10 - Downloads - 96 - Score - 4.9/5
Softlookup.com 2023 - Privacy Policy
| Category: | Word Processing |
| Publisher: | jokedst |
| Last Updated: | 3/11/2023 |
| Requirements: | Not specified |
| License: | GPLv3 |
| Operating system: | Windows |
| Hits: | 498 |
| File size: | 314 KB |
| Price: | Not specified |
| Name: * |
E-Mail: * |
| Comment: * |
|