Also csvkit. in2csv data.xls > data.csv in2csv data.json > data.csv csvcut -c column_a,column_c data.csv > new.csv csvcut -c column_c,column_a data.csv

Also csvkit. in2csv data.xls > data.csv in2csv data.json > data.csv csvcut -c column_a,column_c data.csv > new.csv csvcut -c column_c,column_a data.csv > new.csv csvgrep -c phone_number -r 555-555-\d{4}" data.csv > matching.csv csvjson data.csv > data.json csvsql --query "select name from data where age > 30" data.csv > old_folks.csv csvsql --db postgresql:///database --insert data.csv sql2csv --db postgresql:///database --query "select * from data" > extract.csv https://github.com/wireservice/csvkit https://github.com/wireservice/csvkit (Submitted a pull request.)