Command-line Excel and CSV tools your coding agent can run

Two Agent Skills and 18 standalone Python scripts for the spreadsheet jobs that eat an afternoon: combining monthly files, removing duplicates, joining a lookup table, summarising by group, and checking a file before you send it on.

Who this is for: analysts and operators who already use a local coding agent (Claude Code, Codex, Cursor, OpenCode) and want repeatable spreadsheet steps instead of hand-editing.

What you get

• automate-excel: merge sheets, deduplicate by key, filter rows, split by row count or column value, VLOOKUP and multi-table lookup, group and aggregate, validate required columns and duplicate keys, transpose, rename sheets, fill a template, conditional formatting, set columns as text, Excel to CSV.
• csv-to-excel: formatted Excel output with encoding detection and several CSVs into one workbook.
• A command reference, worked examples, and a root SKILL.md that points your agent to the right skill.

Read before you buy

• Needs Python 3 and pip install -r skills/automate-excel/scripts/requirements.txt (openpyxl, pandas, xlrd).
• Local files only. .xls is read-only (via xlrd).
• Work on a copy of your data first.
• Verified on macOS arm64 with synthetic data. A six-step chain (merge, dedupe, VLOOKUP, aggregate, format, validate) was run end to end; no real customer data was used.