The Scenario
The post-campaign analysis request landed in your inbox at 9 AM: "Can you deduplicate the mailing list before we run the next print drop?" You manage direct mail for a retailer. The 6,000-row customer address list was assembled over two years from web forms, in-store signups, and a purchased list — each with its own formatting conventions.
"14 Elm Street" and "14 Elm St." are the same address. The USPS doesn't care. Your print vendor charges per piece.
The bad version:
- Sort by ZIP code, then by street name, and eyeball adjacent rows for duplicates — which works until "Street" vs "St" breaks the sort order and the duplicates are no longer adjacent.
- Write a COUNTIF formula against a CONCATENATE of address fields — which flags exact duplicates only and misses every formatting variant.
- Export to a fuzzy matching script, spend two hours on setup, discover the script can't handle apartment numbers inline, patch it, run it again.
The vendor wants the deduplicated file by Thursday. You have a day.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Google Sheet and calls Interzoid's address match key API for every row — generating a similarity key that groups formatting variants of the same address together.
For each address in column A, generate an Interzoid address match key and write it to column B, then highlight any rows sharing the same key as likely duplicates.
What You Get
- Column B: Interzoid address match key per row.
- Rows sharing the same key highlighted in a consistent color — "14 Elm Street" and "14 Elm St." share a key and land as adjacent highlighted rows.
- A count of duplicate clusters written at the top so you know the scale before you start reviewing.
What If the Data Is Not Quite Ready
Addresses in column A include city and state — you want to match on street only
Extract only the street portion from each address in column A (text before the first comma) and write it to column B, then generate an Interzoid address match key for column B and write it to column C. Highlight rows sharing the same key in column C.
You want to flag duplicates without re-sorting the sheet
Generate Interzoid global address similarity keys for every row in column A and write them to column B, then add a COUNTIF in column C to flag keys that appear more than once.
Some rows have blank addresses that are contaminating the key results
Skip rows where column A is blank. For all other rows, generate an Interzoid address match key and write it to column B. Flag blank-source rows as 'BLANK' in column B.
Full dedup workflow: generate keys, flag, isolate duplicates in one shot
For each address in column A, generate an Interzoid address match key and write it to column B. Add a COUNTIF in column C showing how many times each key appears. Flag rows where column C is greater than 1 as 'DUPLICATE' in column D. Then create a new sheet called 'Duplicates' containing only those flagged rows, sorted by column B, for the vendor's review.
One prompt handles the key generation, the counts, the flags, and the output sheet.
Try It
Get the 7-day free trial of SheetXAI and open your customer address sheet — ask SheetXAI to generate address match keys and flag duplicates in column A before you send the file to the print vendor. Then see the spoke on parsing free-form addresses into structured columns, or the full Interzoid integration overview.