Remove duplicate phone numbers, whatever the format
Paste numbers or upload a CSV and this tool converts each number to E.164 before comparing, so +1 (415) 555-0100, 415.555.0100 and 4155550100 are recognised as one number. It keeps the first row for each number with all its other columns, and shows every removed row and the number it matched. It runs in your browser.
Used for numbers written without a + country code.
Sample result
2 duplicates removed from 5 rows, leaving 3 unique numbers.
- Duplicates removed
- 2
- Rows in
- 5
- Unique numbers
- 3
What this means for you
Stop calling or texting the same person twice, even when the number was typed differently.
- Normalises every number before comparing
- Catches the same number written differently
- Keeps the first row and all its columns
- Optional: treat extensions as separate
- Dedupe
- CSV
- E.164
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I remove duplicate phone numbers from a list?
- Paste one number per line, or upload a CSV up to 25 MB. The phone column is found automatically and the other columns are kept.
- Pick the default country. It's used for numbers written without a + code, so 020 7946 0958 is read as a London number only when the default is the United Kingdom.
- Decide whether extensions make numbers different. For a list of office lines where each extension is a different person, tick the option.
- Press Remove duplicates, check the removed rows, then download the cleaned CSV, optionally with an extra E.164 column.
Example
- You enter
- Five rows including
+1 (415) 555-0100,415.555.0100and(212) 555-0199twice, with United States as the default country. - You get
- 2 duplicates removed, leaving 3 unique numbers:
415.555.0100matched+1 (415) 555-0100after formatting to+14155550100, one(212) 555-0199was an exact repeat, and 1 row that isn't a valid number was matched as typed. - Limits
- Uploaded files can be up to 25 MB; there is no cap on the number of rows, and it all runs in your browser.
Why doesn't Excel remove duplicate phone numbers?
Because Excel compares text, and the same number written two ways is two different pieces of text. Spreadsheet duplicate removal compares text. To Excel, (415) 555-0100 and 415-555-0100 are different values, so both stay, and the same person gets two calls or two texts. Lists merged from a CRM, a web form and an event scanner almost always mix formats like this.
This tool parses each number with libphonenumber, Google's open-source numbering-plan library, and compares the E.164 result: a + sign, the country code and the national number with no spaces or punctuation. Two entries match when they are the same number, however they were typed.
How are numbers without a country code matched?
They're read using the default country you pick, so set it to the country most of your list is in. A number written without a + code is ambiguous. 020 7946 0958 is a London number only if you know it's British; read as American it isn't a valid number at all. The default country tells the parser how to read those entries. Numbers that already start with + or a recognised international prefix are read correctly whatever you pick.
If your list mixes countries and many numbers lack a + code, run phone number country lookup or add country codes first, then dedupe.
What happens to numbers that aren't valid?
They're kept, and matched against each other by their digits rather than dropped. Entries that aren't valid numbers for their country, such as a seven-digit US number without an area code, can't be converted to E.164. Rather than drop them, the tool compares their digits, so two copies of 555-1234 still match each other. They're counted separately in the results so you can fix or remove them.
Valid here means the digits fit a range allocated in that country's numbering plan. It doesn't mean the number is in service or still belongs to the person on your list; nothing in this tool contacts a carrier. For format fixes, use the phone number formatter; for whole-list guidance, see how to remove duplicate phone numbers.
Is this better than Excel's Remove Duplicates?
| This tool | Excel Remove Duplicates | |
|---|---|---|
| (415) 555-0100 vs 415.555.0100 | One number | Two different values |
| +44 20 7946 0958 vs +442079460958 | One number | Two different values |
| Extensions | Ignored or kept, your choice | Part of the text |
| Which rows were removed | Downloadable, with the match | Only a count |
Who uses this tool, and for what?
- SMS teams
- Dedupe a campaign list before upload so nobody gets the same text twice and you don't pay for the same number twice.
- Sales and dialer teams
- Merge lead exports into one call list where +1 (415) 555-0100 and 415-555-0100 don't land on two reps.
- CRM admins
- Find contact records that share a number before a migration, using the removed-rows download as the merge list.
- Agencies
- Clean client phone lists in any format into one deduplicated CSV with an added E.164 column for the SMS platform.
What can’t this tool tell you?
- Numbers written without a + code are read with the default country, so a mixed-country list needs a + on its foreign numbers.
- A valid number fits the numbering plan; the tool can't tell whether it is in service or still belongs to the same person.
- Two different people who share an office number are deduplicated to one row unless you keep extensions separate.
- First row wins; details from removed rows aren't merged into the kept row.
Common questions
- How do I remove duplicate phone numbers in Excel?
- Excel's Remove Duplicates only catches numbers typed identically. To catch (415) 555-0100 and 415.555.0100 as one, upload the sheet as a CSV here: each number is normalised to E.164 before comparing, and you download the deduplicated file with every other column kept.
- How do I remove duplicate mobile numbers in Excel?
- Save the sheet as CSV and run it through the tool above with the right default country. Mobile numbers written with and without the country code, spaces or a leading 0 are matched as one, and the first row for each number is kept.
- How do I remove duplicate contact numbers?
- Export the contacts as CSV (or convert a .vcf with the VCF to CSV converter), then upload it here. The phone column is found automatically, duplicates are removed by number rather than by spelling, and names and other columns stay on the kept row.
- Are there duplicate phone numbers?
- One phone number belongs to one line at a time, but the same number often appears many times in a list, written in different formats or attached to different people. Numbers are also reassigned over time, so an old duplicate may now reach someone else.
- Does this check whether the numbers work?
- No. It compares numbers and checks that they fit the numbering plan. It can't tell whether a line is in service, mobile or landline, or who holds it. That needs a live carrier lookup.
Sources
Well formatted is not the same as reachable.
This tool fixes how numbers are written. It cannot tell you whether a line is mobile, landline or VoIP, or which carrier holds it. That takes a live carrier lookup, which is what the Email + Phone plan adds.
- Upload a CSV up to 100,000 rows with an email or phone column
- 5,000 live carrier lookups a month: carrier name and real line type
- Emails in the same file get a real SMTP mailbox check
One plan, 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.