csv-excel-merger
OfficialMerge spreadsheets, deduplicate data, effortlessly.
Data & Analytics#data processing#excel#csv#spreadsheet automation#data merge#deduplication#data cleaning
AuthorOneWave-AI
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automates the complex task of merging multiple CSV/Excel files, intelligently handling different schemas, deduplicating data, and resolving conflicts. It saves data analysts and business users hours of manual data cleaning and consolidation.
Core Features & Use Cases
- Intelligent Column Matching: Automatically map similar columns across different files, even with inconsistent naming conventions.
- Data Deduplication: Identify and remove duplicate rows based on primary keys (e.g., email address), ensuring a clean dataset.
- Conflict Resolution: Define strategies for handling conflicting data when the same record appears in multiple files (e.g., keep latest, keep longest).
- Use Case: A marketing analyst has customer data spread across three different CSV files with inconsistent column names. This Skill merges them into a single, clean file, deduplicates entries, and resolves data conflicts, ready for analysis.
Quick Start
Example: Merge CSV files
"Merge these two CSV files: 'contacts_q1.csv' and 'contacts_q2.csv'. Use 'email' as the primary key for deduplication. Handle conflicting 'phone' numbers by keeping the most recent."
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: csv-excel-merger Download link: https://github.com/OneWave-AI/claude-skills/archive/main.zip#csv-excel-merger Please download this .zip file, extract it, and install it in the .claude/skills/ directory.