Excel Analyzer

Excel Analyzer understands the structure of spreadsheets — not just the raw data — and produces analysis that matches how business stakeholders actually think about their data.

Automatic Structure Detection

• Identifies header rows, merged cells, and multi-level column headers
• Detects multiple data tables within a single sheet
• Recognizes formulas and flags cells that depend on external references
• Identifies consistent patterns (monthly columns, category rows)

Analysis Capabilities

Descriptive Statistics For numeric columns: min, max, mean, median, standard deviation, quartiles, and outlier detection (IQR method). For categorical columns: value counts, unique values, and dominant category.

Pivot Analysis Generates cross-tabulation by up to 3 dimensions with selectable aggregation functions (sum, count, average, min, max).

Time Series Detects date columns and performs: period-over-period growth, trend direction, and seasonality detection.

Anomaly Detection - Statistical outliers (z-score > 3) - Duplicate rows - Missing value patterns (random vs systematic) - Data type inconsistencies within columns

Code Generation

Converts the analysis into runnable Python pandas code, making the work reproducible and schedulable. The generated script includes openpyxl for reading Excel files and matplotlib for chart generation.

Report Output

Produces a structured Markdown report with tables, key metrics highlighted, and prioritized data quality issues.