CSVKit Next

Swiss army knife for CSV files. Filter, transform, merge, validate, analyze.

Installation

npm install -g @lxgicstudios/csvkit-next

Commands

Filter Rows

csvkit filter data.csv age gt 30
csvkit filter users.csv email contains @gmail
csvkit filter sales.csv status eq completed

Operators: eq, ne, gt, lt, gte, lte, contains, startswith, endswith, regex, empty, notempty

Transform Columns

csvkit transform data.csv "full_name=first+' '+last"
csvkit transform prices.csv "total=price*quantity"
csvkit transform users.csv "domain=email.split('@')[1]"

Merge Files

csvkit merge users.csv orders.csv -o combined.csv

Validate

csvkit validate data.csv
csvkit validate data.csv schema.json

Schema example:

{
  "required": ["id", "email"],
  "types": { "age": "number", "email": "email" }
}

Statistics

csvkit stats sales.csv

Shows: rows, columns, min/max/avg, unique values.

Other Commands

csvkit head data.csv 20          # First 20 rows
csvkit tail data.csv 20          # Last 20 rows
csvkit columns data.csv          # List columns
csvkit sort data.csv price desc  # Sort
csvkit unique data.csv category  # Unique values
csvkit sample data.csv 50        # Random rows
csvkit convert data.csv -t json  # To JSON

Common Use Cases

Filter high-value orders:

csvkit filter orders.csv total gt 1000 -o high_value.csv

Add calculated column:

csvkit transform sales.csv "profit=revenue-cost" -o with_profit.csv

Quick data overview:

csvkit stats large_dataset.csv

Features

• Zero dependencies
• Fast streaming for large files
• Expression-based transforms
• Schema validation
• Multiple output formats

Built by LXGIC Studios

🔗 GitHub · Twitter