CSV List Reconciler & Matcher

CSV List Reconciler & Matcher

Local Processing

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.

Tool processing runs in your browser. If you create a calculator or conversion share link, its values are included in the URL. See the privacy policy for account, analytics and advertising data.

Current Limits

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

Choose in both, only in A, only in B or different values under "What to show". Useful for comparing sign-up lists with attendance, or member lists from two systems.

What You Can Do

Common and missing
Rows found in both lists or only one, matched by key.
Different values
Cells that differ in same-named columns, with A and B values.
Compare two columns
There is also a task comparing two columns in one CSV.

How to Use CSV List Reconciler & Matcher

  1. 1
    Enter lists A and BPaste the base and comparison lists.
  2. 2
    Set key and viewPick the key columns and what to show.
  3. 3
    Get the resultCopy it or download CSV/Excel.

Examples

Only in A
Input: A: 이름,전화 민수,010-1 지영,010-2 철수,010-3 B: 이름,전화 민수,010-1 철수,010-9 key: 이름
Result: # A에만 있는 1행입니다. 이름,전화 지영,010-2
Different values
Input: A: 이름,전화 민수,010-1 지영,010-2 철수,010-3 B: 이름,전화 민수,010-1 철수,010-9 key: 이름
Result: 이름,열,A 값,B 값 철수,전화,010-3,010-9

Common Use Cases

  • Checking registrations against actual attendees
  • Verifying member data matches across two systems

Frequently Asked Questions (FAQ)

Can the key columns have different names?

Yes. Set A’s and B’s key columns separately; leaving B’s empty uses the same name as A’s.

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