qsv

qsv is a CSV data-wrangling toolkit built around a command-line interface. It suits analysts and data practitioners who are comfortable with commands and need to transform large files or automate repeatable work. Its breadth and streaming design are compelling, but the 1MB spreadsheet-import cap on the free plan makes the paid tier important for many desktop users.

Overview

With more than 50 commands for slicing, analyzing and transforming data, qsv covers a wide range of structured-data tasks. Its performance-oriented design, built with Rust and Polars, uses parallel and CPU-accelerated processing; most commands stream data with constant memory, so file size need not determine whether a task is practical.

The trade-off is a command-line-first workflow. qsv pro adds a graphical desktop app, but visual workflows are not part of the product. Input must be UTF-8 encoded, a meaningful constraint when working with files in other encodings.

Key features

Broad format and query support

qsv works with CSV, Excel and OpenDocument spreadsheets, as well as JSON and JSONL, DataPackage, Apache Arrow and Parquet, SQLite, and PostgreSQL. Its join, joinp and sqlp commands bring complex SQL and join queries to the toolkit without requiring a SQL database. That makes it versatile for users who want to combine and reshape data from different sources in scripts.

Automation and integrations

Built-in Luau and Python scripting extend the command set for custom work. qsv is also designed to interoperate with Airbyte, Airflow and Pentaho Kettle, as well as common command-line tools. These are strengths for pipeline-oriented users; they do not replace a graphical workflow builder.

Desktop and CKAN options

qsv pro provides a graphical app for viewing and transforming spreadsheet data, based on the CLI, and can upload and download compatible data from CKAN instances. The free plan includes one CKAN instance, while Pro offers a paid route for larger spreadsheets and the desktop experience.

Security and support

Automated security checks use DevSkim, cargo audit and Codacy GitHub Actions workflows. Prebuilt binary archives are zipsigned, and the self-update mechanism verifies archive integrity before updating. Pro users can request support by submitting a ticket.

Pricing

Free

The Free plan costs nothing, requires no license key, and includes free recipes, one CKAN instance and qsv slice from Flow. Spreadsheet imports are limited to 1MB. It is a sensible starting point for command-line work and smaller spreadsheet imports, but that cap can rule it out for users handling larger spreadsheets.

Pro

Pro costs $99.99 a month. After the trial ends, the charge is $99.99 and renews at $99.99 every month unless canceled first. One license key covers one device at a time. Pro supports spreadsheets larger than 1MB and includes 16 export formats, alongside the graphical desktop app and CKAN upload and download. It is the relevant tier for users who need those capabilities, though the monthly price is a substantial commitment for occasional work.

Business / Enterprise

Business / Enterprise has custom pricing, with license keys available by approved request. It is an option for organizations that need to discuss licensing rather than use the individual plans.

Platforms

qsv is available on Linux, macOS and Windows, with a web platform also listed. Its deployment is desktop. The command-line toolkit is the core; qsv pro supplies the graphical desktop application.

Who it's for

Choose qsv if you need a broad, scriptable toolkit for structured data, especially when streaming large CSV files or integrating transformations into command-line and data-pipeline work. Its support for many formats and SQL-style queries adds range without requiring a database for those operations.

Look elsewhere if your priority is building visual workflows, if you need input that is not UTF-8, or if you want a graphical spreadsheet experience without paying Pro pricing. The free plan remains useful, but the spreadsheet import limit sharply separates it from the paid desktop offering.

Pros and cons

• Pros: More than 50 commands, broad format support and built-in Luau and Python scripting make qsv adaptable to varied data-wrangling tasks.
• Pros: Most commands stream with constant memory, making large-file processing practical without memory use growing with the file.
• Pros: SQL and join commands, plus integrations with Airbyte, Airflow and Pentaho Kettle, suit automated and pipeline-based work.
• Cons: The free plan limits spreadsheet imports to 1MB, putting larger imports behind a $99.99 USD monthly Pro subscription.
• Cons: qsv requires UTF-8 input, which excludes files in other encodings unless they are converted first.
• Cons: There are no visual workflows; users seeking that style of data preparation will need another tool.

Alternatives

Data Preparation Software is the broader category for comparing tools in this space.

• EasyMorph is worth considering if its free desktop plan, with 20 actions and 20 loop iterations per project, fits your workflow; it also offers API, self-hosted and web platforms.
• OpenRefine is a free, open-source desktop option for users who want BSD 3-clause licensed software across Linux, macOS and Windows, as well as self-hosted and web platforms.
• DataCleaner is a free, open-source community edition under LGPL for users who want a Linux, macOS or Windows option.
• Tableau is an alternative with a free plan and paid Creator and Explorer tiers; its listed platform is self-hosted.
• Zoho DataPrep may suit users who prefer API or web access; its free plan allows 20,000 rows per month for one user, with manual imports and exports and one month of audit retention.
• Open Data Editor is another free option for Windows, macOS and Linux.
• csvkit is another free option for Windows, macOS and Linux.
• CSV Engine is a freemium alternative with a free plan and a web platform.

Verdict

qsv is a strong choice for command-line users who need fast, broad and scriptable data transformations, particularly on large files. Its streaming approach and format range are the main reasons to choose it; the UTF-8 requirement, lack of visual workflows and steep Pro price are the reasons to look elsewhere. Start with Free for smaller spreadsheet imports, and choose Pro only if the larger-import allowance, graphical app or CKAN capabilities justify the recurring cost.