Tool to interact with CSV

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

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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • 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.

  • 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.

    InfluxDB logo
  • 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

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  • 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

  • Yq is a portable yq: command-line YAML, JSON, XML, CSV and properties processor

    11 projects | news.ycombinator.com | 4 Feb 2023
  • Run SQL on CSV, Parquet, JSON, Arrow, Unix Pipes and Google Sheet

    9 projects | news.ycombinator.com | 24 Sep 2022
  • How to use SQL to directly query files

    5 projects | dev.to | 2 Feb 2022
  • An Introduction to JQ

    13 projects | /r/programming | 24 Aug 2021
  • Data Science at the Command Line, 2nd Edition (2021)

    5 projects | news.ycombinator.com | 6 May 2024