skills.rest
malue-ai
malue-aiOFFICIAL
Explore all skills by this author →
GitHub

excel-analyzer

Analyze and process Excel/CSV files with pandas and openpyxl.

36|2|Updated Feb 9, 2026
Search Tags:#data analysis#data processing#pandas#excel#csv#pivot table
One-click install
npx skills add https://github.com/malue-ai/dazee-small --skill excel-analyzer-malue-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-analyzer
Source: https://github.com/malue-ai/dazee-small/tree/main/instances/xiaodazi/skills/excel-analyzer
Command: npx skills add https://github.com/malue-ai/dazee-small --skill excel-analyzer-malue-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) components.

What problem does it solve?

This Skill automates the analysis and processing of Excel and CSV files, handling tasks like data summarization, filtering, pivot table creation, and chart generation.

Core Features & Use Cases

  • Data Summary: Provides statistical summaries of your data.
  • Filtering: Allows you to filter data based on specific criteria.
  • Pivot Tables: Enables the creation of pivot tables for data aggregation.
  • Chart Generation: Supports generating charts from your data.
  • Use Case: Analyze sales data in an Excel file to find the total sales per region and generate a bar chart.

Quick Start

Use the excel-analyzer skill to summarize the data in the file located at '/path/to/your/sales_data.xlsx'.

Frequently Asked Questions about excel-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a pivot table from an Excel file to summarize sales data?▼

Yes, pandas can generate charts from CSV data by reading the file, filtering rows based on your criteria, and exporting the resulting visualizations and summarized datasets to new files.

How do I filter Excel data based on specific criteria and export the results?▼

You can filter Excel data by applying specific criteria to your dataset, and this Skill processes the file using pandas to clean, validate, and export the filtered results to a new spreadsheet file.

Does this Skill support reading and processing both Excel and CSV file formats?▼

Yes, this Skill supports reading and processing both Excel and CSV file formats, utilizing openpyxl and pandas to handle data summarization, validation, and chart generation across these formats.

What is the best way to clean and validate spreadsheet data before generating charts?▼

The best way to clean and validate spreadsheet data is using automated pandas processing, which includes built-in data validation and cleaning steps to ensure accuracy before generating charts or pivot tables.

Can I get a statistical summary of my CSV data without writing custom pandas scripts?▼

Yes, you can obtain a statistical summary of your CSV data directly, as this Skill provides automated data summarization features that process your files using pandas without requiring custom scripts.

Related Skills

Explore More Data & Analytics Skills→
miptah21miptah21
2

xlsx

Transform and repair spreadsheet inputs into valid Excel workbooks.

Community
Advanced
EdgeHuntEdgeHunt

ck:xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with formulas and pivot tables.

Official
Advanced
pchemguypchemguy

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate
georgekhananaevgeorgekhananaev
27

xlsx

Create, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.

Community
Advanced