Awesome CSV

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.

Contents

• Tools
• Repair or Validate CSV
• Treat CSV as SQL
• Convert to or from CSV
• CSV <-> JSON
• Essays
• Data
• Conferences
• Standards
• META: Other similar lists
• Code of Conduct
• Funtribute
• Footnotes

Here are some awesome tools for dealing with CSV:

Tools

• NimbleText/Live - Use patterns to manipulate CSV; the world's simplest code generator *.
• PapaParse - A powerful in-browser CSV parser.
• d3-dsv - d3.js parser and formatter module for delimiter-separated values.
• CSVKit - CSV utilities that includes csvsql / csvgrep / csvstat and more.
• QSV - A fast CSV command-line toolkit written in Rust, (an update to xsv).
• sed (gnu tool) - Stream editor.
• gawk (gnu tool) - Text processing and data extraction using awk.
• awk by example - Comprehensive examples of using awk.
• Miller - Like sed / awk / cut / join / sort etc for name-indexed data such as CSV.
• ParaText - CSV parsing at 2.5 GB per second.
• CSVGet - Get structured data from sites as CSV.
• CSVfix - A tool for manipulating CSV data.
• Tad - A fast free cross-platform CSV viewer.
• Nvd3-tags - A tiny library for making charts from csv data.
• Powershell: Import-CSV - Powerful in-built facility for dealing with CSV (example).
• CSV Tools - A collection of useful CSV utilities.
• graph-cli - Flexible command line tool to create graphs from CSV data.
• CSV to SQL - Online tool to create insert/update/delete etc from CSV data.
• C#: kbCSV - An efficient, easy to use .NET parsing and writing library for CSV.
• csvprintf - UNIX command line utility for parsing and formatting output based on CSV files.
• Ron's Data Edit (new modern version of Ron's CSV Editor) - Handles big files, does miraculous things. A timeless editor for a timeless format.
• Rainbow CSV plugins - Collection of text editor plugins for CSV/TSV syntax highlighting. Available for Vim, VS Code, Atom, Sublime Text and other editors.
• ExtendsClass - A simple CSV comparator.
• Mighty Merge - join/union csv files.
• Modern CSV - A tool for editing CSV files and viewing large files.
• Data Wrangler - Data Wrangler is a code-centric data cleaning tool that is integrated into VS Code and VS Code Jupyter Notebooks.

Repair or Validate CSV

• Csvlint.go - Command line tool for validating CSV files against RFC 4180.
• csvstudio - A smart app to repair syntax errors in very large CSV files.
• scrubcsv - Remove bad records from a CSV file and normalize (requires rust)
• reconcile-csv - Find relationships between a set of related CSVs