How to Merge Email Verification Results Back Into Your Lead Spreadsheet
Merge verification results back into your lead sheet by joining on the email address: lowercase and trim the address on both sides, then add the status and send advice to each lead with VLOOKUP, XLOOKUP or a free CSV tool. Never join on row order, because a sort or a removed duplicate moves every row.
Why merge at all
A verification run gives you a results file. Your lead sheet has the names, companies, notes and owner that your outreach needs. Keeping both means switching tabs on every send. One master sheet with status columns lets you filter once and export what the sequencer needs.
Step 1: normalise the key on both sides
In each file, make a helper column with:
=LOWER(TRIM(A2))
where column A holds the email. This removes capitals and stray spaces, the two most common reasons for a missed match.
Step 2: look up the status
In the lead sheet, assuming the results file is in a sheet called results, with the key in column A and the status in column B:
=XLOOKUP(F2, results!A:A, results!B:B, "no status")
If you do not have XLOOKUP, =IFERROR(VLOOKUP(F2, results!A:C, 2, FALSE), "no status") does the same. Repeat for the send advice and the reason columns. Verify emails in Google Sheets covers working with results in a sheet.
Step 2 without formulas
The free CSV VLOOKUP tool matches two CSV files by a column you choose, in your browser. Pick the email column in both files and download the merged file.
Step 3: check the join
- Row count. The merged file must have the same number of rows as your original.
- No status. Filter for "no status". Each one should have an explanation: a blank cell, a malformed address, or a key that still differs.
- Spot check. Look at five rows and compare by eye with the results file.
Step 4: filter and export
| Filter | Goes to |
|---|---|
| Status valid, send advice safe | The campaign |
| Status risky | A separate small batch or a review sheet |
| Status invalid | A suppression list; see cold email suppression list |
Common mistakes
- Matching on the original row number after a sort.
- Leaving duplicates in one file and not the other, so one lead maps to two statuses.
- Merging on the name column because it looks cleaner.
Next step
Run 100 free checks with a Google sign-in, no card, and practise the merge on a small list. When you are ready for the real list, see pricing: Starter is $9 a month for 2,500 emails, packs start at $15 for 10,000 checks and Pro is $39 a month.
Common questions
How do I match verification results to my original list?
Use the email address as the key. In a spreadsheet, add a column that looks up each address in the results file and returns the status. Lowercase and trim both sides first so that capitals and trailing spaces do not break the match.
Why do some rows come back with no status after the join?
Usually a formatting difference: a trailing space, a capital letter, or a duplicate that was removed from the results. Clean the key on both sides. A row may also have been skipped on purpose, such as an empty or malformed cell.
Can I just filter the results file and import it?
Yes, if the results file already carries your other columns. If your lead sheet has more columns than you uploaded, merge on the email so you keep names, companies and notes with each status.
Should I merge on row number?
No. Duplicates are not counted and sorting changes the order, so row numbers drift. Always use the email address as the key.
Do I need to be a spreadsheet expert?
No. The free CSV VLOOKUP tool matches two CSV files on a column of your choice in your browser.
Check your list before you send
Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.