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.
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.
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.
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.
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.
Download a fixed copy that only makes the safe changes, or a blank template with clean column names to fill in yourself.
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.
ZIP codes that lost their leading zero and long numbers shown as 2.12555E+09. Both have to be fixed at the source.
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.
Values that start with =, +, - or @ and could run as formulas when the file is opened.
Rows with more values than columns, usually an unquoted comma, a quote that never closes, and empty rows.
Values without a column name, the same name twice, and stray spaces that stop a saved mapping from matching.
A column named only “Address” could be the property or the mailing address. The checker says which it probably is.
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.
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.
Files saved in an older Windows encoding, and characters already damaged before the file reached you.
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 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.
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.
| Check | Level | What it finds | Fixed copy |
|---|---|---|---|
| Unclosed quote | Error | A quotation mark that never closes, so later rows merge into one value | Reported |
| Extra values | Error | Rows with more values than columns, usually an unquoted comma | Kept in new Extra value columns |
| Missing values | Warning | Rows with fewer values than columns | Reported |
| Empty rows | Info | Rows with nothing in them | Removed |
| Unnamed column | Error | Values under an empty column name | Named Column N |
| Repeated column name | Error | Two columns with the same name | Second renamed with (2) |
| Spaces in column names | Warning | Leading or trailing spaces that stop a saved mapping from matching | Trimmed |
| Spaces in values | Info | Leading or trailing spaces that make near-duplicates | Trimmed |
| Older encoding | Warning | A file saved in an older Windows encoding instead of UTF-8 | Written as UTF-8 |
| Damaged characters | Warning | Letters already replaced by � before the file arrived | Reported; fix at the source |
| Scientific notation | Error | Long numbers shortened to a form like 2.12555E+09; the digits are gone | Reported; export again as text |
| ZIP lost its zero | Error | ZIP codes such as 2108 that were 02108 | Reported; restore at the source |
| Formula-like values | Warning | Values starting with =, +, - or @ that a spreadsheet could run. Plain numbers and phones written as + and digits only are not flagged; +1 617 555 0144 is | Leading apostrophe added; phone formatting avoids it for phones |
| No record ID column | Info | No column the CRM can use to update the right record | Reported |
| Repeated record ID | Error | The same ID on more than one row, so the last row wins | Reported |
| Missing record ID | Warning | Rows with no ID, which may be created as new contacts | Reported |
| Identical rows | Warning | Rows that repeat another row exactly | Removed if you turn it on |
| Not a 10-digit US number | Warning | Phones that are too short, too long or not US numbers | Reported |
| Mixed phone formats | Info | Usable numbers written several different ways | Written as +1 numbers if you turn it on |
| Several phones in one cell | Warning | More than one number in a single phone column | Reported; split into Phone 1, Phone 2 |
| Long additional-phone list | Warning | More than ten additional numbers on one row | Reported |
| Incomplete email | Warning | An address missing an @ or a domain, or several in one cell | Reported |
| Long additional-email list | Warning | More than ten additional emails on one row | Reported |
| Email overflow | Warning | Addresses beyond the primary and ten additional slots | Reported |
| DNC flag with no number | Error | A numbered DNC value whose phone slot is empty | Left as written |
| DNC flag with no clear number | Error | A flag that cannot be paired with one phone from the columns | Left as written |
| Empty DNC cell | Warning | A number whose DNC cell is empty: not checked, not clear | Left empty |
| DNC word that reads as permission | Warning | Values like Clear or OK instead of the actual result | Left as written |
| Unrecognised DNC value | Warning | Free text a CRM filter may not catch | Left as written |
| Contact-wide DND column | Warning | A DND value that some CRMs apply to every channel, unlike a per-number DNC result | Left as written |
| Business Name column | Warning | A value some CRMs use to create or link a company record | Left as written |
| Business email domain | Warning | Domains some CRMs use to create or link a company record | Left as written |
| Unclear address column | Info | A column named only Address that could be the property or the mailing address | Reported; rename it |
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.
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.
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.
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.
The fixed copies are downloaded from this page by a script, not written by hand, so they match what the tool does today.
A test fails if the sample files differ from the checker’s output or if this table misses a check the code can report.
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.
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.