excel-multi-sheet-threshold-analysis

What problem does it solve?

This Skill helps users analyze large multi-sheet Excel files to identify and remove duplicate entries, facilitating accurate data consolidation and reporting.

Core Features & Use Cases

• Bulk Data Analysis: Counts total rows across sheets and extracts key information.
• Data Deduplication: Classifies and removes duplicate entries based on keywords, enabling clean datasets.
• Report Generation: Produces summary and detailed Excel reports suitable for decision-making and record-keeping.
• Use Case: Imagine managing an Excel file with multiple project sheets; this Skill quickly aggregates and deduplicates data, producing comprehensive reports for project audits.

Quick Start

Load your Excel file, run the script to process all sheets, and generate the deduplication report and summary excel files with a single command.