csvkit

At a glance

• Editor score
  6.8 / 10
• Pricing
  Free plan
• Best for
  Free command-line CSV and tabular workflows
• Free plan
  Yes
• Paid from
  Free
• Deployment model
  Self_hosted
• Facts checked
  22 Sep 2026

• Where it wins

  • Converts Excel, JSON, NDJSON, DBF, GeoJSON and fixed-width files
  • Supports filtering, joins, sorting, stacking and column operations
  • Generates SQL and imports CSV data into supported SQL databases

• Where it doesn't

  • Requires comfort with command-line, code-based workflows
  • Self-hosted deployment adds environment and maintenance responsibility
  • Broader integration coverage is limited compared with wider platforms

Our verdict on csvkit

csvkit is an open-source suite of command-line utilities for converting, inspecting, cleaning, transforming and analyzing CSV and other tabular data. It is aimed at technical users who want repeatable workflows built from standard input and output. The toolkit covers CSV, DBF, fixed-width, GeoJSON, JSON, NDJSON, XLS and XLSX, along with gzip-, bz2- and xz-compressed CSV input. Its operations include selecting, deleting and reordering columns, filtering rows with regular expressions, joining, sorting and stacking files, and reporting common CSV errors.

The pricing model is straightforward: csvkit is open source and has a free plan. Its self-hosted deployment model and code-based transformation interface suit users who prefer terminal workflows and control over where processing runs. It can generate JSON and GeoJSON from CSV, generate SQL, execute SQL queries against CSV data, and import CSV data into supported SQL databases. Orchestration and data quality checks are part of its category capabilities, while the command-line design makes pipelines chainable and repeatable.

csvkit is a strong fit for analysts, developers and data teams handling file-based transformations without a paid visual workspace. Choose it when format conversion, column manipulation, filtering, joins, error reporting and SQL-oriented operations are central requirements. It is less suitable for teams seeking a graphical interface, managed deployment or a broad ecosystem of ready-made integrations. Users who need wider platform connectivity or a workflow experience built around nontechnical operators should consider an alternative with those capabilities.

Your product? Our editors can test csvkit in depth and publish a review, labelled as paid · from $149/mo →

csvkit pricing

csvkit fact sheet

Alternatives to csvkit

• DataformA free, managed workflow service for SQL transformation and testing in BigQuery.9.2
• Alteryx DesignerA broad visual toolkit for enterprise analysts working across complex data environments.9.1
• Apache BeamA broad, portable framework for engineering teams building code-driven data pipelines.9.0

See all csvkit alternatives →

Featured on iTechGuides

csvkit is listed in our Data Transformation Tools directory. Add the badge to your site — it links back to this page.

<a href="https://www.itechguides.com/products/csvkit-data-transformation-tool/"><img src="https://www.itechguides.com/best/badge/csvkit-data-transformation-tool.svg" alt="Featured on iTechGuides" width="230" height="46"></a>

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.

Last updated 7 Oct 2026 · How we research and update