Does this skill work with large datasets?

Absolutely. It leverages the pandas library for high-performance data manipulation and openpyxl for efficient reading and writing of large Excel workbooks.

Can it maintain existing spreadsheet formatting?

Yes, it is designed to study and match existing formats, styles, and conventions of your templates, ensuring that updates look seamless and professional.

How does the skill handle formula errors?

The skill includes a mandatory recalculation and verification step using a specialized script that detects #REF!, #DIV/0!, and other common Excel errors, allowing the AI to fix them before final delivery.

Why does it require LibreOffice?

LibreOffice is used in the background to programmatically recalculate formula values and ensure that the spreadsheet data is up-to-date and accurate without requiring manual intervention.

Advanced XLSX Spreadsheet Automation

Name: Advanced XLSX Spreadsheet Automation
Author: leduclinh7141

byleduclinh7141

•

Data Science & ML

Automates professional-grade spreadsheet creation, editing, and analysis with a focus on formula integrity and financial modeling standards.

The document-skills (xlsx) skill provides Claude with comprehensive capabilities for handling complex spreadsheet tasks. It enables the creation of dynamic Excel models featuring automated formula recalculation, industry-standard financial formatting, and sophisticated data analysis. By combining pandas for data manipulation and openpyxl for precise formatting, the skill ensures that spreadsheets remain dynamic and error-free. It is particularly valuable for users needing to generate professional financial reports, automate bulk data processing, or audit existing workbooks for formula errors like #REF! or #DIV/0!.

Key Features

01Industry-standard financial model formatting and color-coding conventions

02Template preservation that respects and matches existing file styles and conventions

03Seamless integration with pandas for advanced data analysis and visualization

041 GitHub stars

05Automated formula recalculation and error verification via LibreOffice integration

06Dynamic formula injection and preservation to avoid hardcoded values

Use Cases

01Converting and cleaning large CSV/TSV datasets into formatted Excel reports

02Building automated financial models with standardized assumptions and projection logic

03Auditing complex spreadsheets to identify and fix formula errors and broken references

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add leduclinh7141/aitykit-marketing document-skills

For use in Claude.ai and ChatGPT

Download Skill