Analyzes, cleans, and visualizes Excel spreadsheet data using Python libraries like pandas and openpyxl.
Excel Analysis is a specialized Claude Code skill designed to streamline data processing workflows involving .xlsx and .xls files. It empowers Claude to handle complex spreadsheet tasks programmatically, including multi-sheet processing, pivot table generation, advanced data cleaning, and visual chart creation. Whether you are merging disparate sales reports, applying conditional formatting to financial statements, or performing statistical analysis, this skill provides the patterns and best practices needed to turn raw data into actionable insights using robust Python-based implementations.
主要功能
01Seamless multi-sheet reading and merging of disparate Excel files
02Data visualization and chart generation using matplotlib integration
03Programmatic creation of pivot tables and aggregate reports
04Automated data cleaning and type conversion for messy spreadsheets
05Advanced workbook formatting with custom styles and conditional logic
060 GitHub stars
使用场景
01Automating monthly financial reporting and multi-sheet consolidation
02Generating visual dashboards and charts directly from spreadsheet sources
03Cleaning and preparing messy raw data for CRM or database imports
