csv-excel-merger

SKILL.md

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

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:

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)?