Clean a phone number list in your browser for free.
Paste your numbers or choose a CSV and this cleaner writes every number the same way, takes out the duplicates and drops the numbers that cannot exist. Nothing is uploaded, so your list never leaves this tab.
Here is how the cleaner works in three steps.
- Paste a list or choose a fileOne number per line, or a CSV or TXT file. The cleaner finds the phone column for you.
- Pick the countryA number with no country code is read as a number from that country. A number that starts with + keeps its own.
- Clean it and downloadEvery number is written as E.164, repeats and impossible numbers come out, and you download the clean file.
The cleaner reads the first 10,000 rows of a list. It looks for a header row and for the column with the phone numbers in it, and you can pick another column or say that the first row is a header if it guessed wrong. A number comes out as E.164: a plus sign, the country code and the digits, with no spaces, dashes or brackets.
This is what the cleaner does to a small sample list.
These twelve rows are the sample you can load in the tool, cleaned as a United States list.
| Row as collected | What the cleaner finds | What you get |
|---|---|---|
| (212) 555-0101 | Valid. Formatting fixed. | +12125550101 |
| 212.555.0102 | Valid. Formatting fixed. | +12125550102 |
| +1 303 555 0103 | Valid. Formatting fixed. | +13035550103 |
| 3035550103 | Duplicate. Same number as row 3. | Removed. |
| 415-555-0104 | Valid. Formatting fixed. | +14155550104 |
| 555-0105 | Impossible number. Too short. | Removed. |
| 1 (617) 555 0106 | Valid. Formatting fixed. | +16175550106 |
| call after 5 | Impossible number. Not a phone number. | Removed. |
| +44 20 7946 0107 | Valid. Other country (United Kingdom), kept and marked. | +442079460107 |
| 2125550108 | Valid. Formatting fixed. | +12125550108 |
| (212) 555-0101 | Duplicate. Same number as row 1. | Removed. |
| +12025550199 | Already clean. | +12025550199 |
Every number is invented. The 555-01XX and 7946 0XXX ranges are set aside for fiction.
- 1 already clean
- 6 formatting fixed
- 1 other country
- 2 duplicates removed
- 2 impossible numbers
The cleaner fixes how numbers are written, and a live check tells you what each number is.
A clean list is a list that could work. These are the two halves of getting it ready to use.
Fixed here, free
- Writes every number as E.164, the format apps and bulk checkers expect. See phone number formats.
- Removes the repeats, however each one was typed.
- Removes numbers that cannot exist: empty, too short, too long or no such range.
- Marks numbers from a different country than the one you chose.
Found by a live check
- Whether the line is in service. Try the HLR lookup.
- Which carrier has the number today. Try the carrier lookup.
- Whether it is a mobile, a landline or a VoIP number. Try the phone line type lookup.
- Whether it moved to another carrier. Try the phone portability lookup.
- Whether it is on the Do Not Call list. Try the DNC check.
The bulk phone number checker runs those live checks on every row of a file. To see how clean a list is before you pay for anything, grade 25 of its rows in the lead list grader.
The guide to cleaning a phone number list puts all the steps in order, from this one to removing the people who opted out.
Get the carrier, the line type and whether each number is live.
Questions people ask before they clean a list.
Is my phone list uploaded anywhere?
No. The cleaner runs in your browser, so the text you paste or the file you choose is read on your own device and is never sent to us or to anyone else. We count how many lists are cleaned in rough size groups, never the numbers, the file name or anything else in the list.
What counts as a duplicate?
Two rows that are the same number once both are written as E.164. (212) 555-0101, 212.555.0101 and +1 212 555 0101 are one number. The first row stays, the later ones come out, and the removed rows file says which row each one repeated.
What is an impossible number?
A number that cannot exist: the cell is empty or has words in it, the number is too short or too long for its country, or it starts with digits that no number range of that country uses. The removed rows file gives the reason for each one.
What happens to numbers from another country?
They are kept and marked Other country, with their two-letter country code in the file, so you can filter them. A Canadian number in a list set to the United States is marked this way too, because it belongs to a different country even though both start with +1.
How do I keep the plus sign when I open the file in Excel?
Import the file instead of double-clicking it, and set the E.164 column to Text. Excel can drop the plus sign from a column it reads as a number, and on a long number it can show it in scientific notation.
How long a list can it clean?
The first 10,000 rows. A longer list is cut there, and the page shows how many rows the list had so you can clean the rest in a second pass or check the numbers in the bulk checker with a free trial.