CSV
Tools
26_ENTRIES- 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
4_ENTRIES- 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
Generate Table Schema
1_ENTRIES- Wanted: More tools in this category.
- CSV Schema
Analyzes a CSV file and generates database table schema, all within the browser
Treat CSV as SQL
5_ENTRIES- TextQL
Execute SQL against CSV or TSV.
- Datasette Facets
Faceted browse and a JSON API for any CSV File or SQLite DB.
- q
Run SQL Directly on CSV Files
- RBQL
Rainbow Query Language, a SQL-like language with JavaScript or Python backend.
- PSKit Query
Powershell module lets you run simple queries over objects, including imported with csv
Convert to or from CSV
1_ENTRIES- CSV to Table
Convert CSV files to searchable and sortable HTML table.
CSV <-> JSON
3_ENTRIES- Agnes
Two way Csv to Json **.
- csv2json
online tool to convert your CSV or TSV formatted data to JSON and vice versa.
- csv-to-json
Easy, privacy-friendly and offline-first online csv to json converter.
Essays
6_ENTRIES- Thinking about CSV
Martin Fenner.
- In Praise of CSV
Waldo Jaquith.
- Stop Rolling Your Own CSV Parser!
Leon Bambrick ***.
- So You Want To Write Your Own CSV code?
Thomas Burette.
- Falsehoods Programmers Believe About CSVs
Jesse Donat.
- ASCII Delimited Text - Not CSV or TAB delimited text
Ronald Duncan.
Generate Data
3_ENTRIES- Fake Name Generator
Generate fake names with other identity data in bulk for testing.
- Mockium
Test data generator for CSV / JSON / SQL / XML.
- Mockaroo
Random data generator for CSV / JSON / SQL / Excel.
Data
5_ENTRIES- US Data.gov
18789+ CSV datasets.
- Australian Government Open Data
2715+ CSV datasets.
- Reference data in csv
Easy-to-use reference data in CSV and JSON formats.
- awesome-public-datasets
A topic-centric list of high-quality open datasets in public domains.
- United Nations data
Data from the UN
Conferences
1_ENTRIES- csv,conf
A community conference for data makers everywhere.
Standards
6_ENTRIES- RFC 4180
(html version) - "Common format and MIME Type for Comma-Separated Values (CSV) Files".Definition of the CSV FormatMIME Type Registration of text/csv
- CSV Schema Language
A language for defining and validating CSV data.
- csv,specs
Comma-Separated Values (CSV) Format Specifications (and Tests) incl. CSV v1.0, CSV v1.1, CSV Strict, CSV <3 Numerics, CSV<3 JSON, CSV <3 YAML.
- Tabular Data Resource
A Data Resource specialized for describing tabular data like CSV files or spreadsheets
- CSVY
A standard for adding a YAML header to CSV files to describe their format
META: Other similar lists
3_ENTRIES- structured-text-tools
List of command line tools for manipulating CSV / XML / HTML / JSON / INI etc.
- META-META
This list as CSV.
- META-META-META
A NimbleText pattern that produces this markdown page from this list as a CSV.