skills.rest
anthropics
anthropicsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

2.7k|412|Updated Sep 17, 2025
Search Tags:#automation#financial modeling#data analysis#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/anthropics/claude-agent-sdk-demos --skill xlsx-anthropics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/anthropics/claude-agent-sdk-demos/tree/main/excel-demo/agent/.claude/skills/xlsx
Command: npx skills add https://github.com/anthropics/claude-agent-sdk-demos --skill xlsx-anthropics

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas.

What problem does it solve?

Manual spreadsheet work is error-prone, time-consuming, and complex, especially when dealing with formulas, formatting, and large datasets. This Skill automates these tasks, ensuring accuracy, reducing manual effort, and freeing up your time for higher-value analysis.

Core Features & Use Cases

  • Dynamic Spreadsheet Management: Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files while preserving existing formulas and formatting.
  • Automated Formula Recalculation & Error Checking: Automatically recalculate all formulas in a spreadsheet and identify common errors like #REF!, #DIV/0!, or #VALUE!, ensuring data integrity.
  • Data Analysis & Visualization: Leverage powerful Python libraries like pandas for advanced data manipulation, analysis, and preparation for visualization.
  • Use Case: A financial analyst needs to update a quarterly report spreadsheet with new data. This Skill can load the existing template, insert new figures, automatically recalculate all financial models, and verify the output for formula errors, saving hours of meticulous manual checking.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'quarterly_sales.xlsx' with columns for 'Product', 'Q1 Sales', 'Q2 Sales', and a 'Total Sales' column that sums Q1 and Q2 using an Excel formula.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel spreadsheet updates with formulas and data?▼

Automate Excel by using openpyxl to create, load, and modify .xlsx files while preserving formulas and formatting. Insert new data, recalculate formulas automatically, and verify results for errors like #REF! or #DIV/0!, eliminating manual spreadsheet maintenance.

Can I update an existing Excel template without breaking formulas?▼

Yes. Load existing .xlsx or .xlsm templates with openpyxl, insert new data into designated cells, and the Skill automatically recalculates dependent formulas while preserving your original structure and conventions.

How do I check for formula errors in Excel spreadsheets?▼

The Skill automatically identifies and flags formula errors including #REF!, #DIV/0!, and #VALUE! across all cells. Run error checking after data updates to ensure financial models and calculations are accurate before distribution.

What file formats does Excel automation support?▼

Excel automation works with .xlsx, .xlsm, .csv, and .tsv files. This range covers standard Excel workbooks, macro-enabled files, and delimited text formats for comprehensive spreadsheet workflow coverage.

Can I use pandas alongside Excel operations for data analysis?▼

Yes. The Skill integrates pandas for advanced data manipulation, aggregation, and analysis alongside openpyxl Excel operations, enabling you to prepare, transform, and load data into formatted spreadsheets with formulas intact.

When should I automate spreadsheets instead of manual updates?▼

Automate when dealing with recurring spreadsheet tasks, large datasets, complex formulas, or quarterly reports requiring consistent formatting and accuracy. Manual processes introduce errors and consume hours; automation ensures repeatability and eliminates formula verification work.

Related Skills

Explore More Finance & Accounting Skills→
LiamMaregaLiamMarega
3

xlsx

Open, modify, and generate xlsx, xlsm, csv, and tsv spreadsheets.

Community
Intermediate
shekerkammashekerkamma

archive-analysis

Archive completed analysis outputs to a centralized knowledge base.

Community
Basic
iOfficeAIiOfficeAI
31.8k

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Advanced
vasilyu1983vasilyu1983
73

document-xlsx

Create, edit, and analyze Excel workbooks with formulas and charts.

Community
Advanced