Linux terminal-based CSV or TSV editor - command-line Calc?

Question

I'm trying to find a command line editor (or vim plugin) for large CSV or TSV files that will fix the width of cells and keep the row and column headers in view so I can move between cells and edit data. Basically something like the old DOS versions of Lotus 123 or Quattro Pro.

I find myself continually doing quick fixes in tabular data and don't want to fire up Calc every single time I want to change a few cells in column 32. I am not looking for perl/awk solutions since most of the fixes are one-off spelling/case data entry errors.

Answer 1

Take a look onto sc or Gnu Oleo, the may fit your need's

Also a look onto the Emacs based Spreadsheets may be worth a look

cheerio Steve

Answer 2

Sounds like you could use vim with ts/sw and friends to set up your columns widths, and then :1split to keep headers in view. You can also (assuming your CSV data doesn't have tabs in it already) do something like:

%s/,/\t/g

to switch commas to tabs, and

%s/\t/,/g

to switch them back, since it's easier to format TSV than CSV.

Answer 3

i suggest emeditor through wine