Chapter 1 of 9 · Several addresses, one cell
About this video
This video uses sample data, not real G Maps Extractor data. It doesn't show how to scrape. BillionVerify is not affiliated with or endorsed by G Maps Extractor. File verification needs a paid account.
Video transcript
Several addresses, one cell
In a G Maps Extractor file, one Email cell can hold several addresses. Here's how to split them, so every address gets checked. G Maps Extractor publishes a demo file, and its Email column looks simple. Then you open a cell. Most filled rows hold more than one address, split by commas. One row holds seven. Other rows hold nothing. Its guide says so up front. The addresses come from public business websites, so some listings stay empty. Empty cells are harmless. Full ones are the trouble. File List Verify wants one address on each row, so a cell with three isn't ready yet.
Choose your columns
If you use the extension, choose your columns first. Click the gear button, open Export Setting, and tick what you need. The demo has 24 columns. You need about six. Keep Name, Phone, Website, Domain, Email and Place Id. Phones can go. In the demo it's one more comma list, and you've got enough of those.
Remove repeats first
Remove repeats while each business is still a single row. Place Id identifies the place, so use that. Ran several searches? G Maps Extractor has a free Merge CSV tool that joins the files first.
Split the cell
Now split on the comma. Give each address a row of its own, and repeat the business next to it. The demo puts a space after every comma, so trim that as well. Then name the column email. Now leave Domain alone. Five addresses at one domain can be five real inboxes. Remove exact repeats of an address, and nothing more.
Its own email check
G Maps Extractor's guide makes the case for the next step better than we could. Public addresses go stale. It offers an Email Checker too, which also flags catch-all domains and role accounts. Used it already? Here's how to read those labels.
Verify the split file
For the whole split file, drop it into File List Verify. It runs on its own, so close the tab if you like. You'll get an email at the end. Here's a result breakdown from a bigger sample list. It isn't a G Maps Extractor file, so expect different numbers.
Route each result
Each address gets its own decision. Valid goes in your main send. Role is a shared inbox, so keep it short. Catch-all gets a small send. Unknown sits out. Invalid and disposable stay away. Pick one status, export it, and repeat for the next. Name, Phone and Domain come back with the result. So one business can show a valid inbox and a role inbox, side by side.
What it costs
Every result uses one credit, role and catch-all included. Disposable, unknown and bad syntax are free. Uploading a file takes a paid account, which any credit purchase gives you.
Get started free
20 free credits every day you use your account, up to 600 a month. No credit card required. Start at billionverify.com.
Featured in this video
GMaps Extractor Email VerificationGMaps Extractor Email Verification: add verification after GMaps Extractor exports, clean contact data, and route valid, role-based, catch-all, invalid mail.Try GMaps Extractor Email VerificationMore in Google Maps Leads
All email verification videosBillionVerify pricing
Start free, then pay for what you verify. Pick a plan or buy credits once.
billed yearly $96
Save 60%$0.0004 / per credit
All 240,000 credits arrive at once. Use them anytime.
Choose your credits
Included in every paid plan
- 240,000 credits / year
- Single email verification
- Bulk email verification
- Email Finder
- Bulk Email Finder
- Company Search
- Live SMTP mailbox check
- Real-time API + batch processing
- CSV & Excel upload support
- Comprehensive verification reports
- Workspaces and teams with spend limits
- Credits never expire
Try the AI email verification features
20 free credits every day you log in, up to 600 a month. Free AI first email verification across every feature, no credit card.
Native MCP Server integration · Catch-all reported separately · Free tier, no credit card