csvkit

At a glance

• Editor score
  7.2 / 10
• Pricing
  Free plan
• Best for
  CLI-based CSV engineering
• Free plan
  Yes
• Paid from
  Free
• Deployment
  Desktop
• Facts checked
  20 Sep 2026

• Where it wins

  • Free, MIT-licensed, and open source
  • Profiles, cleans, joins, converts, and reshapes tabular data
  • Runs on Windows, macOS, and Linux with composable pipelines

• Where it doesn't

  • Command-line oriented rather than visual
  • Focused on CSV-centered tabular workflows
  • Pipeline-based work may not suit users seeking a graphical interface

Our verdict on csvkit

csvkit is an open-source suite of command-line utilities for developers, analysts, and other users working with tabular data. It converts Excel, JSON, DBF, GeoJSON, and fixed-width files to CSV, then supports cleaning, filtering, column selection, sorting, joining, and format conversion. Its tools accept files or standard input and can be chained through standard output, making csvkit a fit for repeatable CSV engineering on Windows, macOS, and Linux.

The toolkit covers the main stages of a CSV workflow. It reports descriptive statistics, data types, nulls, unique values, ranges, and frequencies for profiling. It can check and fix common CSV errors, including mismatched row lengths and empty columns, while column tools select, exclude, and reorder fields. Join support includes inner, full outer, left, and right joins. These capabilities make csvkit useful when preparation work involves inspection and transformation rather than a single file conversion.

Database connectivity adds another practical path for prepared data. csvkit can generate SQL statements and load or query CSV data through SQLite, PostgreSQL, MySQL, Oracle, Microsoft SQL Server, Sybase, DuckDB, CrateDB, and Ingres. It also exports CSV data to JSON and other output formats, including visualization-friendly output. The published distribution model is free, open source, and MIT-licensed, with no paid tier described. Choose csvkit for scriptable, composable CSV pipelines and database-oriented workflows; choose a different tool if a visual interface or a broader non-CSV preparation environment is central to your process.

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

csvkit pricing

csvkit fact sheet

csvkit integrations

csvkit lists 9 integrations on its own site.

• SQLite
• PostgreSQL
• MySQL
• Oracle
• Microsoft SQL Server
• Sybase
• DuckDB
• CrateDB
• Ingres

Alternatives to csvkit

• Alteryx DesignerA capable visual preparation suite for enterprises, priced for committed teams.9.2
• Amazon SageMaker Data WranglerA capable AWS-centered workspace for preparing and analyzing machine-learning data.9.1
• AWS Glue DataBrewA capable AWS-native choice for visual preparation, profiling, and scheduled data jobs.9.0

See all csvkit alternatives →

Featured on iTechGuides

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

<a href="https://www.itechguides.com/products/csvkit/"><img src="https://www.itechguides.com/best/badge/csvkit.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