# CSV Taxonomy Consolidation

> Consolidate multiple CSV spreadsheets into a normalized taxonomy with deduplication, column mapping, hierarchy alignment, and audit reports.

- Skill: `rycen7822/csv-taxonomy-consolidation` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rycen7822/csv-taxonomy-consolidation`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rycen7822/csv-taxonomy-consolidation/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: Rycen7822 (https://skillmd.com/u/rycen7822)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/rycen7822/csv-taxonomy-consolidation

---

# CSV Taxonomy Consolidation
## When to Use
Use when the user has multiple CSV files or spreadsheets that need schema mapping, duplicate merging, taxonomy hierarchy cleanup, or reproducible audit reports.
## Do Not Use When
Do not use for plotting figures, PDF conversion, GitHub workflow work, or prose rewriting.
## Required Inputs
Input CSV paths, key columns, target taxonomy schema, merge rules, and output format.
## Workflow
1. Profile columns, encodings, row counts, and duplicate keys.
2. Map source columns to a canonical taxonomy schema.
3. Merge records with deterministic conflict rules and hierarchy validation.
4. Write consolidated CSV plus an audit report.