Task prompt · Data
Merge two spreadsheets by a shared column
by Agent Yard TeamCombine two files on an ID or email and see exactly which rows did not match.
You'll attach
Needs file
Works with
ChatGPT
Claude
Gemini
Grok
CopilotUse cases
- Combine two files on an ID or email and see exactly which rows did not match.
- When you already have a file and want the AI to work from it instead of starting from scratch.
- Reuse it as often as you like: fill in the blanks (file to keep fully) with new details and copy again.
- As one step of the Make sense of your data prompt pack.
Featured in: Best AI prompts for spreadsheets and formulas, Best AI prompts for cleaning messy data.
How to use it
- Open chatgpt.com or claude.ai (or another AI listed here).
- Attach the file (PDF, Word, CSV or Excel), or paste its text into the prompt.
- Fill in the highlighted blank ([FILE TO KEEP FULLY]) below, or edit them after pasting.
- Copy the prompt, paste it into the chat and send.
Fill in the blanks (optional)
Prompt
I'm attaching two spreadsheets. Merge them using [SHARED COLUMN, e.g. email or order ID]. - Clean the key first (trim spaces, same capitalization) and tell me what you changed. - Keep all rows from [FILE TO KEEP FULLY]. - Give me the merged file. - Then list rows that had no match in the other file, and any keys that appear more than once. Explain the merge in plain words so I can repeat it in Excel or Google Sheets with XLOOKUP.
One email a week
The Weekly is presented byyour brandSponsored · openThe best new prompts and personas, nothing else.