Excel Analysis
Perform advanced data analysis, create pivot tables, and generate charts from Excel files.
Install
mkdir -p .claude/skills/excel-analysis-joyooosama && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/11153" && unzip -o skill.zip -d .claude/skills/excel-analysis-joyooosama && rm skill.zipInstalls to .claude/skills/excel-analysis-joyooosama
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.Key capabilities
- →Read Excel files
- →Create pivot tables
- →Generate charts
- →Perform statistical analysis
How it works
It uses pandas and openpyxl to read, manipulate, and analyze tabular data from Excel files.
Inputs & outputs
When to use Excel Analysis
- →Calculate summary statistics for a dataset
- →Group and aggregate data by column
- →Read multiple sheets from an Excel file
- →Create pivot tables from tabular data
About this skill
Excel Analysis
Use this skill when the task matches the description above. Keep the initial response concise and only open bundled references or scripts when they are clearly needed.
Quick cues
- Use
read_excelwithusecolsto read specific columns only - Use
chunksizefor very large files - Consider using
engine='openpyxl'orengine='xlrd'based on file type - Use
dtypeparameter to specify column types for faster reading - pandas - Data analysis and manipulation (primary)
- openpyxl - Excel file creation and formatting
- xlrd - Reading older .xls files
- xlsxwriter - Advanced Excel writing capabilities
Available sections
- Excel Analysis
- Quick start
- Read Excel file
- Display first few rows
- Basic statistics
- Reading multiple sheets
- Read all sheets
- Data analysis
- Group by and aggregate
- Filter data
- Calculate metrics
- Sort by column
When not to use it
- →Non-tabular data
- →Extremely large datasets without chunking
Prerequisites
Limitations
- →Requires appropriate engine for file type
How it compares
It automates complex data analysis tasks that are manual in Excel.
Compared to similar skills
Excel Analysis side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| Excel Analysis (this skill) | 0 | 3mo | No flags | Intermediate |
| spreadsheet | 0 | 4mo | No flags | Intermediate |
| csv-data-summarizer | 15 | 10mo | Review | Beginner |
| finance-manager | 12 | 9mo | Review | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
You might also like
spreadsheet
cdrguru
Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified.
csv-data-summarizer
coffeefuelbump
Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.
finance-manager
ailabs-393
Comprehensive personal finance management system for analyzing transaction data, generating insights, creating visualizations, and providing actionable financial recommendations. Use when users need to analyze spending patterns, track budgets, visualize financial data, extract transactions from PDFs, calculate savings rates, identify spending trends, generate financial reports, or receive personalized budget recommendations. Triggers include requests like "analyze my finances", "track my spending", "create a financial report", "extract transactions from PDF", "visualize my budget", "where is my money going", "financial insights", "spending breakdown", or any finance-related analysis tasks.
xlsx
anthropics
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
excel-analysis
davila7
Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.
spreadsheet-formula-helper
ComposioHQ
Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.