CSV Query
CSV Query is an open-source tool for querying and manipulating CSV files. It allows users to slice, filter, aggregate, transform and visualize CSV data without writing code.
csv
data-analysis
data-manipulation
CSV Query: Open-Source Tool for Querying and Manipulating CSV Files
An open-source tool allowing users to slice, filter, aggregate, transform and visualize CSV data without writing code.
What is CSV Query?
CSV Query is an open-source command-line tool for querying and manipulating CSV files. It provides a SQL-like language specifically designed for CSV data that allows users to slice, filter, aggregate, transform, and visualize data from CSV files without writing any code.
With CSV Query, users can perform data analysis tasks such as:
- Filtering rows and columns using conditional logic
- Calculating aggregates like sums, averages, counts etc.
- Joining multiple CSV files
- Pivoting data from long to wide format
- Applying transformations like uppercasing strings or concatenating columns
- Generating charts and graphs from CSV data
The query language is easy to learn but provides powerful functionality similar to spreadsheet software. However, it runs on the command-line instead of needing a graphical interface, making it lightweight and convenient for programmers. It can handle very large CSV datasets without running into memory issues.
CSV Query can save significant time compared to analyzing CSVs in other programs. It is also extendable via a plugin system for custom data processing tasks.
CSV Query Features
Features
- Query CSV files using SQL-like syntax
- Filter, aggregate, join, sort CSV data
- Output results to CSV or JSON format
- Visualize data using charts
- Support for large CSV files
Pricing
- Open Source
- Free
Pros
Simple to use for basic CSV tasks
No coding required
Cross-platform (Windows, Mac, Linux)
Lightweight and fast
Free and open source
Cons
Limited to CSV files only
Less flexibility than coding
Basic visualization options
Lacks some advanced SQL features
Official Links
The Best CSV Query Alternatives
Top Office & Productivity and Data Analysis and other similar apps like CSV Query
Here are some alternatives to CSV Query:
Suggest an alternative ❐
LibreOffice - Base
LibreOffice Base is a free and open source database management application included as part of the LibreOffice software suite. It provides tools for creating, accessing, and managing SQL databases without the need for any additional database software.Some of the key features of LibreOffice Base include:Graphical database design tools for creating...
EmEditor
EmEditor is a fast, lightweight, yet highly extensible text editor for Windows. Originally developed in 2000 by Yutaka Emura, it aims to provide much of the functionality of heavyweight editors like Notepad++ but with a minimalist, easy-to-use interface.Despite its simple appearance, EmEditor packs rich features that power users require. This...
CSVed
CSVed is a free, open-source CSV (comma-separated values) file editor for Windows. It provides an intuitive interface for working with CSV data.With CSVed, you can:Quickly open, view, and edit large CSV filesFilter CSV rows using complex criteriaMerge multiple CSV files togetherSplit one big CSV file into multiple filesConvert to/from CSV...
ReCsvEditor
ReCsvEditor is a free, open source CSV (comma-separated values) file editor for Windows. It provides a spreadsheet-like interface for working with CSV data, allowing you to easily view, edit, modify, search, sort, filter, import and export CSV files.Some key features of ReCsvEditor include:Opens and edits CSV files of any sizeSupports...
Csv Easy
Csv Easy is a free web-based application for working with CSV (comma-separated values) files. It provides an easy-to-use interface for editing, converting, merging, and sharing CSV data.With Csv Easy you can:Import CSV files from your computer or cloud storageEdit CSV data directly in the app - add, delete, reorder rows...
CSV Quick Viewer
CSV Quick Viewer is a powerful yet easy-to-use application for working with CSV (comma-separated values) files. As an open-source program, it is completely free to download and use.With CSV Quick Viewer, you can quickly open and explore CSV datasets containing up to 1 million rows of data. It provides a...
Delimit
Delimit is a free Windows application designed to help users easily separate text into columns or extract data from text files. Some key features include:Intuitive interface for specifying one or more delimiter characters to split text data into columns.Live preview allowing you to see exactly how your text will be...
CSVFileView
CSVFileView is a lightweight, free, and open-source CSV file viewer for Windows. It provides a simple and convenient way to view and analyze CSV data without needing to import into another program.CSVFileView allows you to quickly browse through large CSV files, search for specific data, sort rows, visualize data in...
Apache OpenOffice Base
Apache OpenOffice Base is a free and open source database management application. It is an integral part of the Apache OpenOffice software suite, which also includes a word processor, spreadsheet, presentation program, and drawing application.Base allows users to easily create, modify, and query databases without needing to understand SQL or...
Easy CSV Editor
Easy CSV Editor is a feature-rich application designed specifically for working with CSV (comma-separated values) files. It provides a simple yet powerful interface for managing, editing, converting, cleaning, and analyzing CSV data.Some of the key features of Easy CSV Editor include:Intuitive spreadsheet-style interface for editing CSV contentsFind & replace tool...
Table Tool
Table Tool is a browser extension available for Chrome, Firefox, and Edge that provides additional functionality for tables displayed on webpages. It enhances existing tables by adding features like sorting, filtering, resizing columns, highlighting cells, applying formulas, and more, without requiring editing of the actual webpage content.Once installed, Table Tool...
Table Editor
Table Editor is a feature-rich software application designed specifically for working with tables within documents, spreadsheets, presentations, web pages, and more. It provides users with an intuitive interface and advanced capabilities to create, modify, rearrange, style, and format tables with ease.Key features of Table Editor include:Add, delete, merge, split, distribute,...
CSVpad
CSVpad is a free, open-source CSV (comma-separated values) editor for Windows. It provides a simple and intuitive interface for working with CSV data.With CSVpad you can:Quickly open large CSV files up to 2GB in sizeView, search and browse through CSV dataSort, filter, edit and modify CSV contentsAnalyze CSV files with...
CSVboard
CSVboard is an open-source business intelligence and data visualization tool designed specifically for CSV data. It allows users to easily explore, analyze, and visualize data from CSV files without the need for any coding or prior technical knowledge.With its simple drag-and-drop interface, users can quickly build a variety of charts...
Dmcsveditor
dmcsveditor is a free, open-source CSV (comma-separated values) editor for Windows. It provides a simple but powerful interface for viewing, editing, and manipulating CSV data files.With dmcsveditor, you can easily:Open, edit, and save CSV filesFind and replace textFilter rows to hide/show only relevant dataSort rows by one or multiple columnsUse...
CSV Buddy
CSV Buddy is a powerful, easy-to-use CSV editor for Windows. It allows you to easily view, edit, filter, merge, split, and convert CSV (comma-separated values) and plaintext files.With its simple and intuitive interface, CSV Buddy makes working with CSV data fast and efficient. Simply open up your CSV files and...
DB-Text
DB-Text is an open source document-oriented database that is optimized for storing and managing text or documents. It is built on top of the SQLite database engine and provides the following key features:Full-text search - It supports full-text indexing and searching of documents using SQLite FTS modules.Real-time indexes - Indexes...
Csvsql
csvsql is an open-source command-line tool that allows you to execute SQL queries on CSV files without the need to load them into a database first. It supports most common SQL operations like SELECT, JOIN, GROUP BY, ORDER BY etc. making it easy to analyze and manipulate CSV data.Some key...
NView for Mac
nView for Mac is virtual desktop management software designed to help organize your workflow by extending your desktop area across multiple virtual desktops. It allows you to group applications and documents logically, minimizing clutter while making it easy to switch between tasks.With nView, you can create up to 9 additional...
