What problem does it solve?
Many tasks that involve tabular data require working files in Excel formats but users face errors, broken formulas, inconsistent templates, or messy tabular inputs that are hard to clean and validate by hand. This Skill centralizes reliable spreadsheet workflows so users can open, clean, modify, convert, and produce fully functional .xlsx/.xlsm/.csv/.tsv deliverables with formula integrity and preserved formatting.
Core Features & Use Cases
- Read and write Excel and tabular files while preserving templates and formatting conventions.
- Insert and maintain Excel formulas (avoid hardcoding calculated results) and run mandatory formula recalculation with LibreOffice via scripts/recalc.py to ensure zero formula errors.
- Clean and restructure malformed tabular data (malformed rows, misplaced headers, junk data), convert between .csv/.tsv and .xlsx, and create new workbooks with professional fonts and number formats.
- Validate Office package structure (unpack/pack), run XML/XSD and relationship checks, and auto-repair common issues when modifying Office files.
- Use case examples: repair a downloaded financial model ensuring no #REF! errors, convert a messy CSV export into a templated workbook with formulas, or generate a multi-sheet forecast workbook that stays recalculable.
Quick Start
Open the spreadsheet at /path/to/input.xlsx, clean and restructure the data, add or convert formulas as needed, run the LibreOffice recalculation script, and save the validated output as /path/to/output.xlsx.