Health check your file. Fix what matters.

Its checks fall into these groups: 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 row is counted once, under the most serious thing it needs: Must fix, Should fix or Tidy‑up, or Ready when it has no issues.

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

Fixes are on every plan and use no job. Remove duplicates (exact repeats and similar rows at 85% or more) and duplicate phone rows. Trim whitespace, clear placeholders, standardize dates, 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 the fixes you want, apply them together, 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 Data Health Check on it so you can see your updated score. After fixes, you can download the cleaned file or send it straight to the CRM Formatter for import into HubSpot, Salesforce, or Pipedrive.

On every plan, including Free, the report comes back in your file's format: a CSV with an Issues column at the front for a CSV, or an annotated Excel report for an Excel file. The Excel report colors each row's Issues cell by what the row needs: red for Must fix, amber for Should fix, gray for Tidy‑up. Apply Fixes always returns the file in the same format you uploaded.

Yes. The report's preview on the job page pages through every row the check covered, up to your plan's row limit, opening on the rows with issues, and you can search it or go to a row. The downloadable report lists those rows too, and Apply Fixes fixes the duplicates, blank rows and values written more than one way that it found.

Yes. After applying fixes, click "Format for CRM" next to the cleaned file. Operelio opens CRM Formatter on it, where you map columns to HubSpot, Salesforce, or Pipedrive fields and push directly. CRM push requires Starter, Pro, or Agency.