excel-smart-analysis-and-cleaning
OfficialEfficiently clean, analyze, and visualize multi-sheet Excel data.
AuthorOpenSenseNova
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the need for intelligent cleaning and comprehensive analysis of complex Excel files, reducing manual effort and improving data accuracy.
Core Features & Use Cases
- Deep multi-sheet cleaning: Handles merged cells, text normalization, and RGB color filtering for Excel data.
- Cross-sheet verification and statistics: Performs data reconciliation between sheets and generates cross-tabulations.
- Visualization and reporting: Creates visual charts, styles Excel output with custom formatting, and provides download links for the processed files.
- Use Case: For financial analysts working with multi-year budgets in Excel, this Skill cleans messy data, checks totals across sheets, and produces styled reports with visual insights.
Quick Start
Use the skill to clean the data in your Excel file, perform cross-sheet comparisons, and generate a styled report with embedded visualizations.
Dependency Matrix
Required Modules
pandasmatplotlibopenpyxlre
Components
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: excel-smart-analysis-and-cleaning Download link: https://github.com/OpenSenseNova/SenseNova-Skills/archive/main.zip#excel-smart-analysis-and-cleaning Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.