awesome-csv-tools

Awesome Tools for a Not-So-Awesome File Format

Why?

Let's face it:

CSV is not a great format. As RFC 4180 states:

While there are various specifications and implementations for the CSV format (...), there is no formal specification in existence(...)

This leads to incompatibilities and many cases to handle in csv parsers.

This list collects awesome tools to work with csv, if you still have to do so!

Tools

X to CSV

• in2csv - Converts various tabular data formats into CSV

Database export to CSV

• pgclimb - Export data from PostgreSQL into different data formats
• sql2csv - Executes arbitrary commands against a SQL database and outputs the results as a CSV

Database import from CSV

• pgfutter - Import CSV and JSON into PostgreSQL the easy way
• pgloader - Provides advanced options for importing files (including CSV) into PostgresSQL

CSV Manipulation

• visidata - A terminal interface for exploring and arranging tabular data

Visualisation

• raw - The missing link between spreadsheets and data visualization