excel-data-analyzer
Analyze messy and unstructured Excel files to identify data quality issues, detect format inconsistencies, find missing values, and generate comprehensive analysis reports. Use when Claude needs to work with Excel files (.xlsx, .xls) for data quality assessment, structure analysis, or when users request data auditing, cleaning recommendations, or statistical summaries of spreadsheet data.
npx skills add majiayu000/claude-skill-registry --skill excel-data-analyzer-mineru98-skills-store-2 --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Excel Data Analyzer ## Overview Analyze Excel files to identify data structure, quality issues, format inconsistencies, and statistical patterns. Generate comprehensive markdown reports with actionable insights for data cleaning and improvement. ## Quick Start Analyze any Excel file with a single command: ```bash cd /path/to/skill/scripts bun install # First time only bun run analyze_excel.ts /path/to/data.xlsx ``` Output: Markdown report (`data_analysis.md`) with complete analysis. ## Core Capabilities ### 1. Data Structure Detection Automatically identifies: - Column names and data types (integer, float, string, date, email, boolean, mixed) - Row and column counts per sheet - Distinct value counts - Sample values for quick inspection ### 2. Data Quality Analysis Detects quality issues: - **Missing values:** Percentage and count of nulls per column - **High null columns:** Flags columns with >50% missing data - **Mixed data types:** Identifies columns with inconsistent types - **Format issues:** Detects leading/trailing whitespace, inconsistent casing, numeric strings ### 3. Statistical Summaries Generates statistics for numeric columns: - Min, max, mean, median, standard deviat
- Overview
- Quick Start
- Core Capabilities
- 1. Data Structure Detection
- 2. Data Quality Analysis
- 3. Statistical Summaries
- 4. Quality Scoring
- 5. Multi-Sheet Support
- Usage
- Basic Analysis
- Custom Output Path
- First-Time Setup
- Workflow
- Report Structure
cd /path/to/skill/scripts bun install # First time only bun run analyze_excel.ts /path/to/data.xlsx bun run analyze_excel.ts data.xlsx bun run analyze_excel.ts data.xlsx --output reports/audit.md cd /path/to/excel-data-analyzer/scripts bun install
What does the excel-data-analyzer skill do?
Analyze messy and unstructured Excel files to identify data quality issues, detect format inconsistencies, find missing values, and generate comprehensive analysis reports. Use when Claude needs to work with Excel files (.xlsx, .xls) for data quality assessment, structure analysis, or when users request data auditing, cleaning recommendations, or statistical summaries of spreadsheet data.
How do I install it?
Run `npx skills add majiayu000/claude-skill-registry --skill excel-data-analyzer-mineru98-skills-store-2 --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From majiayu000/claude-skill-registry, a repository with 534 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.