A READY-MADE GUIDE / DATA

Reconcile two CSV exports.

Find missing and mismatched records before copying numbers into a report.

START WITHChatGPT

ChatGPT can inspect uploaded data and create tables, charts, and code-backed analysis.

Official source · verified 2026-10-01 ↗
01 / SETUP

Get ready

  1. Export both sources as CSV with clear headers, one record per row, and a stable ID column.
  2. Remove unnecessary personal data, label each file with its source and date, and upload both to ChatGPT with data analysis available.
02 / PROMPT

Give it this

Compare these two CSV exports: [file A] and [file B]. First identify the ID column, date coverage, row counts, duplicate IDs, and any column or format differences. Do not merge until you confirm the join key and normalization rules. Then produce counts and examples of records only in A, only in B, and in both with differing [fields]. Show the code or exact calculation used. Treat missing values separately from zero. Summarize likely causes as hypotheses, not facts.

03 / WORKFLOW

Make it useful

  1. Confirm the ID field and date range against the source systems.
  2. Spot-check several unmatched and changed rows in both original exports.
  3. Record the verified discrepancies and resolve them with the data owners before updating a report.

One thing to check. A wrong join key or inconsistent formatting can create false mismatches. Verify the matching rules and sample rows yourself.

THE SHORTLIST

Why this one?

Only task-specific matches in our verified catalog appear here. When none match, we start with a general tool and say so.

OUR PICK

ChatGPT

ChatGPT can inspect uploaded data and create tables, charts, and code-backed analysis.

Official source ↗

PICK YOUR PATH

How would you use this?

01 / DO IT MYSELFUse the recipeTake the setup, prompt, and checks above. You're in the driver's seat.

No account needed. Picking the second option only counts interest.

ONE QUICK CHECK

Was this useful?

A tiny vote helps us make the next guide better.

No account or written feedback needed.