csvql

csvql is an easy to use, open source command line tool to work with CSV files

csvql has no requirements or dependencies other than Python 3

Features

• Import one or more CSV files into an SQLite database as tables
• Query and modify the data using SQL
• Export CSV files from the results of SQL queries
• Optionally export data in JSON format

Installation

You can install, upgrade, and uninstall csvql.py with these commands:

  $ pip3 install csvql
  $ pip3 install --upgrade csvql
  $ pip3 uninstall csvql

Help

To get help use:

  $ csvql -h

Examples

See examples folder for common and advanced use cases

Related Projects

• q
• textql
• csv-sql
• qhs
• OpenCSV
• csvkit
• csvfaker
• vehicle-make-model-data