Are there any good lightweight CSV viewers out there? I would like something that easily refreshes a file after it has been modified. A quick google search didn't turn up any clear winners.
I'd prefer not to have to open Excel each time since it locks the file. This prevents any other programs from updating the file.
If your system has Cygwin, column -t in a terminal window is what I like to use.
$ cat file.csv
1,2,3,4
A,B,C,D
i,ii,iii,iv,v
foo,bar,foo foo,foobar
No commas
$ column -t -s"," file.csv
1 2 3 4
A B C D
i ii iii iv v
foo bar foo foo foobar
No commas
In order to update with changes to the original as you requested, you can combine it with the watch command:
watch column -t -s, file.csv