csv-excel-merger

Installation
Summary

Merge multiple CSV or Excel files with intelligent column matching and automatic deduplication.

  • Performs fuzzy column matching to align headers across files with different naming conventions (e.g., "firstname" to "first_name", "e-mail" to "email")
  • Detects and resolves duplicate records using configurable strategies: keep first, keep last, keep longest value, or flag for manual review
  • Handles schema mismatches, encoding detection, and data type normalization across files
  • Generates detailed merge reports including conflict logs, data quality metrics, deduplication statistics, and source file tracking for each row
  • Supports multiple output formats: CSV, Excel, JSON, SQL INSERT statements, and Parquet for large datasets
SKILL.md

CSV/Excel Merger

Intelligently merge multiple CSV or Excel files with automatic column matching and data deduplication.

Instructions

When a user needs to merge CSV or Excel files:

  1. Analyze Input Files:

    • How many files need to be merged?
    • What format (CSV, Excel, TSV)?
    • Are the files provided or need to be read from disk?
    • Do columns have the same names across files?
    • What is the primary key (unique identifier)?
  2. Inspect File Structures:

    • Read headers from each file
    • Identify column names and data types
    • Detect encoding (UTF-8, Latin-1, etc.)
Related skills

More from onewave-ai/claude-skills

Installs
659
GitHub Stars
127
First Seen
Jan 24, 2026