# Excel Analyzer

> Excel deep analysis - formula audit, data validation, pivot summaries

- Skill: `chainlesschain/excel-analyzer` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add chainlesschain/excel-analyzer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/chainlesschain/excel-analyzer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Web & Frontend
- Author: chainlesschain (https://skillmd.com/u/chainlesschain)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/chainlesschain/excel-analyzer

---


# Excel Analyzer

Deep analysis of Excel spreadsheets including formula auditing, data validation, and pivot summaries.

## Usage

```
/excel-analyzer --analyze <file>                    Full data analysis
/excel-analyzer --sheets <file>                     List all sheets
/excel-analyzer --formulas <file>                   Audit all formulas
/excel-analyzer --validate <file>                   Data consistency check
/excel-analyzer --summary <file> [--sheet <name>]   Pivot summary
```

## Features

- **Sheet Overview**: Names, row/column counts, data ranges
- **Data Analysis**: Type distribution, null counts, unique values
- **Formula Audit**: Find all formulas, detect errors (#REF!, #N/A, circular refs)
- **Data Validation**: Type consistency, date format issues, outlier detection
- **Pivot Summary**: Group-by aggregation (sum, average, count)

## Dependencies

- `exceljs` — Excel file reading and analysis