Data Quality & CRMJune 20, 2026· 5 min read
How to Clean Google Maps Data Before Importing It to Your CRM
A practical checklist to clean Google Maps data before a CRM import: remove duplicates, fix phone numbers, split addresses, verify emails and map every column.
By MapsDaddy Team
A fresh Google Maps export is close to CRM-ready, but not quite. If you clean Google Maps data before you import it, you avoid duplicate records, broken phone numbers and addresses your CRM can't read. Ten minutes of cleanup now saves hours of fixing records later. Here's the checklist we recommend for MapsDaddy lists, plus a column mapping table you can reuse.
Step 1: Keep the Raw File Before You Clean Google Maps Data
Download your list from Lists & Exports as CSV or Excel, and keep that file untouched. Work on a copy. If something goes wrong during cleanup or import, you can start again. Files also stay available to download again for 180 days, but a local copy is still a good habit.
Step 2: Remove Duplicates by Google Maps URL
The same business can show up more than once when you combine searches. This happens for a few reasons:
- Neighboring locations. A business near a city border can appear in searches for both cities.
- Related categories. A practice can come back for both "Dentist" and "Orthodontist".
- Several lists. If you merge exports from different weeks, some businesses will repeat.
Remove duplicates using the Google Maps URL column. Names aren't unique (think of chains), and branches of one business can share a phone number or a website. Each listing has its own Google Maps URL, which makes it the best key you have. If you need a second check, use the website domain, but skip rows where it's blank.
Before you delete a duplicate, look at the search_business_type column. If a business matched two categories, you may want to keep both as tags on one record.
Step 3: Check Against Your Existing CRM
Export your current accounts from your CRM and match them against the new file:
- Best match: Google Maps URL, if you saved it on earlier imports.
- Next best: website domain. Strip "https://", "www." and anything after the domain, then compare.
- Fallback: phone number in one standard format, plus the postal code from the address.
Decide what to do with matches before you import. You can skip them, or update fields like Rating and Rating Count on records you already have.
Step 4: Fix Phone Numbers
Put every phone number in one format, ideally the international format with a plus sign and country code, like +15035550148. Most CRMs and dialers handle it well, and it makes duplicate checks reliable. A spreadsheet formula can strip spaces, brackets and dashes, then add the country code for the country you searched.
If you open a CSV in Excel, import the Phone Number column as text so it isn't turned into a number. Open a CSV in Excel Without Breaking It shows how.
Step 5: Split the Address if Your CRM Needs It
The Address column holds the full address in one cell. Many CRMs want street, city, state and postal code in separate fields. Split it with your spreadsheet's text-to-columns tool or a short script, then spot-check a few rows, since address formats vary by country. The scraper export also has Latitude and Longitude columns, which are useful for territory planning and maps.
Step 6: Clean Websites, Emails and Categories
- Websites: remove tracking parameters, and flag sites that point to a social profile or a booking platform instead of the business's own domain.
- Emails: if you ran Find Business Email or Find Decision Makers, lowercase every email and run Verify Emails. Remove anything marked invalid. Our guide to verifying local business emails explains each result.
- Categories: use Category as the main industry field. The Services column lists other categories the business shows, which work well as tags.
Step 7: Remove What You Won't Work
Filter out businesses outside your service area, categories you don't sell to, and rows with no phone number and no website, unless you plan to visit in person. A smaller, clean list beats a big one full of records nobody will touch.
Map Your Columns
| MapsDaddy column | Suggested CRM field |
|---|---|
| Business Name | Company name |
| Website | Company domain |
| Phone Number | Company phone |
| Address | Street, city, state and postal code (after splitting) |
| Category and Services | Industry, plus tags |
| Rating and Rating Count | Custom number fields |
| Opening Hours | Custom text field or note |
| Google Maps URL | Custom field used as your unique key |
| search_business_type and search_business_locations | Lead source or campaign |
Lists from the Local Business Database have a slightly different set of columns, including Main Category and Categories, so adjust the mapping to match. Empty fields are normal. They're blank when Google Maps doesn't show that detail.
Tip: Set up a field mapping template in your CRM once and save it. Every future MapsDaddy import then takes a minute instead of twenty.
A Practical Example
You run searches for plumbers in four towns around Riverside and download one combined file of 610 rows. Sorting by Google Maps URL shows 45 duplicates, including Northside Plumbing Co., which came back for two towns. You merge those into one row each. Then you match the remaining 565 against your CRM by domain and find 70 businesses you already have. You update their ratings, import the other 495 as new records, and save the Google Maps URL on every one so next month's import is even easier.
Getting Started
Start with a clean source: run a search with the Google Maps Scraper, download the list as CSV or Excel, and work through this checklist once. After that, it becomes a quick routine for every new list.
Put this into practice