Tool to interact with CSV

This page summarizes the projects mentioned and recommended in the original post on /r/commandline

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • csvkit

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

    I used to use csvkit tools, but at some point I had issues with some conversions of values (I don't remember the details).

  • goawk

    A POSIX-compliant AWK interpreter written in Go, with CSV support

    No, I want exactly the opposite - it should be a , b,c as a single string field containing a literal comma, and c. For example, https://github.com/benhoyt/goawk has csv support. https://github.com/benhoyt/goawk/blob/master/docs/csv.md - more info.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • csvtk

    A cross-platform, efficient and practical CSV/TSV toolkit in Golang

    I moved to csvtk and I am pretty happy with it. I find it a robust, feature rich, self-contained program.

  • xsv

    A fast CSV command line toolkit written in Rust.

    xsv. Cross platform, fast and especially so with larger csvs if you index them

  • jc

    CLI tool and python library that converts the output of popular command-line tools, file-types, and common strings to JSON, YAML, or Dictionaries. This allows piping of output to tools like jq and simplifying automation scripts.

  • dasel

    Select, put and delete data from JSON, TOML, YAML, XML and CSV files with a single tool. Supports conversion between formats and can be used as a Go package.

    dasel - Comparable to jq / yq, but supports JSON, YAML, TOML, XML and CSV with zero runtime dependencies.

  • csvq

    SQL-like query language for csv

    csvq

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • miller

    Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

    Came here to recommend miller!

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts