CSV

See also etc/tables.md how to convert CSV to tables

CSV cli tools

• miler comparism table
  • Compares miller to datamash, xsv, csvkit, pivot, q
• csvlens
  • command line CSV file viewer. It is like less but made for CSV.

xan

• GitHub
• Rust

Install:

sudo pacman -S xan

Usage:

Select first colums and list results:

xan select 0 userliste-altes-vpn-2026-02-20.csv | xan slice

csview

csview is designed for formatting and viewing

• GitHub
• csview: A Pretty CSV/TSV Viewer for the Terminal
• Rust
• No option to select columns to display

Install:

pamac install csview-bin

Usage:

csvkit

A suite of utilities for converting to and working with CSV, the king of tabular file formats.

• csvkit documentation
• GitHub
• FR: in2csv: support OpenOffice/LibreOffice files

Install:

pamac install csvkit

Usage:

Convert csv to json:

csvjson data.csv > data.json

Convert Excel sheet into CSV:

in2csv swr-2025-01_2025-05.xlsx

Unmaintained

• q
  • Run SQL directly on CSV or TSV files
  • Last commit 2023-12
• datamash
  • Last commit 2023-12
• pivot
  • Last commit 2017
• xsv
  • A fast CSV command line toolkit written in Rust.
  • Last commit 2021

Libreoffice to csv

libreoffice --convert-to csv --outdir /tmp/ text.ods