Unix command-Line CSV viewer
--------------------------------------------------
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Take control of your privacy with Proton's trusted, Swiss-based, secure services.
Choose what you need and safeguard your digital life:
Mail: https://go.getproton.me/SH1CU
VPN: https://go.getproton.me/SH1DI
Password Manager: https://go.getproton.me/SH1DJ
Drive: https://go.getproton.me/SH1CT
Music by Eric Matyas
https://www.soundimage.org
Track title: Underwater World
--
Chapters
00:00 Unix Command-Line Csv Viewer
00:24 Answer 1 Score 5
01:36 Accepted Answer Score 7
01:52 Answer 3 Score 9
02:13 Answer 4 Score 3
02:21 Thank you
--
Full question
https://superuser.com/questions/264003/u...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#commandline #unix #csv #viewer
#avk47
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Take control of your privacy with Proton's trusted, Swiss-based, secure services.
Choose what you need and safeguard your digital life:
Mail: https://go.getproton.me/SH1CU
VPN: https://go.getproton.me/SH1DI
Password Manager: https://go.getproton.me/SH1DJ
Drive: https://go.getproton.me/SH1CT
Music by Eric Matyas
https://www.soundimage.org
Track title: Underwater World
--
Chapters
00:00 Unix Command-Line Csv Viewer
00:24 Answer 1 Score 5
01:36 Accepted Answer Score 7
01:52 Answer 3 Score 9
02:13 Answer 4 Score 3
02:21 Thank you
--
Full question
https://superuser.com/questions/264003/u...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#commandline #unix #csv #viewer
#avk47
ANSWER 1
Score 9
It seems like this question overlaps (at least partially) with my similar question on StackOverflow:
The top answer there is currently:
column -s, -t < somefile.csv | less -#2 -N -S
(Please see the link for more details.)
ACCEPTED ANSWER
Score 7
sc is a command-line spreadsheet program that's been around a long time, likely available in your package manager. Here's a Linux Journal intro article to it:
ANSWER 3
Score 5
There's a tool, CSVfix, which helps with viewing CSV files.
CSVfix is a command-line stream editor specifically designed to deal with CSV data. With it you can, among other things:
- Convert fixed format, multi-line and DSV files to CSV
- Reorder, remove, split and merge fields
- Convert case, trim leading & trailing spaces
- Search for specific content using regular expressions
- Filter out duplicate data or data on exclusion lists
- Perform sed/perl style editing
- Enrich with data from other sources
- Add sequence numbers and file source information
- Split large CSV files into smaller files based on field contents
- Perform arithmetic calculations on individual fields
- Validate CSV data against a collection of validation rules
- Convert between CSV and fixed format, XML, SQL and DSV
- Summarise CSV data, calculating averages, modes, frequencies etc.
A simple way to view CSV files on the command-line is to pipe the .csv file into the column
utility with the column delimiter set as a comma:
column -s, -t yourfile.csv
ANSWER 4
Score 3
The powerful program vim have a plugin for .csv files in CSV Plugin and its screenshot is