chainlesschain 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