qsv

qsv is a command-line toolkit for slicing, analyzing and transforming structured data, best suited to people who build repeatable workflows around data files. Its streaming operations and broad format support make it a strong fit for large-scale wrangling, though UTF-8-only input and a small free spreadsheet-import allowance limit its reach.

Overview

More than 50 commands cover slicing, analysis and transformation. Built with Rust and Polars, qsv is designed for parallel, CPU-accelerated work; most commands stream with constant memory, making it practical to process arbitrarily large CSV files without loading each one into memory. That favors scripted batch work over visual, step-by-step preparation.

qsv requires UTF-8 input, a real constraint for teams receiving data in other encodings. The qsv pro desktop app adds a graphical way to view and transform spreadsheet data, but visual workflows are not part of the toolkit itself.

Key features

Formats and queries

Support extends beyond CSV to Excel, OpenDocument Spreadsheet, JSON and JSONL, DataPackage, Apache Arrow and Parquet, SQLite, and PostgreSQL. The join, joinp and sqlp commands handle complex joins and SQL-style queries without a SQL database. This breadth is useful when a workflow draws on varied sources, while command-based operation remains central.

Scripting and interoperability

Built-in Luau and Python support lets users script transformations. qsv is also designed to work alongside Airbyte, Airflow, Pentaho Kettle and common command-line tools, making it a plausible component in an existing data pipeline rather than a standalone visual preparation environment.

Desktop, CKAN and security

qsv pro wraps the CLI in a desktop app for spreadsheet viewing and transformation, and can upload and download compatible data from CKAN instances. The codebase is automatically audited through DevSkim, cargo audit and Codacy GitHub Actions workflows. Prebuilt binary archives are zipsigned, and self-updates verify archive integrity. These measures address code and update integrity, but do not change the UTF-8 input requirement.

Pricing

The Free plan costs nothing, requires no license key, and includes free recipes, one CKAN instance, qsv slice from Flow, and spreadsheet imports up to 1MB. That is a useful way to try the toolkit and handle small spreadsheet imports, but the cap can rule it out for ordinary larger files in the desktop app.

Pro costs $99.99 a month. After the trial ends, the charge is $99.99 and then $99.99 every month unless canceled first. One license key works on one device at a time; Pro supports spreadsheets larger than 1MB and includes 16 export formats. It is the relevant tier for users whose spreadsheet files exceed the Free cap, though the monthly price is a substantial step up from a free toolkit.

Business / Enterprise has custom pricing: license keys are provided by approved request, and users are directed to contact the maker. A free trial is available. Pro users can request support by creating a ticket on the support site.

Platforms

qsv is available on Linux, macOS, Windows and the web. Its deployment is desktop, and qsv pro provides the graphical desktop application; users seeking visual workflows should note that the product does not offer them.

Who it's for

qsv suits analysts and data practitioners comfortable with command-line work who need to automate transformations, join data, or process large CSV files with constant-memory streaming. Its format range and scripting support broaden its usefulness in data pipelines. It is a weaker fit for users whose source files are not UTF-8, who want a visual workflow, or who need to import spreadsheets larger than 1MB without paying for Pro.

Pros and cons

Pros: Most commands stream with constant memory, so very large CSV files are not automatically a memory bottleneck.

Pros: Support for spreadsheets, structured-data formats and databases, plus SQL-style queries, reduces the need to move every task into a separate tool.

Pros: Built-in Luau and Python scripting and interoperability with pipeline tools support repeatable data work.

Cons: Input must be UTF-8, excluding files in other encodings until they are converted.

Cons: The Free plan caps spreadsheet imports at 1MB; larger imports require Pro at $99.99 a month.

Cons: Visual workflows are not offered, despite the graphical qsv pro desktop app.

Alternatives

For a wider directory of options, see Data Preparation Software. Choose EasyMorph instead if its free desktop plan’s limits of 20 actions per project and 20 loop iterations per project better suit a restricted visual-preparation workflow. CSV Engine is a web alternative with a free allowance of five credits a month and three active templates, limited to text and email fields. Pick OpenRefine for free, open-source desktop software when its listed platform range, including self-hosted and web, fits better.

Zoho DataPrep offers a free tier capped at 20,000 rows a month for one user, with manual imports and exports only and one month of audit retention. csvkit is a free, MIT-licensed option for Linux, macOS and Windows with no paid tiers stated. DataCleaner is another free, LGPL-licensed option for those platforms. Alteryx Designer may suit teams seeking a paid cloud-only Starter plan at $250 a month billed annually, for 1–10 seats and CSV, XLSX or JSON file sources.

Verdict

Choose qsv if you need a command-oriented toolkit for broad-format data wrangling, SQL-style querying and large CSV processing without constant-memory pressure. Its main advantage is the reach of its streaming and scripting toolkit; look elsewhere if UTF-8 input, command-line workflows or the cost of Pro’s spreadsheet-import capacity do not fit your work.