+1 732 707 1866

qsv pro

Your ultimate CSV and spreadsheet data wrangling toolkit

Your ultimate CSV and spreadsheet data wrangling toolkit

Transform and upload spreadsheet data to CKAN with our streamlined desktop app, featuring “recipes” for common data wrangling tasks. Based on the qsv CLI tool.

Blazing-Fast Data Wrangling!

qsv is a blazing fast, pleasingly parallel, CPU-accelerated, data-wrangling toolkit

More Than Just CSVs

Designed with composability in mind, qsv can work with many tools in your Data Wrangling Library

50+ Commands for Daily Tasks

A whole library of practical commands informed by decades of work dealing with messy data from disparate sources

No Programming Required

You don’t need to program to wrangle your data at scale. But if necessary, there’s built-in support for Luau and Python.

Drag & Drop your data into qsv pro.

You can drag and drop a spreadsheet file anywhere within the Workflow section to import your data and begin exploring it in a data table.

  • File formats: .csv, .xlsx, .tsv, .tab, .xls, .ods, .xlsm, .xlsb    
  • Supports large spreadsheets with millions of rows
  • Begins scanning and analyzing your data on import
  • Generates stats, frequency, and file metadata

Transform your data with recipes

qsv pro features a suite of recipes (scripts) for common data wrangling tasks to perform on your spreadsheet, including:

  • Sort in lexicographical order
  • Remove duplicate rows
  • Remove rows with Personally Identifiable Information (PII)

Upload your data to a CKAN instance

qsv pro allows you to upload your transformed data to a CKAN instance within an organization and dataset as a resource.

  • Integrated with the CKAN API (>= 2.9)
  • Search through organizations, datasets, and resources
  • Create a new resource or overwrite existing resources

Run Polars SQL queries on your data

Using qsv’s built-in sqlp command, qsv pro leverages Polars so you may run SQL queries to learn more insights from your spreadsheet data.

  • Run Polars SQL queries your spreadsheet data
  • View query output in a data table
  • Get the estimated elapsed time for your queries

Run qsv terminal commands with the Configurator GUI

No need to run qsv commands in your terminal. Try out our qsv Configurator graphical user interface (GUI)* as an interactive way to run qsv without the need to use a command line interface (CLI).

Download and try qsv pro!

Transform your organization into a data-driven powerhouse.