Skip to content
Day 69: new resources are added every day. See what's new

What is csvkit?

csvkit is a suite of command-line tools for converting to and working with CSV, the most common format for spreadsheet-style data. It is released under the MIT license.

Third-party open-source projects. We are not affiliated with their authors; repositories are provided as-is by their maintainers. Review each project's license, code and security before installing. See our Disclaimer.

Pros: what csvkit does well

  • Work with CSV files without opening a spreadsheet
  • Convert other formats to CSV
  • Free and open source under the MIT license

Cons: where it falls short

  • Command line only
  • Not a point-and-click data tool

Who csvkit is for

Analysts and journalists who handle spreadsheet-style data.

Who can skip it

People who are happy working in a spreadsheet app.

csvkit alternatives

Not sold on csvkit? These do a similar job, and each card says what it has in common.

VisiData

Shares data and csv with csvkit. Adds macOS, Linux and Windows. Rated 4.5 (csvkit: 4.6).

Desktop AppFreemacOS, Linux

Miller

Focus: json and data wrangling. Shares csv and command line with csvkit. Adds macOS and Linux. Same 4.6 rating.

Desktop AppFreemacOS, Linux

qsv

Focus: data cleaning and data analysis. Shares csv and command line with csvkit. Adds macOS, Windows and Linux. Rated 4.5 (csvkit: 4.6).

Desktop AppFreemacOS, Windows

lnav

Focus: log viewer, terminal and troubleshooting. Shares command line and open source with csvkit. Rated 4.5 (csvkit: 4.6).

OtherFreeCross-Platform

hyperfine

Focus: benchmark, speed test and performance. Shares command line and open source with csvkit. Adds macOS, Windows and Linux. Same 4.6 rating.

Desktop AppFreemacOS, Windows

pgcli

Focus: postgres, sql and terminal. Shares command line and open source with csvkit. Adds macOS and Linux. Same 4.6 rating.

Desktop AppFreemacOS, Linux

Free alternatives to csvkit

Want to spend nothing? These free picks cover similar ground.

litecli

Focus: sqlite, sql and terminal. Shares command line and open source with csvkit. Adds macOS, Windows and Linux. Rated 4.5 (csvkit: 4.6).

Desktop AppFreemacOS, Windows

jq

Focus: json and filter. Shares data and command line with csvkit. Adds macOS, Windows and Linux. Rated 4.7 (csvkit: 4.6).

Desktop AppFreemacOS, Windows

OpenRefine

Focus: data cleaning and data wrangling. Shares spreadsheet and csv with csvkit. Adds macOS, Windows and Linux. Same 4.6 rating.

Desktop AppFreemacOS, Windows

age

Focus: encryption, privacy and security. Shares command line and open source with csvkit. Same 4.6 rating.

OtherFreeCross-Platform

GitUI

Focus: git, terminal and version control. Shares command line and open source with csvkit. Same 4.6 rating.

OtherFreeCross-Platform
Are you the maker of csvkit?Get a free Featured badge for your site, a share image and ready-to-paste posts. No sign-up.

Free Notion database

1,100+ ways people are making money online

Real online businesses, creators and projects, broken down by how they make money: apps, online stores, AI tools and more. Free on Gumroad.

Get the free database

Free Notion database

399+ ways to make money online

Hundreds of online income methods in one place, so you can compare options and pick one to try. Free on Gumroad.

Get the free list

For research and ideas only. Results vary and nothing here is a promise of income. See our Disclaimer.

Weekly newsletter

Everything new, every Monday.

One short email every Monday with everything shipped that week: new free tools and websites, new guides, new free browser tools and what's new in my free Gumroad libraries, plus how the site is growing. Free, and you can unsubscribe anytime.

Join the newsletter

You sign up on Gumroad, which stores your email to send the newsletter. See our Privacy Policy.

18 free downloads

Free databases, guides and hacks

Everything I've collected, free on Gumroad. Pay what you want, or nothing at all.

See all 18