What problem does it solve?
This Skill handles tasks where a spreadsheet file is the primary input or output — opening, reading, cleaning, editing, creating, converting, and validating .xlsx, .xlsm, .csv, and .tsv files — and ensures deliverables are dynamic Excel workbooks with correct formulas and no formula errors.
Core Features & Use Cases
- Reading & Writing: Load and save Excel and delimited files while preserving templates and formatting.
- Formula-first Workflows: Insert Excel formulas (never hardcode calculated results), add references across sheets, and enforce formula consistency.
- Recalculation & Validation: Recalculate formulas using LibreOffice via scripts/recalc.py and scan for Excel errors (#REF!, #DIV/0!, #NAME?, etc.).
- Repair & Packaging Tools: Utilities to unpack/pack Office files, validate OOXML against XSDs, and repair common XML/template issues.
- Data Cleaning & Conversion: Restructure malformed tabular data, add computed columns, convert between CSV/TSV/XLSX, and produce clean deliverables.
- Use Case Example: Convert a messy export (malformed CSV) into a multi-sheet .xlsx, add dynamic formulas and scenario inputs, run recalculation, and return an error-free, production-ready workbook.
Quick Start
Open 'sales_export.csv', clean malformed rows and headers, add a totals column with an Excel formula linking sheets, recalculate formulas using scripts/recalc.py, and save the result as 'sales_model.xlsx'.