Pretty Print a simple csv in the command line

column -s, -t <tmp.csv

Splits the input based on commas and prints it in a nice column format. This would not work for CSV rows that have "," between quotes or with newline characters. Use only simple simple csv files.

Sample Output

hatem@okra:~$ column -s, -t <~/projects/ummahrepos/2009_prayer_times.csv
date        week_day   fajr_azan  fajr_iqama  sunrise  dhuhr_azan  dhuhr_iqama  asr_azan  asr_iqama  maghrib_azan  maghrib_iqama  isha_azan  isha_iqama
2009-01-01  Thurusday  06:24      07:00       07:51    12:19       12:30        14:28     15:00      16:45         16:45          18:14      19:30     
2009-01-02  Friday     06:24      07:00       07:51    12:19       12:30        14:29     15:00      16:46         16:46          18:14      19:30     
2009-01-03  Saturday   06:24      07:00       07:51    12:20       12:30        14:29     15:00      16:47         16:47          18:15      19:30     
2009-01-04  Sunday     06:24      07:00       07:51    12:20       12:30        14:30     15:00      16:48         16:48          18:16      19:30     
2009-01-05  Monday     06:24      07:00       07:51    12:21       12:30        14:31     15:00      16:49         16:49          18:17      19:30     
2009-01-06  Tuesday    06:24      07:00       07:51    12:21       12:30        14:32     15:00      16:50         16:50          18:18      19:30     
2009-01-07  Wednesday  06:24      07:00       07:51    12:21       12:30        14:33     15:00      16:52         16:52          18:19      19:30     
2009-01-08  Thurusday  06:24      07:00       07:50    12:22       12:30        14:34     15:00      16:53         16:53          18:20      19:30     
2009-01-09  Friday     06:24      07:00       07:50    12:22       12:30        14:35     15:00      16:54         16:54          18:21      19:30     
2009-01-10  Saturday   06:23      07:00       07:50    12:23       12:30        14:36     15:00      16:55         16:55          18:22      19:30     
2009-01-11  Sunday     06:23      07:00       07:49    12:23       12:30        14:37     15:00      16:56         16:56          18:23      19:30     
2009-01-12  Monday     06:23      07:00       07:49    12:23       12:30        14:38     15:00      16:57         16:57          18:24      19:30     
2009-01-13  Tuesday    06:23      07:00       07:48    12:24       12:30        14:39     15:00      16:58         16:58          18:25      19:30     
2009-01-14  Wednesday  06:22      07:00       07:48    12:24       12:30        14:40     15:00      17:00         17:00          18:26      19:30     
2009-01-15  Thurusday  06:22      07:00       07:47    12:24       12:30        14:42     15:00      17:01         17:01          18:27      19:30     
2009-01-16  Friday     06:21      07:00       07:47    12:25       12:30        14:43     15:00      17:02         17:02          18:28      19:30     
2009-01-17  Saturday   06:21      07:00       07:46    12:25       12:30        14:44     15:00      17:03         17:03          18:29      19:30     
2009-01-18  Sunday     06:20      07:00       07:46    12:25       12:30        14:45     15:00      17:05         17:05          18:31      19:30     
2009-01-19  Monday     06:20      07:00       07:45    12:26       12:30        14:46     15:00      17:06         17:06          18:32      19:30     
2009-01-20  Tuesday    06:19      07:00       07:44    12:26       12:30        14:47     15:00      17:07         17:07          18:33      19:30     
2009-01-21  Wednesday  06:19      07:00       07:43    12:26       12:30        14:48     15:00      17:09         17:09          18:34      19:30     
2009-01-22  Thurusday  06:18      07:00       07:43    12:27       12:30        14:50     15:00      17:10

By: pykler

2009-09-24 20:57:32

column

2 Alternatives + Submit Alt

Pretty Print a simple csv in the command line

Will handle pretty much all types of CSV Files. The ^M character is typed on the command line using Ctrl-V Ctrl-M and can be replaced with any character that does not appear inside the CSV. Tips for simpler CSV files: * If newlines are not placed within a csv cell then you can replace `map(repr, r)` with r Show Sample Output
This is sample output - yours may be different.
```
'Date'        'info'    'name'              'amount'
'3/4/2009'    'abc123'  'Momo, Chika'       '1,000.00'
'9/14/2008'   'abc123'  'Kilo, Bamya'       '500'
'2/21/2009'   'abc123'  'Abeer, Bilhaj'     '10,000'
'5/9/2008'    'abc123'  'Adel, Ayoob'       '100'
'10/10/2008'  'abc123'  'Merabet, Jinkins'  ''
'10/13/2008'  'abc123'  'tito, micheal'     '50'
```
1

python -c 'import sys,csv; c = csv.reader(sys.stdin); [sys.stdout.write("^M".join(map(repr,r))+"\n") for r in c];' <tmp/test.csv | column -s '^M' -t

pykler · 2010-02-01 14:57:25 8
Pretty Print a simple csv in the command line

Source: http://stackoverflow.com/a/3800791/1447395
This is sample output - yours may be different.
0

column -s, -t < somefile.csv | less -#2 -N -S

DonDaniello · 2015-12-03 10:53:14 10

What Others Think

seofox · 140 weeks and 6 days ago

seofox · 140 weeks ago

BlackJack · 114 weeks and 1 day ago

rahimhh21 · 110 weeks and 3 days ago

".' ".' ".' ".' ".' ".' ".' ".' ".' ".' ".' ".' ".' ".'

masdani233 · 101 weeks ago

Buy Ketamine Online For Sale USA MDMA For Sale USA Shipping Psychedelic Drugs For Sale USA DMT For Sale USA Ayahuasca For Sale Online Queensland Buy LSD Online Legally Ketamine Liquid For Sale Buy Ketamine Pills Online Delivery Magic Mushroom For Sale USA Buy mushrooms edibles Online

medicalhouse25 · 93 weeks and 4 days ago

???? ??????? ??????

apadanaa44 · 83 weeks ago

pugpuppies95 · 64 weeks and 1 day ago

TIMUR188 Bukan hanya sekedar memberikan statement sebagai situs tergacor 2023 saat ini, kami membuktikan dengan memberikan jaminan garansi gacor 100% atau biasa di sebut garansi kekalahan 100%. Yang di mana apabila member baru deposit dan mengalami kekalahan pertamanya maka member berhak mengklaim garansi kekalahan 100% sesuai dengan syarat dan ketentuan yang berlaku. Menarik kan ? Main slot kalah dan bisa klaim kembali saldo nya. Promo ini hanya berlaku untuk member yang baru melakukan deposit untuk pertama kali nya. Cara klaim nya juga sangat mudah sekali. Member hanya perlu melapor ke CS Livechat TIMUR188 yang bertugas 24 jam dimana fitur klaim garansi nya terdapat di bagian pojok kanan bawah di halaman situs kami. Gabung sekarang juga jangan sampai ketinggalan promo bonus menarik yang sudah ditawarkan, segera klik langsung tombol yang disediakan diatas untuk bergabung dengan Situs TIMUR188 yang sudah kami Bagikan

bilis · 39 weeks and 1 day ago

Selamat datang di situs BENTO188 Bagi kalian yang gemar bermain game online, kalian telah berada di tempat yang tepat.

projack · 34 weeks and 5 days ago

Selamat datang di situs BOS717 Bagi kalian yang gemar bermain game online, kalian telah berada di tempat yang tepat.

projack · 34 weeks and 1 day ago

Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic timur188

projack · 17 weeks ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Similar Commands

Pretty print a simple csv in the command line +header coloring +multiple files support

one line command to recursively add all jar files in current folder to java class path

Print one . instead of each line

A simple function to conveniently extract columns from an input stream

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)