CSV

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

Libreoffice to csv

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

CSV cli tools

• miler comparism table
  • Compares miller to datamash, xsv, csvkit, pivot, q

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