CSV List Reconciler & Matcher

Reconcile two CSV lists by a primary key column to discover shared records, missing entries, and field value differences.

How It Works & Processing Standards

Reconcile two CSV lists by a primary key column to discover shared records, missing entries, and field value differences.

Current Limits

  • Desktop max file size: 50MB
  • Mobile max file size: 20MB

CSV List Reconciler & Matcher is a 100% free, browser-based online utility. All calculations and file conversions run locally inside your browser (Local-First) without sending data to remote servers, keeping your documents and inputs strictly private.

How to Use CSV List Reconciler & Matcher

  1. 1
    Paste Dataset A & BInput primary CSV and comparison CSV.
  2. 2
    Select Match KeyChoose the common identifier column (e.g. user_id or email) in both files.
  3. 3
    Review Reconciliation ReportInspect common matched rows, items missing in A, items missing in B, and differing fields.

Examples

Reconcile User Lists
Input: List A: id=1 (Alice, Seoul), id=2 (Bob, Tokyo) List B: id=1 (Alice, London), id=3 (Carol, NYC)
Result: Matched: id=1 (Discrepancy in city: Seoul vs London) Only in A: id=2 (Bob) Only in B: id=3 (Carol)

Common Use Cases

  • Reconciling monthly billing records against bank merchant transaction exports
  • Auditing customer contact records between CRM and marketing email platforms
  • Verifying database migration completeness by cross-referencing old and new table dumps

Frequently Asked Questions (FAQ)

Can I export the discrepancies as a separate CSV?

Yes, you can download separate CSV files for matched records, discrepancies, and unmatched rows.

Have feedback or ideas for this tool? Suggest & Inquire →