xsv

Display CSV headers

$ xsv headers [file.csv]

$ xsv select [Name,Age] [file.csv]

$ xsv table [file.csv]

$ xsv stats [file.csv]

$ xsv search "[pattern]" [file.csv]

$ xsv sort -s [column] [file.csv]

$ xsv count [file.csv]

$ xsv sample [10] [file.csv]

xsv command [options] [input]

xsv is a fast CSV command-line toolkit written in Rust. It provides commands for indexing, slicing, analyzing, splitting, and joining CSV files with excellent performance on large datasets.
The tool creates indexes to enable fast random access and statistics gathering. Commands are designed to be composable through Unix pipes while maintaining high performance.
xsv handles various CSV dialects and can work with different delimiters, quoting styles, and files with or without headers.

cat

Concatenate CSV files by row or column.

Count the rows in a CSV file.

Force all rows to have the same length.

Show each row on a single line.

Format CSV output (delimiter, quoting).

Show frequency tables for columns.

Display column headers.

Create an index for fast random access.

Read CSV data with special handling.

Join two CSV files on a column.

Randomly sample rows.

Search rows matching a regex pattern.

Select specific columns.

Slice rows from the CSV.

Sort rows by columns.

Split CSV into multiple files.

Compute statistics for columns.

Format as aligned ASCII table.

Field delimiter (default: comma).

Input has no header row.

Write output to file.

xsv is optimized for well-formed CSV files. Malformed input may produce unexpected results. Creating an index with xsv index significantly speeds up subsequent operations on large files.

xsv was created by Andrew Gallant (BurntSushi) and first released in 2014. It was developed as a demonstration of Rust's performance capabilities for command-line tools and CSV processing. The project has influenced the design of other Rust CSV tools and established patterns for high-performance CSV processing.

csvkit(1), miller(1), awk(1), cut(1)