Miller
Command-line tool for processing name-indexed CSV, TSV, and JSON data.
Tested on Linux
Use it
Linux x86_64
download and install Miller binary to ~/.local/bin
mkdir -p ~/.local/bin && curl -L https://github.com/johnkerl/miller/releases/download/v6.22.0/miller-6.22.0-linux-amd64.tar.gz -o /tmp/miller.tar.gz && tar -xzf /tmp/miller.tar.gz -C /tmp && cp /tmp/miller-6.22.0-linux-amd64/mlr ~/.local/bin/mlr && chmod +x ~/.local/bin/mlr && ~/.local/bin/mlr --version
Check that it works
mlr --versionThe output should contain “mlr 6.22.0”.
First thing to try
cat > /tmp/input.csv <<'EOF'
name,age,salary
alice,30,1000
bob,25,2000
carol,35,1500
EOF
cat /tmp/input.csv
cat > /tmp/input.json <<'EOF'
{"name": "alice", "age": 30}
{"name": "bob", "age": 25}
EOF
cat /tmp/input.json
cat > /tmp/input2.csv <<'EOF'
a,b,c
1,2,3
4,5,6
7,8,9
EOF
cat /tmp/input2.csvmlr --csv put '$double_salary = $salary * 2' /tmp/input.csvWhat it does
- Add and transform fields with functionsTested
- Convert between CSV TSV JSON formatsTested
- Process CSV TSV JSON dataTested
- Slice dice reformat data for databasesTested
How far pickfit got
Linux x86_64
- Installs
- Starts
- 4 of 4 features work
- Works offline
macOS and Windows: the project says it runs there; pickfit hasn’t tried it.
Good for
An alternative to awk, sed, cut, join and sort.
How pickfit tested it
Each run starts from a clean machine and follows the steps above. How pickfit verifies
Linux x86_64
Its main function works
- Replayed from scratch
- Works offline
- Checked on 4 Nov 2026
- Version 6.22.0
Differences the test machine hit
- README: apt-get install miller / yum install miller
In the test: no root in sandbox; downloaded linux-amd64 tarball from GitHub releases and installed to ~/.local/bin