spreadsheet-ops
Installation
SKILL.md
When to Use
- You need to merge multiple CSV/Excel files into a single dataset and align columns.
- You need to clean tabular data (normalize headers, deduplicate rows, resolve conflicts) before downstream use.
- You need to perform data analysis/statistics on CSV/Excel (summaries, distributions, group-by metrics).
- You need to add or edit formulas in an Excel workbook (including applying formulas across ranges).
- You need to apply Excel formatting (including conditional formatting), generate charts, or force formula recalculation.
Key Features
- CSV/Excel merge & cleaning: combine files, normalize column names, deduplicate, and resolve conflicts.
- CSV/Excel analysis: compute descriptive statistics and analysis reports.
- Excel-only formula operations: create/edit formulas and apply them to specified ranges.
- Excel-only formatting: apply cell styles and conditional formatting rules.
- Excel-only visualization: build charts from worksheet ranges.
- Excel-only recalculation: set workbook to full recalculation (recalc flag) to ensure formulas update.