Claude MarketplacesSubmit

Excel Automation

daymade/claude-code-skills

This handles the three Excel problems Claude usually hits on macOS: creating formatted reports with openpyxl (investment banking color conventions included), parsing complex xlsm files that openpyxl chokes on using stdlib zipfile and xml parsing, and controlling Excel windows via AppleScript. The parsing approach is genuinely useful because it works around corrupted DefinedNames in financial models and handles the ZIP-based xlsx structure directly when openpyxl fails. Includes a decision tree for tool selection and specific fixes for "Formula removed" corruption in investment bank files. The formatting patterns follow actual IB standards with proper RGB codes for input cells, calculations, and cross-sheet references.

skills.sh installs: 1.5K
GitHub stars: 1.5K
last updated: Aug 21, 2026

Install

$ npx -y skills add daymade/claude-code-skills --skill excel-automation --agent claude-code

Installs into .claude/skills of the current project.

Files

Excel Automation

Create professional Excel files, parse complex financial models, and control Excel on macOS.

For an image or scan of a paper form that needs editable cells and a printable layout, load Printable forms before creating the workbook. Follow the host's designated spreadsheet authoring tool; use the openpyxl examples below only when that tool is permitted.

Quick Start

Before a command brings Excel forward or changes its visible window, check user activity and other agents' occupancy. Use only foreground operations covered by the current task's authorization. If the surface is in use, occupancy is unknown, or unexpected input occurs, stop input and continue independent background work.

# Create a formatted Excel report
uv run --with openpyxl scripts/create_formatted_excel.py output.xlsx

# Parse a complex xlsm that openpyxl can't handle
uv run scripts/parse_complex_excel.py model.xlsm              # List sheets
uv run scripts/parse_complex_excel.py model.xlsm "DCF"        # Extract a sheet
uv run scripts/parse_complex_excel.py model.xlsm --fix        # Fix corrupted names

SKILL.md on GitHub

Sponsors

Promote your product hereReach 125k+ visitors monthly Promote your product hereReach 125k+ visitors monthly

Agent CaffeineSponsoredClose your lid, come back to finished work

SnugSponsoredThe clipboard manager for the AI era Promote your product hereReach 125k+ visitors monthly

WaxSponsoredBlock anything with supervision, without erasing your iPhone Promote your product hereReach 125k+ visitors monthly

knobsSponsoredSee your site on any phone, any day, in any language

Details

Repository: github.com/daymade/claude-code-skills
Categories: Automation & Workflows, Office & Documents, Finance & Trading
First seen: Jun 3, 2026

Recommended

More Automation & Workflows

1

analytics-tracking-automationaradotso/data-skillsanalytics tracking automation1.5Kskills.sh installs

2

harvard-art-museums-data-pipelinearadotso/data-skillsharvard art museums data pipeline1.5Kskills.sh installs

3

harvard-artifacts-data-engineering-pipelinearadotso/data-skillsharvard artifacts data engineering pipeline1.5Kskills.sh installs

4

social-media-generatorailabs-393/ai-labs-claude-skillsThis skill should be used when the user requests social media content creation for Twitter, Instagram, LinkedIn, or Facebook. It generates platform-optimized po1.5Kskills.sh installs

5

brand-visual-generatorkostja94/marketing-skillsWhen the user wants to define, audit, or apply visual identity (typography, colors, spacing, design tokens, frontend aesthetics). Also use when the user mention1.4Kskills.sh installs

6

cookie-policy-page-generatorkostja94/marketing-skillsWhen the user wants to create or optimize a cookie policy page. Also use when the user mentions "cookie policy," "cookies," "cookie consent," "GDPR cookies," "c1.4Kskills.sh installs