Yes csvkit package includes all the following programs
csv2rec, csvclean, csvcut, csvformat, csvgrep, csvjoin, csvjson, csvlook, csvpy, csvsort, csvsql, csvstack, csvstat, in2csv, pedigree, rec2csv.
They each have a man page, and there is an html document here
file:///usr/share/doc/csvkit/html/index.html
provided you also install the package csvkit-doc
Is there much to seperate this app from libreoffice calc ? They look and feel the same
Similar with writer and abiword
I suspect gnumeric may not have some of the fancier features. I have never found anything missing, but I dont use spreadsheets a lot.
I mostly want to look at old Excel files and maybe write them to .csv files
Ah thanks, good to know. Iâll give it whirl on your recommendation using your instructions up the topic.
Whatâs the purpose behind miller and is it essential to install with csvkit?
I am not expert on miller. You dont need to install miller with csvkit, it is an independent utility.
Miller seems to aim to allow you to use things like awk, sed, grep with .csv files.
Ah, that makes sense. My csv needs are minor so probably of no real interest in that case.
Unless you are already root, shouldnât your code example include sudo?
Yes, of course.
I never use sudo, always become root, so I tend to forget when writing.
In the early days of Unix (BSD) sudo did not exist⌠the only way was to become root. I never changed to sudo.
all well and good for an experienced user like yourself but there be dragons for the less wary and capable!
I really dont see the difference for a home computer.
You have to be careful either way.
At work, on a multiuser server, it is a different matter.