QSV

Use qsv from the command line to inspect, transform, and work with CSV and other tabular data.

github.com/dathere/qsv
QSV homepage screenshot

About QSV

QSV is a command-line toolkit for querying, slicing, sorting, filtering, joining, transforming, validating and documenting tabular data such as CSV and Excel files. Its composable commands cover tasks including column transformations, row counts, concatenation, deduplication, date formatting, null-sentinel detection and file hash checking.

Some capabilities have specific requirements. Additional formats such as Arrow, Parquet and JSON need the "polars" feature, LLM-assisted summarization and description use an OpenAI API-compatible LLM, and numeric sentinels such as -999 are not treated as nulls.

Key features

  • Apply string, date, math and currency transformations to columns
  • Concatenate CSV files by row or by column
  • Remove duplicate rows from CSV files
  • Count rows and record width statistics, faster with index
  • Format recognized date fields using strftime specifiers
  • Detect text null sentinels and optionally blank them
Best for: People who inspect, transform and document CSV and other tabular data from the command line.
Good for
  • Covers querying, joining, validating and documenting tabular data in one command-line toolkit
  • Commands are described as simple and composable
  • Can work with additional formats such as Parquet and JSON when polars feature is enabled
Watch out for
  • Numeric sentinels such as -999 are not detected as null values
  • LLM-assisted description and summarization require an OpenAI API-compatible LLM
  • Support for Arrow, Parquet and JSON formats depends on the polars feature

QSV at a glance

Type
Open-source project
Pricing
Not confirmed. Check the site
Open source
Not stated
Language
English
Last checked
Oct 5, 2026 · Online when checked
Listed
Oct 5, 2026

QSV alternatives

Tools and sites you could use instead, ranked by how closely they match.

All 8 alternatives

NimbleText

nimbletext.com/Live

NimbleText provides text and data transformation tools with pattern, row, and column controls shown in its editor.

Glow

github.com/charmbracelet/glow

Read Markdown files in the command line with Glow, which renders the formatted document in the terminal.

Open source
24 alternatives

Popular in Text Editors

Well-known listings from the same topic.

All 166

QSV FAQ

What types of data does qsv work with?
Tabular data such as CSV and Excel files.
Does denull detect numeric placeholders like -999?
No. Numeric sentinels are deliberately not detected because they parse as valid numbers.
What does the LLM-assisted description need?
A configurable MiniJinja prompt file and an OpenAI API-compatible cloud or local LLM.
Is something wrong or out of date?

Tell us and an editor will check it.

Own this website?

Claim the listing and suggest updates yourself. An editor checks every claim first.

Claim this listing