30 ms·

Essential CSV shell tools: csvtk: https://bioinf.shenwei.me/csvtk/ https://bioinf.shenwei.me/csvtk/ gawk: https://www.gnu.org/software/gawk/manual/html_node/C

• dbro 2y ago
  Forgive me for promoting this that I wrote: csvquote: https://github.com/dbro/csvquote https://github.com/dbro/csvquote Especially for use with existing shell text processing tools, eg. cut, sort, wc, etc.
• saint_yossarian 2y ago
  Also VisiData is an excellent TUI spreadsheet.
  • leonim 2y ago
    One of my favorite tools. However, I don’t think that Visidata is a spreadsheet, even though it looks like one and is named after one. It is more spreadsheet adjacent. It is focused on row-based and column-based operations. It doesn’t support arbitrary inter-cell operation(s), like you get in Excel-like spreadsheets. It is great for “Tidy Data’, where each row represents a coherent set of information about an object or observation. This is very much like Awk, or other pipeline tools which are also line/row oriented. For CLI tools, I’m also a big fan of Miller (https://github.com/johnkerl/miller https://github.com/johnkerl/miller) to filter/modify CSV and other data sources.
• Yomguithereal 2y ago
  I would add xan to this list: https://github.com/medialab/xan https://github.com/medialab/xan But of course, I am partial ;)
• jgord 2y ago
  aaand xsv : https://github.com/BurntSushi/xsv https://github.com/BurntSushi/xsv
  • Yomguithereal 2y ago
    xan is a maintained fork of xsv