qsv
Focus: data cleaning and data analysis. Shares csv and command line with Miller. Adds Windows. Rated 4.5 (Miller: 4.6).
Desktop AppFreemacOS, Windows
4.5Visit
Desktop App
Miller
Sort, filter and reshape CSV and JSON files from the terminal.
Rating
4.6 / 5
Pricing
Free
Difficulty
Intermediate
Works on
macOS, Linux
Built with love by Shushant Lakhyani. Building bestproductivityresources.com
What is Miller?
Miller works like awk, sed, cut, join and sort for data formats such as CSV, TSV, JSON and JSON Lines. Its README says you can use field names instead of counting columns, add or drop fields, sort, aggregate statistics and pretty-print results.
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 Miller does well
- Use column names instead of positions
- Handles CSV, TSV, JSON and JSON Lines
- Quick clean-ups without opening a spreadsheet
Cons: where it falls short
- Terminal only
- Takes time to learn the commands
Who Miller is for
Anyone who regularly tidies up data files.
Who can skip it
People who are happy working in a spreadsheet.
Miller alternatives
Not sold on Miller? These do a similar job, and each card says what it has in common.
hyperfine
Focus: benchmark, speed test and performance. Shares command line and open source with Miller. Adds Windows. Same 4.6 rating.
Desktop AppFreemacOS, Windows
4.6Visit
pgcli
Focus: postgres, sql and terminal. Shares command line and open source with Miller. Same 4.6 rating.
Desktop AppFreemacOS, Linux
4.6Visit
litecli
Focus: sqlite, sql and terminal. Shares command line and open source with Miller. Adds Windows. Rated 4.5 (Miller: 4.6).
Desktop AppFreemacOS, Windows
4.5Visit
jq
Focus: data and filter. Shares json and command line with Miller. Adds Windows. Rated 4.7 (Miller: 4.6).
Desktop AppFreemacOS, Windows
4.7Visit
OpenRefine
Focus: data cleaning and spreadsheet. Shares csv and data wrangling with Miller. Adds Windows. Same 4.6 rating.
Desktop AppFreemacOS, Windows
4.6Visit
Free alternatives to Miller
Want to spend nothing? These free picks cover similar ground.
Dasel
Focus: yaml and data conversion. Shares json and command line with Miller. Adds Windows. Rated 4.5 (Miller: 4.6).
Desktop AppFreemacOS, Windows
4.5Visit
VisiData
Focus: data and spreadsheet. Shares csv and command line with Miller. Adds Windows. Rated 4.5 (Miller: 4.6).
Desktop AppFreemacOS, Linux
4.5Visit
Harlequin
Focus: sql editor, database and terminal. Shares open source and github with Miller. Adds Windows. Rated 4.5 (Miller: 4.6).
Desktop AppFreemacOS, Windows
4.5Visit
NormCap
Focus: ocr, screen capture and copy text. Shares open source and github with Miller. Adds Windows and Offline. Rated 4.5 (Miller: 4.6).
Desktop AppFreeWindows, macOS
4.5Visit
fzf
Focus: fuzzy finder and shell. Shares command line and open source with Miller. Adds Windows and Offline. Rated 4.8 (Miller: 4.6).
Desktop AppFreemacOS, Windows
4.8Visit
ripgrep
Focus: search tool and developer tool. Shares command line and open source with Miller. Adds Windows and Offline. Rated 4.8 (Miller: 4.6).
Desktop AppFreemacOS, Windows
4.8Visit
Are you the maker of Miller?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 databaseFree 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 listFor 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 newsletterYou sign up on Gumroad, which stores your email to send the newsletter. See our Privacy Policy.