Skip to main content

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

Release files for csvql 0.0.5

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for csvql 0.0.5
File Size Uploaded
csvql-0.0.5.tar.gz 4.4 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for csvql 0.0.5
File Interpreter ABI Platform
csvql-0.0.5-py3-none-any.whl Python 3 none any Details

Total release size:10.0 kB

Release files / csvql-0.0.5.tar.gz

Download URL csvql-0.0.5.tar.gz
Size 4.4 kB
Tags Source
SHA-256 checksum
How to use checksums
feda6d5d3b5b18b1e076808d0ec086e2fde432d4310c9aef550921f8a30d1537
BLAKE2b-256 checksum
How to use checksums
455a4353b3a2f10825c7b5b9553e9ad4b2e721c6d18456d3e59ef023dd670cf0
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.6.8

Release files / csvql-0.0.5-py3-none-any.whl

Download URL csvql-0.0.5-py3-none-any.whl
Size 5.6 kB
Tags Python 3
SHA-256 checksum
How to use checksums
d933964374fdb2cde39dc77665efd62ee2bcdf728ff07a31b5a54a53e057a2af
BLAKE2b-256 checksum
How to use checksums
894cc4350a411adc0679677d530910d5559656699a99c8443bef22f92f81d4d6
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.6.8

Release history Release notifications | RSS feed

This release

0.0.5 This release

2 release files

0.0.4

2 release files

0.0.3

2 release files

0.0.2

2 release files

0.0.1

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page