xlsx
Create and analyze Excel spreadsheets
Also available from: ArtemisAI,davila7,Azeem-2,ZhanlinCui,AutumnsGrove,anthropics,Cam10001110101,DYAI2025,ComposioHQ
This skill enables creating, editing, and analyzing Excel spreadsheets with formulas, formatting, and data analysis. It also recalculates formulas and verifies zero errors for publication-quality outputs.
Download the skill ZIP
Upload in Claude
Go to Settings → Capabilities → Skills → Upload skill
Toggle on and start using
Test it
Using "xlsx". Create a budget spreadsheet with Q1 projections
Expected outcome:
- Created budget.xlsx with Summary, Revenue, Expenses, and Assumptions sheets
- Applied color coding: blue for inputs, black for formulas, green for links
- Added 12 formulas across projection columns
- No formula errors detected after recalculation
Using "xlsx". Analyze customer data from Excel file
Expected outcome:
- Loaded customer_data.xlsx with 5000 rows and 15 columns
- Calculated summary statistics: mean, median, std dev for numeric columns
- Identified 23 missing values in contact_email column
- Exported cleaned dataset to cleaned_data.xlsx
Security Audit
SafeAll 79 static findings are FALSE POSITIVES. The skill uses subprocess calls only for legitimate LibreOffice formula recalculation with hardcoded arguments. No network data exfiltration, command injection, or malicious behavior. All filesystem operations are for LibreOffice configuration. Documentation keyword matches are benign context references.
Risk Factors
⚙️ External commands (3)
📁 Filesystem access (3)
🌐 Network access (2)
Quality Score
What You Can Build
Build financial models
Create valuation models, budget forecasts, and financial reports with proper formula structure and error checking.
Process Excel data
Import, clean, and analyze data from Excel files using pandas for machine learning workflows.
Format spreadsheets
Apply consistent formatting, color coding, and styling to improve spreadsheet readability and maintainability.
Try These Prompts
Create an Excel file named sales_report.xlsx with a summary sheet showing monthly sales totals, formatted with currency and bold headers.
Update the revenue numbers in budget.xlsx to reflect Q4 actuals. Keep all existing formulas intact.
Recalculate all formulas in model.xlsx and identify any #REF! or #DIV/0! errors with their cell locations.
Create a DCF valuation model in template.xlsx with assumptions in separate cells, proper color coding, and documented data sources.
Best Practices
- Always use Excel formulas instead of hardcoding calculated values to maintain spreadsheet recalculation capability
- Document data sources for hardcoded values using the format: Source: [Document], [Date], [Reference]
- Recalculate formulas after every edit using recalc.py and verify zero errors before finalizing
Avoid
- Hardcoding calculated values instead of using Excel formulas
- Opening files with data_only=True and saving, which permanently removes formulas
- Mixing pandas for analysis with openpyxl for the same file without proper save handling
Frequently Asked Questions
What libraries does this skill use?
How do I recalculate formulas?
Does this work with password-protected files?
Can I edit files with macros?
What Excel errors does recalc.py detect?
How are color codes applied?
Developer Details
File structure