Q

lastmod 2020-10-16created 2020-10-122 edits

Run SQL queries on CSV files

Features

• Can query CSV/TSV and any Tabular Text
• Supports most SQL clauses such as WHERE, GROUP BY, JOIN (sqlite3)
• Supports automatic column names (c1, c2, etc.) and column type detection
• Supports all character encodings, including Korean

See also

• Spreadsheet
• CSV
• SQL
• Visidata - Working with spreadsheet data in the terminal

Favorite site

• Github - q
• q - Run SQL directly on CSV or TSV files