Suggestions appear as you type. Use the up and down arrows to choose one and Enter to open it.

This page's audience our own tag's counts — open to see them
–Visits
–Page views
–Clicks to vendors
–Time on page
–Reading now
Clicks to vendors, by tool
  • –
Top countries
  • –
Devices
  • –

– · visits, page views and clicks counted by our own tag, which counts more than our checked analytics; every figure rounded down · how we count

csvkit review

Free#13 of 26 in Data Preparation Software

A capable free toolkit for repeatable CSV workflows, if you prefer the command line.

7.2/10Editor score
Visit csvkit
csvkit7.2 Visit csvkit

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

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.

csvkit pros and cons

  • 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

csvkit fact sheet, pricing and score →

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 · How we research and update