Will it break my existing Excel templates?

No, the skill is designed to study and match existing formats and conventions, ensuring that manual updates preserve your established styles rather than imposing new ones.

Does it support financial modeling standards?

Yes, it applies industry-standard color coding (blue for hardcoded inputs, black for formulas, green for internal links) and specific number formatting for currency, multiples, and percentages.

How does the skill ensure formula accuracy?

The skill uses a specialized recalculation script that triggers LibreOffice to evaluate every formula and flag errors like #REF!, #DIV/0!, or #NAME? before final delivery.

Can it handle CSV and TSV files?

Yes, it can read, edit, and convert between .csv, .tsv, and Excel formats, including restructuring malformed rows or misplaced headers into proper spreadsheets.

Excel & XLSX Spreadsheet Mastery

Name: Excel & XLSX Spreadsheet Mastery
Author: loiter74

byloiter74

•

Productivity & Workflow

Automates professional spreadsheet creation and editing with dynamic formulas, financial modeling standards, and data cleaning capabilities.

This skill enables Claude to handle complex spreadsheet tasks across .xlsx, .xlsm, .csv, and .tsv formats with a focus on production-grade quality. It enforces a formula-first approach to ensure all calculations remain dynamic while strictly adhering to professional formatting and financial modeling standards. By integrating tools like pandas for analysis and openpyxl for formatting, it can clean messy tabular data, update existing templates without breaking conventions, and use headless LibreOffice to guarantee zero formula errors in the final deliverable.

Key Features

01Automated formula recalculation and error verification using LibreOffice

02Professional financial modeling with standardized color-coding and formatting

032 GitHub stars

04Formula-first implementation to ensure dynamic and updateable workbooks

05Preservation of existing template styles and established formatting conventions

06Complex data manipulation and cleaning using pandas and openpyxl

Use Cases

01Creating dynamic financial models with standardized assumptions and zero formula errors

02Updating existing Excel templates while strictly maintaining the original brand style

03Cleaning and restructuring malformed tabular data into professional reports

Key Features

01Automated formula recalculation and error verification using LibreOffice

02Professional financial modeling with standardized color-coding and formatting

032 GitHub stars

04Formula-first implementation to ensure dynamic and updateable workbooks

05Preservation of existing template styles and established formatting conventions

06Complex data manipulation and cleaning using pandas and openpyxl

Use Cases

01Creating dynamic financial models with standardized assumptions and zero formula errors

02Updating existing Excel templates while strictly maintaining the original brand style

03Cleaning and restructuring malformed tabular data into professional reports