Pick where the records are going, drop in the CSV or spreadsheet, and find out what the import would reject, truncate or silently merge.
.csv, .tsv or .xlsx, up to 50 MB
The file is parsed in this browser tab. It is never uploaded — no code here sends it. What the browser enforces is narrower: this page can reach no server but our own and Cloudflare's analytics, which never receives your file.
Sample
sample-contacts.csv · 11 rows · 8 columns · 1 KB
6 of 11 rows will be rejected, or accepted with data lost. Fix or review them below.
8 of 8 columns matched to a field.
Two rows carry the same value in the field that identifies this record, so only one of them can arrive — and which one survives is decided by the import, not by you. Merge them before you import.
Detail: Email
Affected rows: 1, 2, 3, and 4
The importer rejects the row rather than the field. Correct it, or clear it and let the row import without an address.
Affected rows: 9
A leading =, + or @ makes the value execute rather than display when the file is opened in a spreadsheet, which is a known way to attack whoever opens the export. Stripping the prefix keeps the text and removes the behaviour.
Affected rows: 11
Identical in every column. Removing the copies changes nothing except the number of records you create.
Affected rows: 3
Same name at the same company, or the same phone number, under different identifiers — so the CRM will not catch it. Which record should survive is your decision, not a rule's.
Affected rows: 2 and 3
Some importers trim it and some store it as-is, which then never matches anything. Trimming is safe in both cases.
Affected rows: 1
The domain is a temporary-address provider. The record imports and the address stops working, usually within the hour.
Affected rows: 6
One character away from a very common domain, and not itself a domain that receives mail. The correction is a suggestion — check it before applying, because it could be a real company.
Affected rows: 2 and 3
Things like noreply@, none@ or an example.com address. The record imports and counts as reachable, which quietly overstates your list.
Affected rows: 7
Words, notes and extensions in a phone field break click-to-call and phone matching. The cleaned version keeps the digits and a leading plus.
Affected rows: 1 and 11
Fewer digits than the shortest national number in use. Usually a truncated cell or an internal extension in the wrong column.
Affected rows: 7 and 11
Values like N/A, unknown or a bare dash import as literal text and then have to be cleaned inside the CRM. Blanking them is the same information, correctly stated.
Affected rows: 9
They survive the import, and then every filter, sort and match has to account for them. Trimming changes nothing else.
Affected rows: 1
They survive the import, and then every filter, sort and match has to account for them. Trimming changes nothing else.
Affected rows: 1
Sequences like é and ’ mean the file was written as UTF-8 and read as something else. The repair reverses that exactly; if it looks wrong, re-export the file as UTF-8 instead.
Affected rows: 6
You tell the importer one format for the whole column, so the rows in the other format import as the wrong date — or as no date at all. Nothing here is converted for you: 03/09 means two different days depending on who wrote it.
About the file rather than any single row.
Names and addresses like test, asdf or a repeated character are usually left over from a form that was being tried out. They import as real people.
Affected rows: 7
Names and addresses like test, asdf or a repeated character are usually left over from a form that was being tried out. They import as real people.
Affected rows: 7
Names and addresses like test, asdf or a repeated character are usually left over from a form that was being tried out. They import as real people.
Affected rows: 7
Names and addresses like test, asdf or a repeated character are usually left over from a form that was being tried out. They import as real people.
Affected rows: 7
Most importers skip them, some create an empty record. Removing them costs nothing.
Affected rows: 10
Mail delivery does not care, but matching against records you already have often does. Lower-casing makes deduplication behave predictably.
Affected rows: 1
Addresses like info@ or sales@ reach a team, not a contact. Perfectly valid to import — just not as somebody you can address by name.
Affected rows: 5
Diallers stop at the main number and never reach the extension. Most CRMs have a separate extension field for it.
Affected rows: 1
The ones without will only dial from the country they were written in. Adding the right prefix needs a person: the tool will not guess a country from a bare number.
Detail: 4
About the file rather than any single row.
It imports exactly as written, and every template that greets people by name inherits the shouting. The suggested version is the same name in title case.
Affected rows: 2 and 3
Harmless in most fields, and a mismatch in any field you later filter or deduplicate on. Flattening them to plain ASCII is optional.
Affected rows: 5
Showing 11 of 11 rows
| # | First Name | Last Name | E-Mail Address | Phone Number | Company | Job Title | Country | Created |
|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
11 rows, 0 cells rewritten, 0 rows removed. Everything else is exactly as it was in your file.
Blockers remain. Rows carrying one will be rejected or will lose data on import.
