What problem does it solve?
Working with Excel files often requires professional formatting, accurate formulas, and clean data structures, but manual spreadsheet work is error-prone and time-consuming. This Skill automates the creation, editing, and analysis of .xlsx, .xlsm, .csv, and .tsv files while enforcing industry standards for financial models and data integrity.
Core Features & Use Cases
- Professional Spreadsheet Creation: Build new Excel workbooks from scratch or from data sources using openpyxl, with proper fonts, colors, and number formats.
- Formula-Driven Editing: Modify existing spreadsheets while preserving formulas and templates, recalculating with LibreOffice to catch errors like #REF! or #DIV/0!.
- Data Cleaning & Restructuring: Transform messy tabular data with malformed rows, misplaced headers, or junk values into clean, properly formatted spreadsheets.
- Financial Modeling: Apply color-coded conventions (blue for inputs, black for formulas, green for internal links) and strict documentation requirements for assumptions.
Quick Start
Use the xlsx skill to open the file 'sales_data.xlsx' from your downloads, clean the malformed headers and duplicate rows, and save it as a professionally formatted spreadsheet.