What it does

Excel Analyzer is a developer-centric tool designed to profile and audit complex multi-sheet .xlsx workbooks. Unlike basic data profilers, it performs a structural deep-dive to detect "spreadsheet traps" like hidden sheets containing sensitive data or merged cells that silently break data ingestion. It provides automated data quality findings with ready-to-use Pandas fix snippets.

Why use this skill

Manually auditing a large Excel file is error-prone. This skill automates the drudgery by identifying column relationships across sheets (1-to-1, 1-to-many), detecting schema inconsistencies, and generating interactive Plotly HTML reports. It is significantly more reliable than manual prompting because it uses deterministic analysis to calculate exact null counts, outlier thresholds, and primary key candidates before providing reasoning.

Supported Tools

Pandas & Openpyxl: Robust data manipulation and Excel engine.
Plotly: Interactive data visualization and reporting.
Automated Join Logic: Proposes validated merge snippets for cross-sheet analysis.

Output

You receive a comprehensive audit including structural warnings, per-sheet data statistics (dtypes, uniques, outliers), severity-ranked quality issues, and runnable Python code to fix identified data debt.