The Scenario
You are a lead gen agency account manager. A client just handed you 400 scraped email addresses in an Excel workbook. They want them added to an Instantly campaign by Friday.
The problem: you have no idea if those addresses are live. Sending to bad addresses destroys your sender reputation and your client's domain. Your SLA says you verify before you send.
The plan was to verify Monday, clean up Tuesday, import Wednesday. It is now Wednesday at 3 PM.
The bad version:
- Export the email column as CSV
- Upload to a standalone verifier, wait for the job
- Download results CSV
- VLOOKUP results back into the workbook
- Filter to valid rows, export a new CSV, import into Instantly
- The VLOOKUP broke on row 200 and you do not trust the final list.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your email list from the workbook and calls the Instantly verifier on each address, writing results directly back so you never leave Excel.
Open the SheetXAI sidebar and type:
Verify every email address in column A of the Prospects tab using Instantly and write the verification result (valid, invalid, or risky) into column B. Then apply a filter to show only valid rows.
SheetXAI runs each address through Instantly's verifier, writes the result to column B, and applies a filter to the Prospects tab. Valid rows are visible. The rest are filtered out but still in the workbook.
What You Get
400 addresses verified and the workbook ready for import:
- Column B — "valid", "invalid", or "risky" for every row
- Filter applied — only valid rows visible when you are ready to import
- Original rows preserved — everything is still in the workbook, the filter just surfaces the clean ones
- No round-trip CSV — everything stays in the workbook you started with
The risky rows are worth a manual review. Some will send fine. The column makes it easy to sort and decide.
What If the Data Is Not Quite Ready
Scraped lists arrive with formatting noise and duplicates. SheetXAI handles cleanup and verification in one pass.
When the email column has formatting noise
Scraped addresses often have surrounding quotes, angle brackets, or extra spaces that will cause a verifier to return false negatives.
Clean all emails in column A of the Prospects tab by removing quotes, angle brackets, and whitespace. Then verify each one through Instantly and write the result into column B.
When you need a TRUE/FALSE flag instead of status labels
Your import template expects a boolean column, not text.
Verify every email in column A of the Prospects tab through Instantly. Write TRUE into column B if the result is "valid", FALSE if "invalid" or "risky". Apply a filter to show only TRUE rows.
When you want to verify and import in one step
You do not want a second step. Verify and add valid leads to the campaign at the same time.
Verify every email in column A of the Prospects tab through Instantly. For every address that comes back as "valid", add it as a lead to campaign 'Client ABC April' using first name from column B and company from column C. Write the verification result and import status into column D.
When the list has duplicates that should be removed before verification
No point verifying the same address twice.
Deduplicate the Prospects tab by email address, keeping the first occurrence. Then verify the deduplicated list through Instantly and write the result into column B. Mark removed duplicates as "duplicate" in column C.
The pattern: normalize, verify, import — one prompt instead of three separate tools.
Try It
Get the 7-day free trial of SheetXAI and open any scraped email workbook, then ask it to verify and import in one go. The Instantly integration is included in every SheetXAI plan. For related workflows, see how to bulk-add verified leads to a campaign in Excel or the Instantly in Excel overview.