For manipulating CSV from the terminal, check out https://github.com/BurntSushi/xsv

There's a fork with new features: https://github.com/jqnatividad/qsv