how to work with csv files in vim

Question

I want csv file to be opened in vim in the same way it opens in microsoft office . Data should be in column format and commas should not be seen and its should be traversed easily. Is it possible in vim with help of any plug-ins?

Answer 1

I am probably a little bit later answering that question, but for completeness I'll answer anyway. I have made the csv plugin that should make it possible to do what you want.

Among others, it allows:

• Display on which column the cursor is as well as number of columns
• Search for text within a column using :SearchInColumn command
• Highlight the column on which the cursor is using :HiColumn command
• Visually arrange all columns using :ArrangeColumn command
• Delete a Column using :DeleteColumn command
• Display a vertical or horizontal header line using :Header or :VHeader command
• Sort a Column using :Sort command
• Copy Column to register using :Column command
• Move a column behind another column using :MoveCol command
• Calculate the Sum of all values within a column using :SumCol command (you can also define your own custom aggregate functions)
• Move through the columns using the normal mode commands (W forwards, H backwards, K upwards, J downwards)
• sets up a nice syntax highlighting, concealing the delimiter, if your Vim supports it