Check a CRM import file for errors before you import it.

Find the problems that make imports fail or quietly create duplicates: repeated IDs, ZIP codes that lost their zero, phone and DNC columns that don’t line up, formula cells and unclear address columns.

Drop a CSV file here

Or choose one. CSV, tab or semicolon separated, up to 50 MB and 200,000 rows.

Your file is read by this page in your browser. It is not uploaded, stored or sent anywhere, and the check still works with the internet switched off.

Three steps, all on this page.

Open the export

Pick the CSV your list tool or spreadsheet wrote, or load the sample to see a messy one. The page reads the file locally; it never leaves your computer.

Read what it found

Each problem comes back as an error, a warning or a note, with a count and the rows affected, so you know what will break before the CRM tells you.

Take a safer copy

Download a fixed copy that only makes the safe changes, or a blank template with clean column names to fill in yourself.

The problems that cause the most damage after an import.

Repeated or missing record IDs

Rows with the same ID update the same contact, so all but the last are lost. Rows without one may be created as new contacts.

Numbers a spreadsheet changed

ZIP codes that lost their leading zero and long numbers shown as 2.12555E+09. Both have to be fixed at the source.

Phone numbers and emails

Numbers that are not 10-digit US numbers, mixed formats, and emails missing an @ or a domain. An Additional Phone Numbers list is checked in order; older Additional Phones headers work too.

Formula cells

Values that start with =, +, - or @ and could run as formulas when the file is opened.

Broken structure

Rows with more values than columns, usually an unquoted comma, a quote that never closes, and empty rows.

Column names

Values without a column name, the same name twice, and stray spaces that stop a saved mapping from matching.

Address roles

A column named only “Address” could be the property or the mailing address. The checker says which it probably is.

DNC pairs

Find numbered DNC flags with no matching number, flags whose number cannot be identified, numbers whose DNC cell is empty (not checked is not clear), and values like Clear or OK that read as permission. This checks your file’s columns, not any outside Do Not Call list, and it is not a live DNC lookup. Check what a contact-wide DND column means in your destination.

Company association

Some CRMs can create or associate companies from a contact’s Business Name or business email domain when those settings are on. Check the location’s company settings before importing.

Encoding

Files saved in an older Windows encoding, and characters already damaged before the file reached you.

A fixed copy, and a clean template.

The fixed copy only makes safe changes, each listed and counted: trimmed spaces, named and renamed columns, extra values kept in new columns, empty rows removed and formula values kept as text. Phone formatting and removing repeated rows are options you turn on.

It does not guess at your data.

It does not invent missing values, restore digits a spreadsheet already threw away, or decide which of two rows with the same ID is right. Those need the source file or a person.

Every check, and what the fixed copy does.

The checker reports 33 kinds of problem. The fixed copy changes only what is safe to change without the source file; everything else is reported so a person can decide.

CheckLevelWhat it findsFixed copy
Unclosed quoteErrorA quotation mark that never closes, so later rows merge into one valueReported
Extra valuesErrorRows with more values than columns, usually an unquoted commaKept in new Extra value columns
Missing valuesWarningRows with fewer values than columnsReported
Empty rowsInfoRows with nothing in themRemoved
Unnamed columnErrorValues under an empty column nameNamed Column N
Repeated column nameErrorTwo columns with the same nameSecond renamed with (2)
Spaces in column namesWarningLeading or trailing spaces that stop a saved mapping from matchingTrimmed
Spaces in valuesInfoLeading or trailing spaces that make near-duplicatesTrimmed
Older encodingWarningA file saved in an older Windows encoding instead of UTF-8Written as UTF-8
Damaged charactersWarningLetters already replaced by � before the file arrivedReported; fix at the source
Scientific notationErrorLong numbers shortened to a form like 2.12555E+09; the digits are goneReported; export again as text
ZIP lost its zeroErrorZIP codes such as 2108 that were 02108Reported; restore at the source
Formula-like valuesWarningValues starting with =, +, - or @ that a spreadsheet could run. Plain numbers and phones written as + and digits only are not flagged; +1 617 555 0144 isLeading apostrophe added; phone formatting avoids it for phones
No record ID columnInfoNo column the CRM can use to update the right recordReported
Repeated record IDErrorThe same ID on more than one row, so the last row winsReported
Missing record IDWarningRows with no ID, which may be created as new contactsReported
Identical rowsWarningRows that repeat another row exactlyRemoved if you turn it on
Not a 10-digit US numberWarningPhones that are too short, too long or not US numbersReported
Mixed phone formatsInfoUsable numbers written several different waysWritten as +1 numbers if you turn it on
Several phones in one cellWarningMore than one number in a single phone columnReported; split into Phone 1, Phone 2
Long additional-phone listWarningMore than ten additional numbers on one rowReported
Incomplete emailWarningAn address missing an @ or a domain, or several in one cellReported
Long additional-email listWarningMore than ten additional emails on one rowReported
Email overflowWarningAddresses beyond the primary and ten additional slotsReported
DNC flag with no numberErrorA numbered DNC value whose phone slot is emptyLeft as written
DNC flag with no clear numberErrorA flag that cannot be paired with one phone from the columnsLeft as written
Empty DNC cellWarningA number whose DNC cell is empty: not checked, not clearLeft empty
DNC word that reads as permissionWarningValues like Clear or OK instead of the actual resultLeft as written
Unrecognised DNC valueWarningFree text a CRM filter may not catchLeft as written
Contact-wide DND columnWarningA DND value that some CRMs apply to every channel, unlike a per-number DNC resultLeft as written
Business Name columnWarningA value some CRMs use to create or link a company recordLeft as written
Business email domainWarningDomains some CRMs use to create or link a company recordLeft as written
Unclear address columnInfoA column named only Address that could be the property or the mailing addressReported; rename it

A sample file with common problems, and the checker’s output.

The same synthetic file the Try a sample button loads (a header and eight rows), and the fixed copies the checker downloads for it. Every name, number and address is made up.

crm-import-sample.csv

Repeated and missing IDs, a phone in scientific notation, a ZIP without its zero, an unquoted comma, a formula, two numbers in one cell and two identical rows.

crm-import-sample-fixed.csv

Default fixed copy: the second Phone column renamed Phone (2), the extra value kept in its own column, the formula and the spaced +1 phone kept as text with a leading apostrophe. Everything else is reported, not changed.

crm-import-sample-fixed-all.csv

With phone formatting and duplicate removal turned on: US numbers written as +1 and ten digits, so none needs an apostrophe, and the repeated row removed.

How the files are made and checked.

  1. Made by the checker itself

    The fixed copies are downloaded from this page by a script, not written by hand, so they match what the tool does today.

  2. Checked by tests

    A test fails if the sample files differ from the checker’s output or if this table misses a check the code can report.

  3. A file check, not a data check

    It finds format problems. It does not test whether a number reaches anyone, look up any outside Do Not Call list or import into a CRM.

Trace your list and export it just as clean.

Every export we write follows these same rules, and your record IDs make it from upload to download.

3-day free trial, then $49 a month. Cancel anytime.