Setup & Installation
What This Skill Does
Handles spreadsheet creation, editing, and analysis for .xlsx, .csv, and .tsv files. Uses openpyxl for formatting-aware Excel work and pandas for data workflows. Recalculates formulas and renders sheets for visual review before delivery when tooling is available.
Unlike pasting data into a script or using a generic code agent, this skill preserves existing formatting, uses proper cell references instead of hardcoded values, and renders sheets for visual inspection so layout issues are caught before the file is handed off.
When to use it
- Building a financial model with formula-linked cells and color-coded inputs
- Converting a CSV export into a formatted .xlsx report with headers and borders
- Adding pivot-style summary tables to an existing workbook without breaking references
- Auditing a spreadsheet for broken formulas like #REF! or #DIV/0! errors
- Generating an IB-style DCF with section headers, indented line items, and cited assumptions