qsv

Overview

With more than 50 commands, qsv covers a wide range of CSV-focused work. It is built with Rust and Polars and described as parallel and CPU-accelerated; most commands stream with constant memory, so large files need not be loaded all at once. That design favors batch processing and automation over visual, step-by-step preparation.

qsv requires UTF-8 input, which can rule it out for workflows involving files in other encodings unless those files are converted first. qsv pro adds a graphical desktop app, but visual workflows are not part of the product.

Key features

Formats and querying

Beyond CSV, qsv supports Excel and OpenDocument spreadsheets, JSON and JSONL, DataPackage, Apache Arrow and Parquet, SQLite, and PostgreSQL. Its join, joinp and sqlp commands support complex joins and SQL queries without a separate SQL database. This breadth is useful when source data spans multiple formats, while command-based operation remains central.

Scripting and connections

Built-in Luau and Python scripting can extend transformations and support repeatable tasks. qsv is designed to interoperate with Airbyte, Airflow, Pentaho Kettle and common command-line tools, making it a plausible component in an existing data pipeline rather than a visual workflow builder.

Desktop and CKAN

qsv pro provides a graphical app for viewing and transforming spreadsheet data, based on the qsv CLI. It can also upload and download compatible data from CKAN instances. These additions suit users who want a desktop route into qsv or work with CKAN, but larger spreadsheet imports require a paid plan.

Security and support

The codebase is automatically audited through DevSkim, cargo audit and Codacy GitHub Actions workflows. Prebuilt binary archives are zipsigned, and the self-update mechanism verifies archive integrity before updating. qsv pro users can request support by filing a ticket on the support site.

Pricing

Free

The Free plan costs 0.00 USD per free, requires no license key and includes free recipes, one CKAN instance and qsv slice from Flow. Its spreadsheet import limit is 1MB, so it is a sensible starting point for smaller files or command-line use, but not for larger spreadsheet imports in the desktop app.

Pro

Pro costs 99.99 USD per month after the trial ends, then renews at 99.99 USD every month unless canceled first. It includes one license key for one device at a time, spreadsheet imports larger than 1MB and 16 export formats. That makes it the relevant tier for users whose spreadsheet work exceeds the Free cap; the monthly renewal and single-device license matter for ongoing or shared use.

Business / Enterprise

Business / Enterprise uses custom pricing, with license keys by approved request. It is for organizations that need to discuss licensing beyond the individual Pro arrangement.

Platforms

qsv is available on Linux, macOS, Windows and the web. qsv pro is a desktop application, and the product's deployment is desktop. The command-line orientation will suit users who prefer terminal workflows; readers seeking visual workflow construction should look elsewhere.

Who it's for

qsv fits analysts and data practitioners who need to reshape or inspect structured files, automate repeatable tasks, or process large CSVs without loading them fully into memory. Its scripting, query commands and integration targets add value for teams with established command-line or pipeline practices. It is less suitable for users who need visual workflows or routinely receive non-UTF-8 files.

Pros and cons

• Pro: More than 50 commands and support for many spreadsheet, document, database and columnar formats give command-line users broad options for data preparation.
• Pro: Streaming with constant memory for most commands is useful for large files that would be awkward to load in full.
• Pro: Luau and Python scripting, SQL-style queries and pipeline interoperability support repeatable processing.
• Con: UTF-8 input is required, which limits direct use with files in other encodings.
• Con: The Free plan caps spreadsheet imports at 1MB; larger imports require Pro at 99.99 USD per month after trial.
• Con: Visual workflows are not supported, so users who want a graphical preparation process may find the command-line approach unsuitable.

Alternatives

For more options in the category, browse Data Preparation Software.

• DataCleaner is a free option with Linux, macOS and Windows support; consider it if those platforms and a free plan are the priority.
• EasyMorph offers a free desktop plan with 20 actions and 20 loop iterations per project; it may suit readers who can work within those project limits.
• OpenRefine is free, open source and available as a desktop installation; choose it if that model is a better fit.
• Amazon SageMaker Autopilot is a paid, API- and web-based option with pay-as-you-go pricing and no minimum fees or upfront commitments; consider it if that pricing approach suits your needs.
• Zoho DataPrep has a free plan capped at 20,000 rows per month for one user, with manual imports and exports only; it may fit smaller, manually managed workloads.
• Tableau is a freemium, self-hosted option with paid Creator and Explorer plans; consider it if its self-hosted deployment model fits your requirements.
• Open Data Editor is a free option for Windows, macOS and Linux; consider it if those platforms and a free plan suit your needs.
• csvkit is a free option for Windows, macOS and Linux; consider it as another free choice on those platforms.

Verdict

Choose qsv if you want a command-line data-wrangling toolkit with broad format support, scripting and streaming commands for large files. Its strongest case is repeatable processing across structured formats; look elsewhere if you need visual workflows, non-UTF-8 input, or spreadsheet imports above 1MB without paying for Pro.