Free tool · runs 100% in your browser
CSV Preflight Checker
Check a CRM import file before it hits HubSpot, Salesforce, Pipedrive or Zoho. Drop a CSV and get an instant report on duplicate emails, role & invalid emails, blank required fields, non-E.164 phones, inconsistent country/state values, mixed date formats and encoding problems.
Privacy: the file is read by JavaScript on this page and never sent anywhere. No upload, no account, no tracking of file contents. You can disconnect from the internet after the page loads and it still works.
Drop a CSV here or click to choose a file
.csv / .tsv / .txt · comma, semicolon, tab or pipe delimited · checked locally
What the checker looks for
Duplicate emails
Case- and whitespace-insensitive matching, so Ana@Acme.com and ana@acme.com count as one contact. Most CRMs dedupe on email at import, so these rows either merge or get skipped.
Invalid & role emails
Syntax errors (missing @, spaces, double dots, no TLD) and shared inboxes like info@, sales@, support@, noreply@ that rarely belong to a person.
Blank required fields
You choose which columns are required. Whitespace-only cells and placeholders like N/A, null, - count as blank.
Phone format (E.164)
E.164 is + country code + number, digits only (e.g. +14155550123). Also catches Excel scientific notation like 1.41555E+10.
Country / state drift
US, USA, United States in one column break picklists, routing and reports. Same for CA vs California.
Mixed dates & encoding
Columns mixing 2024-03-05, 03/05/2024 and 5 Mar 2024; broken characters like José; non-UTF-8 files, stray control characters and ragged rows.
FAQ
Is my file uploaded?
No. The page uses the browser's FileReader API. Parsing and checks run on your device; nothing is sent to pureservices.store or anyone else.
Does it verify that emails exist?
No. It checks syntax and patterns only — it does not ping mail servers. Treat "valid syntax" as "worth importing", not "will deliver".
How big a file can it handle?
It depends on your device's memory; typical exports of tens of thousands of rows check in seconds on a laptop.
Does it fix the file?
It reports problems and gives fix steps. If you'd rather hand the fixing off, the $29 CRM Hygiene Scorecard gives you a written diagnosis of your full list, or see the CSV cleanup service.