Can I apply custom formatting like bold headers or cell colors?

Yes, the skill demonstrates how to use openpyxl to apply conditional formatting, adjust column widths, and style headers programmatically.

What Excel file formats are supported?

This skill primarily supports modern .xlsx files using openpyxl and older .xls files via the xlrd library, all managed through the pandas framework.

Can I generate visual charts directly from my data?

Yes, the skill includes specific implementation patterns for creating bar charts, pie charts, and other visualizations using matplotlib based on your Excel data.

Can it handle multi-sheet workbooks?

Yes, it includes methods to iterate through all sheets in an Excel file and perform individual or aggregate processing on each.

Does this skill help with cleaning messy spreadsheet data?

Absolutely. It provides automated patterns for removing duplicates, handling missing values (NaN), stripping whitespace, and converting data types.

Excel Data Analysis

Name: Excel Data Analysis
Author: Activer007

byActiver007

0•

数据科学与机器学习

Analyzes, manipulates, and visualizes Excel spreadsheets using Python-based automation to generate insights and formatted reports.

The Excel Analysis skill empowers Claude to perform complex data operations on spreadsheet files including reading multiple sheets, cleaning messy datasets, and generating insightful pivot tables. It bridges the gap between raw .xlsx data and actionable insights by providing standardized patterns for programmatic data manipulation, advanced formatting, and visual chart generation. Whether you are merging quarterly reports or applying conditional formatting to financial statements, this skill provides the necessary implementation patterns to automate repetitive spreadsheet tasks efficiently within the Claude Code environment.

主要功能

01Multi-sheet workbook processing and merging

020 GitHub stars

03Custom cell formatting and conditional styling

04Advanced pivot table and aggregation generation

05Dynamic chart and visualization creation via Matplotlib

06Automated data cleaning and type conversion

使用场景

01Merging multiple quarterly financial files into a single master sheet

02Generating automated monthly sales reports from raw workbook data

03Cleaning and normalizing large, inconsistent spreadsheet datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills excel-analysis

For use in Claude.ai and ChatGPT

Download Skill