Agent skill · data analytics · aiskillstore
excel-analysis
Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.
Why this skill is useful
Provides specific pandas commands for advanced Excel data analysis and manipulation that the AI wouldn't reliably generate on its own.
What it needs
Requires matplotlib, openpyxl, pandas installed locally. About 2k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Excel Analysis Quick start Read Excel files with pandas: Reading multiple sheets Process all sheets in a workbook: Data analysis Perform common analysis tasks: Creating Excel files Write data to Excel with formatting: Pivot tables Create pivot tables programmatically: Charts and visualization Generate charts from Excel data: Data cleaning Clean and prepare Excel data: Merging and joining Combine multiple Excel files: Advanced formatting Apply conditional formatting and styles: Performance tips Use readexcel with usecols to read specific columns only Use chunksize for very large files Consider using engine='openpyxl' or engine='xlrd' based on file type Use dtype parameter to specify column types for faster reading Available packages pandas - Data analysis and manipulation (primary) openpyxl - Excel file creation and formatting xlrd - Reading older .xls files xlsxwriter - Advanced Excel writing capabilities matplotlib - Chart generation
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/excel-analysis