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.

I don't know how to do the tab width fixing but ':1split' will give you a horizontal split window 1 line in size to keep the headers in view. Then Ctrl W-W will toggle you between the windows in VIM — gm3dmo, Jul 14 '10 at 21:09
@hurfdurf can you provide a link to the macrocalc you have found? — Jonas Stein, Sep 22 '14 at 18:22
Here's the link to macrocalc: http://www.freakout.de/#download — hurfdurf, Oct 10 '14 at 18:03

score 3 · Answer 1 · answered Jul 14 '10 at 22:52

3

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

answered Jul 14 '10 at 22:52

Lairsdragon

700
1
5
21

score 2 · Answer 2 · answered Jul 15 '10 at 21:25

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.

answered Jul 15 '10 at 21:25

BMDan

7,249
2
23
34

2

+1 You can do *anything* in Vim ;-). – sleske Jul 15 '10 at 21:29
2

@sleske, anything? Then why do we fill our machines with thousands of different programs for different purposes. If I've said it once I've said it a billion times - don't exaggerate. – John Gardeniers Jul 15 '10 at 21:41
1

As far as I know, http://www.cs.cmu.edu/afs/cs/project/ai-repository/ai/areas/classics/eliza/emacs/doctor.el has never been put into vim. But otherwise, yep! – BMDan Jul 15 '10 at 21:42
http://www.vim.org/scripts/script.php?script_id=294 (Align) looks like it could be useful as well. – hurfdurf Jul 16 '10 at 00:13

score 0 · Answer 3 · answered Aug 30 '11 at 10:01

0

i suggest emeditor through wine

answered Aug 30 '11 at 10:01

diyism

161
5

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

3 Answers3