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 Query alternatives ➤

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.

Official Links

Official Website
github.com/jokedst/CsvQuery

The Best CSV Query Alternatives

Top Apps like CSV Query

LibreOffice - Base, EmEditor, CSVed, ReCsvEditor, Csv Easy, CSV Quick Viewer, Delimit, CSVFileView, Apache OpenOffice Base, Easy CSV Editor, Table Tool, Table Editor, CSVpad, CSVboard, dmcsveditor, CSV Buddy, DB-Text, csvsql, nView for Mac are some alternatives to CSV Query.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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