aspiers/ai-config / .agents/skills/xlsx-to-csv
xlsx-to-csv
VerifiedConverts XLSX spreadsheets, including multi-sheet workbooks, into CSV files that can be read and grepped directly. Use whenever an .xlsx report needs processing — exports from Xero, Cryptio, bank statements, or any tool that delivers spreadsheet output.
XLSX to CSV
When to use
Any time you need to read or grep the contents of an .xlsx file in
text form. The Read tool cannot render .xlsx directly; convert to
CSV first.
Single-sheet XLSX
LibreOffice headless conversion works:
libreoffice --headless --convert-to csv --outdir /path/to/outdir /path/to/input.xlsx
Output: outdir/input.csv (the active sheet only).
Multi-sheet XLSX
LibreOffice's --convert-to csv only emits the active sheet, so
hidden sheets get dropped silently. For multi-sheet files use
xlsx2csv via uvx (no permanent install needed):
uvx --from xlsx2csv xlsx2csv -a /path/to/input.xlsx /path/to/outdir/
Output: one CSV per sheet, named after the sheet (with spaces preserved).
If you don't know whether a file is multi-sheet, default to xlsx2csv
— it handles single-sheet files fine too.
Files served with the wrong extension
Some tools deliver XLSX content with a .zip extension (e.g. Cryptio's
Trial Balance download). Inspect with unzip -l file.zip — if you see
xl/workbook.xml or [Content_Types].xml, it's an XLSX. Rename to
.xlsx and convert as normal.
Pitfalls
- LibreOffice silently emits the active sheet only — running it on a
multi-sheet file looks successful but discards hidden sheets. Always
check sheet count via
unzip -l file.xlsx | grep worksheets/sheet. xlsx2csvrequires an output directory for-a; it will not write to stdout when emitting multiple sheets.- Empty rows in the source are emitted as commas-only lines; filter
with
grep -v '^,*$'if they're noisy.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |