excel-data-analyzer

...

13|3|Updated Jan 10, 2026

Search Tags:#reports #statistics #excel #data-analysis #xlsx #analyze #data-quality

Ready to run

npx skills add https://github.com/Mineru98/skills-store --skill excel-data-analyzer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: excel-data-analyzer
Source: https://github.com/Mineru98/skills-store/tree/main/.claude/skills/excel-data-analyzer
Command: npx skills add https://github.com/Mineru98/skills-store --skill excel-data-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires xlsx, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

Messy or unstructured Excel files often hide data quality issues, inconsistencies, and missing values that impede reliable analysis. This Skill provides automated detection, structured reporting, and actionable insights to improve spreadsheet quality.

Core Features & Use Cases

Data structure and type detection across multi-sheet workbooks.
Data quality analysis with missing values, format issues, and duplicates.
Statistical summaries and top-value distributions for numeric/text data.
Per-sheet and per-workbook quality scoring to prioritize fixes.
Use cases include data auditing for dashboards, cleaning before migration, and preparing spreadsheets for analysis.

Quick Start

Analyze an Excel file (xlsx or xls) to generate a comprehensive data-quality report.

Frequently Asked Questions about excel-data-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I audit Excel data quality for missing values and duplicates?▼

You can audit Excel data quality by parsing .xlsx or .xls files to automatically detect missing values, duplicates, and format inconsistencies. The tool generates a comprehensive Markdown report with per-sheet quality scores and actionable cleaning recommendations.

Can I generate statistical summaries for multiple sheets in an Excel workbook?▼

Yes, you can generate statistical summaries for multi-sheet Excel workbooks. The analysis identifies data structures, calculates top-value distributions for numeric and text data, and produces per-workbook quality scores to help prioritize fixes.

How do I check Excel data structure and type detection before migration?▼

To check Excel data structure before migration, you can apply automated type detection across multi-sheet workbooks. This identifies structural problems and statistical patterns, producing actionable insights to prepare spreadsheets for analysis.

Do I need Bun or TypeScript runtime to analyze xlsx files?▼

Yes, you need the Bun or TypeScript runtime along with the xlsx library to parse .xlsx or .xls files. These dependencies are required to extract data structures and generate the final Markdown quality report.

What is the best way to clean messy Excel files for reliable analysis?▼

The best way to clean messy Excel files is to use automated detection for structural problems and data quality issues. This approach provides per-sheet quality scoring and actionable cleaning recommendations, ensuring spreadsheets are ready for reliable analysis.

Can I use this for data auditing tasks in finance and operations spreadsheets?▼

Yes, you can use this for data auditing tasks across finance, marketing, and operations spreadsheets. It evaluates data quality, identifies inconsistencies, and generates quality scores to support dashboard preparation and data migration.