# CSV Tools

> Parse and analyze CSV data

- Skill: `gebruder/csv-tools` (Agent Skill)
- Install (CLI): `npx skillmds@latest add gebruder/csv-tools`
- Raw SKILL.md: https://api.skillmd.com/api/skills/gebruder/csv-tools/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: gebruder (https://skillmd.com/u/gebruder)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/gebruder/csv-tools

---


# CSV Tools

Work with CSV files using standard shell tools.

## View

- First few rows: `head -5 data.csv`
- Column headers: `head -1 data.csv`
- Row count: `wc -l data.csv`
- Specific columns (1st and 3rd): `cut -d',' -f1,3 data.csv`

## Filter and sort

- Filter rows: `awk -F',' '$3 > 100' data.csv`
- Sort by column: `sort -t',' -k2 -n data.csv`
- Unique values in column: `cut -d',' -f2 data.csv | sort -u`
- Count by value: `cut -d',' -f2 data.csv | sort | uniq -c | sort -rn`

## Transform

- Remove header: `tail -n +2 data.csv`
- Add line numbers: `nl -ba data.csv`
- Replace delimiter: `sed 's/,/\t/g' data.csv` (CSV to TSV)

## Python (for complex operations)

```
python3 -c "
import csv, sys
reader = csv.DictReader(open('data.csv'))
for row in reader:
    print(row)
" | head -10
```