CSV misplaced data finder: emails in the name column, phones in the email column
In short: Upload a lead list. Each column is judged by its header, then every cell that looks like a different kind of value (an email address, a phone number or a website) is flagged. Where the right column is empty, or holds the swapped value, the value is moved there. Limit: It only judges columns whose header names the kind of value they hold.
Upload the list. Columns with an email, phone, website, name or company header are given a type, and a cell that clearly holds another type, such as an address in the name column, is flagged. A value goes to the matching column when that cell is empty, or swaps with a value that belongs in its old place; the rest are listed for you.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Two values moved, one pair swapped and one left as it was, across four rows.
- Rows affected
- 4
- Moved
- 2
- Swapped
- 1
What this means for you
Addresses stuck in the wrong column are back where they are checked and used.
- Judged by the column header
- Emails, phones and websites
- Never overwrites a filled cell
- Fixed list and findings download
- CSV
- Columns
- Cleanup
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
With the values in the right columns, check the addresses.
- Copy the Email column from the fixed list, or use the check button under the result.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I fix values that landed in the wrong column?
- Upload the .xlsx or CSV, or paste the cells with the header row first. Headers should say Email, Phone, Website, Name or Company.
- Read the counts of values moved, swapped and left, and the table of findings with the row number of each.
- Download the fixed list and the findings table, and check the rows marked Left as it was by hand.
- Check the addresses in the fixed list before you send.
Example
- You enter
- Five rows with Full name, Company, Email, Phone and Website columns: one correct row, one with a phone number in Email and an address in Phone, one with an address in Full name and Email empty, one with
example.ioin Company and Website empty, and one with an address in Phone while Email is filled. - You get
- Four rows have a problem: two values moved to the empty cells they belong in, one pair swapped, and one value left as it was because the Email cell it belongs in already holds a different address.
- Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
How does it know what a column should hold?
From its header. A header that says email expects addresses, one that says phone, mobile or tel expects numbers, one that says website, URL or domain expects a web address, and a header with name, company, title, city or country expects plain text. Columns with any other header are not judged. A value is flagged only when it clearly looks like a different kind: an address shape, 7 to 15 digits with phone punctuation, or a web address.
When does it move a value, and when does it only list it?
A value is moved when the column for its kind has an empty cell in that row. It is swapped when that cell holds a value that belongs where this one was found, as when a phone number sits in the Email column and an address in the Phone column. Otherwise it is listed as Left as it was, and you decide, because overwriting a filled cell would lose data.
What causes values to land in the wrong column?
Columns shifted by a comma inside an unquoted cell, a form whose fields were reordered, an export mapped by position, and copying from a web page. If whole rows are shifted, the CSV broken row fixer repairs the cell count first. Before you import, the CSV column editor handles renames and reordering.
Who uses this tool, and for what?
- Cold email senders
- Rescue addresses that sit in the name or company column so they are checked and used.
- Sales ops
- Clean a hand-typed or merged list before a CRM import.
- Agencies
- Find mapping mistakes in a client export before the sequence goes out.
What can’t this tool tell you?
- It only judges columns whose header names the kind of value they hold.
- A value is never written over a filled cell; those are listed instead.
- Only email addresses, phone numbers and websites are recognised as the wrong kind of value.
- A value that is the wrong kind but looks like plain text, such as a title in the company column, is not found.
Common questions
- What does it do when a name column holds an email address and the email cell is empty?
- It moves the address into the email column and leaves the name cell blank.
- Will it flag a company called example.io?
- A company cell that looks like a web address is flagged as a website and moved to the website column when that is empty. Check the findings table before you keep the change.
- Does it find columns that are out of order?
- No. It judges cells against their column's header. Whole columns in the wrong order are fixed in the column editor.
- What counts as a phone number?
- A cell of digits, spaces, brackets, dashes and an optional plus, with 7 to 15 digits. Other text is not treated as a phone number.
- Does it change cells it did not flag?
- No. Every other cell is copied across as it was.
- Is my file uploaded to SimpleVerifier?
- No. Everything runs in your browser.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.