What problem does it solve?
Working with Excel and spreadsheet files often requires specialized knowledge of formatting standards, formula syntax, and data cleaning techniques. This Skill provides an AI-powered assistant that handles the full lifecycle of spreadsheet operations, from creating professional workbooks to analyzing messy data and validating complex financial models.
Core Features & Use Cases
- Professional Spreadsheet Creation: Build .xlsx files from scratch or from data sources using openpyxl, with support for formulas, formatting, and industry-standard financial model conventions.
- Data Analysis & Cleaning: Read and analyze .xlsx, .csv, .tsv, and .xlsm files using pandas, handling malformed rows, misplaced headers, and junk data to produce clean, structured spreadsheets.
- Formula Management & Validation: Ensure zero formula errors with mandatory LibreOffice recalculation, comprehensive error scanning for #REF!, #DIV/0!, #VALUE!, and other Excel errors.
- Financial Modeling Standards: Apply color-coded inputs (blue), formulas (black), cross-sheet links (green), and external links (red), with proper number formatting and assumption documentation.
- Use Case: A data analyst receives a messy CSV of sales records with missing headers and inconsistent formatting. This Skill cleans the data, creates a properly formatted Excel workbook with pivot tables and charts, and validates all formulas for errors.
Quick Start
Use the xlsx skill to analyze the attached 'sales_data.xlsx' file and generate a formatted summary report with pivot tables.