In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Reconcile Two Lists or Two Sheets
Prompt
List A: name, headers and three sample rows: {{LIST_A}}
List B: name, headers and three sample rows: {{LIST_B}}
The key that should match (single column or combination), and the amount or field that should also agree: {{MATCH_KEY_AND_FIELDS}}
Acceptable tolerance for differences (for example rounding): {{TOLERANCE}}
Give me a method, not a guess about my data:
1. Preparation: how to make keys comparable (trim, case, leading zeros, number-versus-text) and a helper-column formula that builds a combination key if needed.
2. Formulas, or in Excel a Power Query merge, that classify every row as: in both and agreeing, in both but different, only in A, only in B. Include the formulas.
3. A summary count table for the four classes and a check that A's count equals matched plus only-in-A, and likewise for B.
4. A short list of the usual causes of each kind of mismatch for me to investigate, written as hypotheses.
5. How to document what I decided about each exception.
Don't state which list is right; say how to find out.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Reconcile Two Lists or Two Sheets” is a free prompt for ChatGPT in the Productivity category, 186 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{LIST_A}}, {{LIST_B}}, {{MATCH_KEY_AND_FIELDS}}, {{TOLERANCE}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 4 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.