Excel Data Analyzer

The excel-data-analyzer skill enables AI agents to interpret, process, and generate insights from Microsoft Excel files. It handles various file formats including .xlsx, .xls, and CSVs, allowing agents to perform complex data manipulations directly within the spreadsheet environment.

When to use it

• Extracting specific metrics or trends from large financial reports without manual copying.
• Cleaning messy datasets by removing duplicates, fixing formatting errors, or standardizing date columns.
• Generating dynamic pivot tables and charts to visualize sales performance or inventory levels.
• Automating repetitive calculations across multiple sheets using custom formulas or VBA macros.

Key capabilities

• Reads and writes data in Excel (.xlsx, .xls) and CSV formats.
• Performs advanced filtering, sorting, and grouping operations on rows and columns.
• Executes mathematical functions, statistical analysis, and logical lookups.
• Creates visualizations such as bar charts, line graphs, and pie charts based on selected ranges.
• Generates new sheets or modifies existing workbook structures programmatically.

Example prompts

• "Analyze the attached sales report and create a pivot table showing total revenue by region for Q4."
• "Clean this customer list by removing empty rows and standardizing all email addresses to lowercase."
• "Generate a line chart comparing monthly expenses against budget limits from the provided spreadsheet."

Tips & gotchas

Ensure your Excel files are saved in accessible locations before uploading, as the agent needs direct file access to process data. Complex macros or protected sheets may require specific permissions or password removal prior to analysis.