How does it handle errors like #REF! or #DIV/0!?

The skill includes a mandatory verification checklist and automated error scanning that flags any formula issues for immediate correction.

Can it handle professional financial modeling standards?

Absolutely. It follows industry conventions such as blue text for hardcoded inputs and black for formulas, ensuring models are audit-ready.

Does this skill support complex Excel formulas?

Yes, it supports full formula construction using openpyxl and includes a mandatory recalculation step to ensure values are updated and accurate.

Does it require any external software?

The skill utilizes LibreOffice via a recalc.py script to accurately evaluate formula results and check for errors during the generation process.

Can I use it to analyze existing data files?

Yes, the skill integrates pandas for powerful data analysis, allowing Claude to read, describe, and visualize data from .xlsx, .csv, and .tsv files.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: claudiodearaujo

byclaudiodearaujo

•

Data Science & ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and financial modeling standards.

About

This skill enables Claude to perform sophisticated spreadsheet operations, ranging from high-level data analysis with pandas to the creation of audit-ready financial models using openpyxl. It enforces strict industry standards for formatting, ensures zero formula errors through automated recalculation via LibreOffice, and preserves existing template conventions. Whether you need to generate dynamic workbooks with complex dependencies or analyze large CSV datasets, this skill provides the tools to maintain data integrity and professional presentation.

Key Features

Automated formula recalculation and error detection using LibreOffice integration
1 GitHub stars
Strict validation to eliminate #REF!, #DIV/0!, and other spreadsheet errors
Advanced data manipulation and visualization using integrated pandas workflows
Comprehensive .xlsx and .xlsm support with formula preservation and creation
Industry-standard financial modeling color-coding and number formatting

Use Cases

Updating legacy Excel templates while strictly maintaining original styles and complex logic
Generating dynamic financial models with linked assumptions and projection periods
Performing bulk data analysis on spreadsheets to create formatted summary reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro xlsx-official

For use in Claude.ai and ChatGPT

Download Skill

GitHub