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