secretGeek / AwesomeCSV

# 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.
- csvtodashboard - Convert, clean, query (SQL) and visualize CSV entirely in the browser - local-first, nothing is uploaded.
- 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.
- CSV to SQL - Upload a CSV file, set a table name, and generate SQL inserts instantly.
- SmoothCSV - A fast, powerful, and intuitive CSV editor for Mac, Windows, and Linux.
### Repair or Validate CSV
- Csvlint.go - Command line tool for validating CSV files against RFC 4180.
- csvstudio - A s