Format a CSV file as markdown in vim

1 min read · vim markdown csv

The command to format CSV tables works similarly to formatting markdown.

Put this in your ~/.vimrc and use Control + s after highlighting a cs

1vmap <C-s> :!column -ts, -o " \| "<Enter>yyp:s/[^\|:]/-/g<Enter>

Read a CSV file into Vim:

1r ${file}.csv

Select the csv output:

1Transaction Date,Transaction Type,Transaction Description,Debit Amount,Credit Amount
229/12/2020,DEB,NON-GBP CASH FEE,1.50
329/12/2020,DEB,NON-GBP TRANS FEE,4.60
429/12/2020,DEB,KBA BRANKOVA 34,153.85
529/12/2020,DEB,NON-GBP PURCH FEE,0.50
629/12/2020,DEB,NON-GBP TRANS FEE,0.30
729/12/2020,DEB,BIOMARKET 2,10.36
829/12/2020,DEB,NON-GBP PURCH FEE,0.50

Press Control + s:

 1
 2Transaction Date | Transaction Type | Transaction Description | Debit Amount | Credit Amount
 3-----------------|------------------|-------------------------|--------------|--------------
 429/12/2020       | DEB              | NON-GBP CASH FEE        | 1.50         | 
 529/12/2020       | DEB              | NON-GBP TRANS FEE       | 4.60         | 
 629/12/2020       | DEB              | KBA BRANKOVA 34         | 153.85       | 
 729/12/2020       | DEB              | NON-GBP PURCH FEE       | 0.50         | 
 829/12/2020       | DEB              | NON-GBP TRANS FEE       | 0.30         | 
 929/12/2020       | DEB              | BIOMARKET 2             | 10.36        | 
1029/12/2020       | DEB              | NON-GBP PURCH FEE       | 0.50         |