CRM Health Check: Free CRM Data Quality Checker
Paste a CSV export of contacts or companies to get a health score and a list of what to fix: invalid and duplicate emails, phone numbers with too few or too many digits, broken websites, names in capitals or lowercase, extra spaces and empty key fields, with the fill rate of every column. Nothing is uploaded. Free.
Columns are recognised by their header: email, phone, website and name. Works with exports from any CRM, spreadsheet or email tool, up to 10,000 rows. Results update as you type, and the text stays in this browser until you start over.
CRM health check example
An export of eight contacts has six columns: first and last name, email, phone, company and website.
| Issue | Rows |
|---|---|
| Invalid email: ben@contoso | 1 |
| Duplicate email of row 2 | 1 |
| Empty email | 1 |
| Name in capitals or lowercase | 2 |
| Health score | 37.5% |
Ten issues in five rows: besides the emails and names, one phone has only 5 digits, one website has a space instead of a dot and one company name ends with a space. Three of eight contacts are clean, so the score is 37.5%.
What the checker looks for
- Emails: one @, a domain with a dot, no repeats.
- Phones: 7 to 15 digits, ideally with the country code.
- Websites: no spaces and a dot in the address.
- Names: normal case, not ALL CAPS or lowercase.
- Every cell: no spaces at the start or end and no double spaces.
Keep your CRM healthy
Remove the duplicates with the CSV duplicate remover, check how the CRM itself is set up with the CRM audit checklist, and clean the data before a move with the CRM migration checklist.
Frequently asked questions
What does a CRM health check look at?
The records themselves: email addresses that cannot work, the same email on two contacts, phone numbers that are too short or too long, websites with typos, names in all capitals or lowercase, stray spaces and empty key fields. Each issue is listed with its row so you can fix it.
How is the health score calculated?
It is the share of rows with no issue at all. In the example, 3 of 8 contacts are clean, so the score is 37.5%. One bad field is enough to count a row, because a contact with a broken email or a duplicate needs attention either way.
How are emails and phone numbers checked?
An email needs one @ and a domain with a dot, and must not repeat an earlier row, ignoring case. A phone number needs 7 to 15 digits: the international E.164 standard allows at most 15, and fewer than 7 is never a full number with an area code.
Which empty fields count as issues?
By default only email and name columns, because a contact without them cannot be reached or greeted. Choose “Every column” to flag all empty cells, or “None” to ignore them. The fill rate of every column is shown either way.
How do I export my CRM data to CSV?
Most CRMs, including HubSpot, Salesforce, Pipedrive and Zoho, can export a contact or company list or a saved view to CSV from the list page. Include the columns you want checked, such as email, phone and website, and paste the file here.
Is my data uploaded or stored?
No. The CSV is read in your browser and the text is saved only in this browser so you can come back to it. Nothing you paste is sent to SalesBond or anyone else. Click Start over to clear it.
Related tools: CRM audit checklist, CSV duplicate remover, CRM migration checklist. More on sales and running a sales team on the SalesBond blog and the home page.
Official sources
- Wikipedia: E.164 — international phone numbers have at most 15 digits.
- Wikipedia: Email address — the parts of an address: local part, @ and domain.
- Wikipedia: Data quality — completeness, validity and uniqueness of records.
Updated on Nov 7, 2026. This calculator is for information only and is not tax, legal or payroll advice. The checks are about format, not truth: an address that looks valid may still not exist, and a correct-looking phone may be out of date.
