News for hackers. Stuff that matters.
Re:A love letter to the CSV format by williamcotton on Wednesday March 26, 2025 @02:30PM (#43485285)
Re:A love letter to the CSV format by dbro on Wednesday March 26, 2025 @03:51PM (#43486374)
Forgive me for promoting this that I wrote:

csvquote: https://github.com/dbro/csvquote

Especially for use with existing shell text processing tools, eg. cut, sort, wc, etc.

Re:A love letter to the CSV format by saint_yossarian on Wednesday March 26, 2025 @04:32PM (#43486957)
Also VisiData is an excellent TUI spreadsheet.
Re:A love letter to the CSV format by leonim on Monday March 31, 2025 @08:08PM (#43541414)
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) to filter/modify CSV and other data sources.

Re:A love letter to the CSV format by Yomguithereal on Wednesday March 26, 2025 @04:33PM (#43486965)
I would add xan to this list: https://github.com/medialab/xan

But of course, I am partial ;)

Re:A love letter to the CSV format by jgord on Wednesday March 26, 2025 @10:23PM (#43489799)
Re:A love letter to the CSV format by Yomguithereal on Thursday March 27, 2025 @04:21AM (#43491411)
xan is a maintained fork of xsv