What problem does it solve?
Many tasks require producing or fixing spreadsheet files as the primary deliverable, but users often face messy tabular inputs, broken formulas, inconsistent formatting, or lost templates. This Skill centralizes workflows for opening, reading, editing, cleaning, converting, and producing .xlsx/.xlsm/.csv/.tsv deliverables while enforcing formula-based calculations and professional formatting. It prevents incorrect triggers when the primary deliverable is a document, script, or database pipeline.
Core Features & Use Cases
- Wide format support: Open, convert, and export .xlsx, .xlsm, .csv, and .tsv files while preserving workbook structure.
- Data cleaning & restructuring: Fix malformed rows, detect and restore headers, remove junk data, and reshape tables into proper spreadsheets.
- Formula-first workflows: Insert Excel formulas (not hardcoded values), run LibreOffice recalculation via scripts/recalc.py, and verify ZERO formula errors before delivery.
- Template preservation & validation: Match existing template styles when updating files and use pack/unpack/validate utilities to ensure Office file integrity.
- Automation & packaging: Use provided scripts to recalc formulas, unpack/pack Office files, and run schema validators for robust, production-ready outputs.
Quick Start
Open the file at Downloads/sales.csv, clean and normalize the headers and rows, add Excel formulas for totals, then save the result as cleaned-sales.xlsx.