How to Verify Business Data Before You Import It
A prospect list is only as good as its worst phone number. Here is how to check a business record for accuracy, catch duplicates, and stop bad data from reaching your CRM.
Quick Answer: Verify business data by cross-checking each record against two independent live sources, confirming the business is still open, and removing duplicates before the list reaches your CRM. A record pulled from a single source drifts out of date within a few months, so a live cross-reference beats a one-time export every time.
You pull 200 business records for a zip code, load them into your CRM, and a week later half the calls hit disconnected numbers or businesses that closed last year. Bad data does not just waste an afternoon — it burns the confidence of whoever is making the calls, because a rep who dials three dead numbers in a row starts distrusting the whole list. The fix is not more data. It is learning how to verify business data before it ever enters your pipeline.
What does it mean to verify business data?
To verify business data means confirming that a record's core fields — name, address, and phone, often shortened to NAP — still match reality before you act on it. A record counts as verified when at least two independent live sources agree on the same phone number and open status within the last few months.
That is different from simply collecting data. A single export is a snapshot from one API at one moment. Verification checks that snapshot against a second source and flags anything that does not match, so a name change, a moved address, or a closed location does not slip into a call list. If you are new to the collection side of this, what business data extraction actually involves is a good starting point.
How do I know if a business record is stale?
A record is stale once it has gone more than a business quarter without being confirmed against a live source, or when it came from a single source with no cross-check at all. Four signals catch most of it before a rep wastes a call.
- Phone number fails a live lookup or comes back disconnected
- Business website is down or redirects to a parked-domain page
- Listing shows no reviews, hours updates, or activity in the past year
- Address matches a residential property on a commercial search
Business names, addresses, and phone numbers drift for ordinary reasons — a company moves, gets acquired, adds a location, or switches phone providers — and none of that reaches every directory on the same day. A dentist's office might update its Google listing within a week of moving but take months to reach an older directory, so the two sources disagree during the gap. That gap is exactly what verification is built to catch.
What do Google and Yelp actually confirm?
Both major sources publish a live status field you can check directly instead of guessing from review dates. The Google Places API documentation lists a business_status field (OPERATIONAL, CLOSED_TEMPORARILY, CLOSED_PERMANENTLY) alongside a formatted_phone_number field, and the Yelp Fusion API reference exposes the same kind of signal through is_closed and display_phone. A one-time scrape or a spreadsheet someone built last year has neither.
| Source | Confirms open or closed | Confirms current phone |
|---|---|---|
| Google Places API | Yes — business_status field | Yes — formatted_phone_number |
| Yelp Fusion API | Yes — is_closed field | Yes — display_phone |
| A single list exported months ago | No live check | No live check |
How do I spot duplicate listings across sources?
Duplicate listings usually happen because a business claimed a new location without closing the old one, or because a franchise location got indexed twice under slightly different names. Match on phone number first, not name — two listings sharing the same 10-digit phone number are almost always the same business, even if one says "Joe's Pizza" and the other says "Joe's Pizza & Pasta."
Address normalization catches the rest. Strip suite and unit numbers, standardize abbreviations like Street versus St, and compare the first line of the address. Two records that match on phone or normalized address should collapse into one before they ever reach your CRM. For a closer look at how the underlying sources differ, see Google Places API vs Outscraper vs SerpAPI.
How do I de-duplicate a list before importing it into a CRM?
A dedup pass is mechanical once you break it into steps, and it takes far less time than cleaning up a CRM full of duplicate contacts later.
- Normalize every phone number to digits only, dropping formatting and the leading 1.
- Normalize every address: pick one abbreviation standard and drop suite or unit numbers for the match pass.
- Sort by normalized phone number and flag any exact match as a duplicate pair.
- Sort by normalized address and flag close matches — same street number and name — as a second pass.
- For each flagged pair, keep the record with the more recent verification date and merge any notes from the other.
- Re-check both records against a live source before deleting either one, since some apparent duplicates are two real locations of the same chain.
What's the fastest way to verify data at scale?
Manually checking each record against Google and Yelp works fine for a list of 20. It breaks down past a few hundred, because every lookup is a separate browser tab and every result has to be typed back into a spreadsheet by hand. ExtractData runs that cross-reference automatically at search time — checking Google Places and Yelp Fusion for the same business together, flagging a closed or duplicate listing before it reaches your export, and timestamping each record so you know exactly how fresh it is.
See what's included on the pricing page.
Is manual verification really more expensive than a paid tool?
Manual verification does not cost money upfront, but it costs time, and time is what turns a list into calls. Checking 300 records by hand against two sources, at roughly a minute each, is about five hours before anyone dials a phone — five hours a rep could spend calling instead.
The honest tradeoff is volume. If you verify a few dozen records a month, doing it by hand is fine and free. Past that, the Free tier ($0) lets you test the cross-reference on a small batch before deciding whether the time saved is worth $29/mo on Pro, or $79/mo on Agency if you are reporting this back to clients.
The bottom line
A verified list beats a bigger list every time — a rep who trusts every number they dial makes more calls than one who has to skip every third one. Normalize your phone numbers and addresses, cross-check against two live sources, and re-verify anything older than a business quarter before you load it into your CRM.
Create a free account and pull a verified list for one zip code. It takes about five minutes, and every record comes back cross-referenced against Google and Yelp at the moment you search.
Frequently asked questions
What does NAP consistency mean?
NAP stands for name, address, and phone number. NAP consistency means those three fields match across every source you check a business against, such as Google, Yelp, and the business's own website. When they disagree, it usually means one source is outdated.
How often should I re-verify a business list?
Re-verify any record older than a business quarter, roughly every three months, before you contact it again. Lists you plan to call this week should get a full check now rather than relying on how they looked when you first pulled them.
What's the difference between a duplicate listing and a real second location?
A duplicate listing shares the same phone number or address as another record for the same business. A real second location has a different phone number and address entirely, even if the business name is identical, so always check both fields before merging two records.
How do I check if a business is permanently closed before I call it?
Check the business_status field from the Google Places API or the is_closed field from the Yelp Fusion API, both of which report live open or closed status. A phone number that fails a live lookup is a second confirming signal worth checking before you remove the record.
Can I de-duplicate a business list in a spreadsheet without special tools?
Yes. Normalize phone numbers to digits only and addresses to one abbreviation format, then sort and flag exact matches on either field. It is slower than an automated cross-reference but works fine for lists under a few hundred records.
Does ExtractData verify business data automatically?
Yes. ExtractData cross-references Google Places and Yelp Fusion for each business at search time, flags closed or duplicate listings before they reach your export, and timestamps every record so you can see how current it is.
Reviewed by the ExtractData Team — lead-generation and business-data guidance, updated August 2026.
Start extracting business data today
5 free searches daily. No credit card required.
Start extracting data free →