Health check your file. Fix what matters.

It runs 40+ checks grouped into categories: duplicates (exact and similar rows, similar company names), blanks and missing data (empty rows, empty and mostly-empty columns, rows with missing cells), email validation (invalid formats, duplicates, disposable domains, mixed domains within the same company), phone numbers (inconsistent formats, duplicates), formatting (mixed date formats, inconsistent casing, extra whitespace, placeholder values like N/A or TBD), data types (mixed types in the same column, statistical outliers), geographic consistency (country and state variants like US vs USA vs United States), and structural issues (blank or duplicate headers, columns with cut-off values, formula prefixes).

A number from 0 to 100 based on the severity and spread of issues found. Each row is scored individually, then the scores are averaged and adjusted for how widespread the problems are. 80 or above means ready to import. 60 to 79 means worth reviewing before you push to CRM. Below 60 means fix the data first. Every issue is tagged as high, medium, or low severity.

Health Check never modifies your file. It reads your data and shows you what it found. If you choose to apply fixes (a Pro feature), Operelio creates a separate cleaned file. Your original upload is always preserved.

On Pro, Team, and Agency plans you can apply one-click fixes. Remove exact duplicates, similar rows (90%+ or 85–89% match bands), and duplicate phone rows. Trim whitespace, clear placeholders, standardize dates, standardize phone formats, standardize country and state names, fix casing, repair broken characters, strip formula prefixes, unify similar company name variants, standardize email domains and name formats across the same company, remove disposable email rows, remove blank rows, and drop empty or mostly-empty columns. Select what you want fixed and Operelio generates a new cleaned file.

Some issues like invalid email addresses, blank cells, and type mismatches are flagged for manual review because they need human judgment. The report tells you exactly which rows are affected so you can fix them quickly. Operelio also has standalone tools for bulk find and replace, advanced deduplication with adjustable thresholds, and filtering out rows that don't meet your criteria.

Operelio generates a new cleaned file and re-runs Health Check on it so you can see your updated score. For email domain or name format conflicts where there's a tie, you choose which format to standardize to before applying. After fixes, you can download the cleaned file or send it straight to the CRM Formatter for import into HubSpot, Salesforce, or Pipedrive.

On Free, you get a CSV report with an Issues column at the front. On Pro, Team, and Agency, you can choose CSV or annotated Excel. The Excel report colors the text in each row by its highest-severity issue: red for high, amber for medium, green for low. Apply Fixes always returns the file in the same format you uploaded.

The report page shows the first 50 example groups per category to keep things readable. The downloadable report file lists every row affected. Apply Fixes also operates on every detected issue, not just the first 50.

Yes. After applying fixes, click "Send to CRM Formatter" from the results page. Operelio carries the cleaned file across, where you map columns to HubSpot, Salesforce, or Pipedrive fields and push directly. CRM push requires Pro, Team, or Agency.