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
• Demo CSV file

Install / setup:

sudo pacman -S xan
curl -L https://github.com/medialab/corpora/raw/master/polarisation/medias.csv \
  -o ~/projects/data-serialization/csv/medias.csv
export CSV=~/projects/data-serialization/csv/medias.csv

Usage:

Select colum and list results:

xan select name,outreach $CSV | xan view

View CSV output without header:

nmcli --terse dev wifi | cut -d':' -O',' -f 8,12,14 | xan -n view

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:

csview -d ';' Verbraucherpreisindex-61111-0001.csv

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