A carefully curated list of CSV-related tools and resources

CSV remains the most futuristic data format from the distant past.

XML has risen and fallen. JSON is just a flash in the pan. YAML is a poisoned chalice. CSV will outlast them all.

When the final cockroach breathes her last breath, her dying act will be to scratch her date of death in a CSV file for posterity.

XMPP Bot to provide version/uptime/contact information for federated XMPP servers. !commands. Uses documented XEPs for its functionality, so make sure they're enabled on the server side. MUC enabled. "Federated" is the key here - the has to be able to contact other servers on the XMPP network.

Written using Python3.

Forked the repo: https://github.com/virtadpt/xmpp-chatbot

Command line utility which lets you run SQL queries against CSV and TSV files.

Redash is a web console for interfacing with databases, building queries and reports, and visualizing results. Includes SQLite, MySQL, Postgres, and even JSON documents. Snippets can be saved. Caches results, can autoupdate. Can join across different databases. Dashboards can be shared via unique links. Of course, has an API.

Github repo: https://github.com/getredash/redash

jq is a command line JSON parser that implements JSONpath syntax for slicing, dicing, and querying arbitrary JSON documents. Perfect for when your favorite online JSONpath expression tester can't handle that two gigabyte JSON dump somebody just gave you to parse...