Editing CSV files in Ubuntu [closed]

What is a good way to edit CSV files in Ubuntu?

The files look something like this:

This,is,data,with,a,header
2,2,3,4,,
1,,3,,6,6
,5,3,5,5,6
1,2,,,,
1,2,3,4,8,6
1,,9,,5,9
-1,,3,4,5,6
1,2,0,4,5,6

I've been using OpenOffice, but it takes about 5 clicks to turn off the default behaviour of quoting all of the fields.

I'd like to find something lightweight and easy to use that will allow inserting/deleting data, and column-based sorting.

Solution 1:

For vim, there's a nice plugin csv.vim.

The java CsvEditors (e.g. csveditor, reCsvEditor) may be worth a look