# Multi Format CSV Parser With Deduplication

> Parse brokerage CSV exports that exist in multiple formats with overlapping data across files

- Skill: `vamseeachanta/multi-format-csv-parser-with-deduplication` (Agent Skill)
- Install (CLI): `npx skillmds@latest add vamseeachanta/multi-format-csv-parser-with-deduplication`
- Raw SKILL.md: https://api.skillmd.com/api/skills/vamseeachanta/multi-format-csv-parser-with-deduplication/raw
- Safety review: PASS (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: vamseeachanta (https://skillmd.com/u/vamseeachanta)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/vamseeachanta/multi-format-csv-parser-with-deduplication

---


# Multi-Format CSV Parser with Deduplication

When ingesting brokerage data across multiple files or format versions, first map all edge cases (header variations, footer disclaimers, BOM markers). Auto-detect format from header row. Strip footers and BOM before parsing. Build a deduplication key (e.g., date + ticker + quantity + price) to merge overlapping transaction rows across files. Validate final dataset against user-stated holdings to catch parsing errors early.