Bulk Phone Number Validation: Check a Whole List in One Upload

To validate phone numbers in bulk, upload the list as a CSV to a bulk validator. Every number is checked against its country's numbering plan, converted to the international E.164 format, tagged with its country and line type, and marked valid or invalid. You then download the valid rows and import them into your CRM, dialer or SMS tool. If you also need the real carrier and line type, a carrier lookup runs on top of the same upload.

Doing this by hand works for a few dozen rows. Past that, a bulk check is faster, and it catches errors a spreadsheet can't see.

The four steps of bulk validation

1. Get the list into one CSV

Export from wherever the numbers live: your CRM, a lead tool, an event platform, a spreadsheet. Keep every column. A bulk validator adds new columns next to your data rather than replacing it.

Watch for one trap: opening a CSV in Excel can damage phone numbers before you start. Excel drops leading zeros (07911… becomes 7911…) and turns long numbers into scientific notation. Upload the file as it was exported, or see validating phone numbers in Excel for how to open it safely.

2. Check every number against the numbering plan

This is the core of bulk validation. Each number is parsed with the rules for its country: right length, allocated prefix, known type of range. Most tools, ours included, use Google's open-source libphonenumber metadata, which covers every country.

The check sorts each row into one of three groups:

Status	Meaning	Example
Valid	The number can exist in its country	+44 7911 123456
Invalid	Too short, too long, or in a range that isn't allocated	12345, +1 011 555 0100
Empty	No number in that row

3. Normalise every valid number

Valid numbers are rewritten in E.164: a +, the country code and the national number, with no spaces or punctuation. (415) 555-2671, 415.555.2671 and +1 415 555 2671 all become +14155552671.

This is what makes the list usable. Dialers and SMS platforms expect E.164, and duplicates only match once every copy of a number is written the same way. We cover the format in E.164 phone number format and the de-duplication step in removing duplicate phone numbers.

4. Tag country and line type

Each valid number gets its country and the line type its range was allocated for: mobile, landline, toll-free, VoIP and so on. Outside North America that tells you most of what you need. In the US and Canada, nearly every number comes back as "mobile or landline", because both types share area codes. That's where a carrier lookup comes in.

When to add carrier lookups

Add a carrier lookup when the line type changes what you do with a number. The most common reasons:

• You're about to text a US or Canadian list and need to drop landlines. See validating phone numbers for SMS.
• You want to flag VoIP numbers on sign-ups or lead forms. See how to check if a number is VoIP.
• You need the current carrier after porting. See phone carrier lookup.

What you need	Format validation	Carrier lookup
Remove numbers that can't exist	Yes	Yes
E.164 format, country	Yes	Yes
Mobile vs landline outside North America	Yes	Yes
Mobile vs landline in the US/Canada	No	Yes
VoIP numbers in ordinary ranges	No	Yes
Current carrier name	No	Yes
Cost per number	Nothing	A fraction of a cent

Neither check tells you whether a number is answered today. Numbers get disconnected and reassigned without leaving the valid ranges, so treat validation as a filter for numbers that can't be right, not proof that each one reaches a person.

How to do it in SimpleVerifier

1. Export a CSV with a phone column. Common names like phone, mobile, cell, telephone and direct phone are found automatically; if the header is unusual, the column whose cells look most like phone numbers is used. Files can be up to 100,000 rows.
2. Upload it on the verifier. Numbers written without a + and country code are read as US numbers, so add country codes to international lists before you upload.
3. Get four new columns on every row: phone_status (valid, invalid or empty), phone_e164, phone_country and phone_type.
4. On the Email + Phone plan, valid numbers also get a live carrier lookup: phone_carrier and phone_line_type (mobile, landline or VoIP). The plan includes 5,000 lookups a month for $49.99, and failed lookups don't count against the allowance.
5. Download the full file or only the valid phones.

If the file has an email column too, every address gets a live mailbox check in the same upload, so one file cleans both. The $29.99 Pro plan includes unlimited phone format, country and line-type checks; Email + Phone adds the carrier lookups.

Bulk validation in a spreadsheet instead

You can get part of the way with formulas: strip punctuation, check the length, and build E.164 for a single country. Our guides for Google Sheets and Excel have copy-paste formulas. What a spreadsheet can't do is know which ranges each country has actually allocated, or tell a mobile from a landline, because it has no numbering-plan data. For mixed-country lists, a bulk validator is the safer choice.

For code, the same library is available in most languages: see validating phone numbers in JavaScript and in Python.

Quick checklist

• Export as CSV and don't reopen it in Excel without setting the phone column to text.
• Include country codes for anything outside the US.
• Run format validation on every row; it's free to run at volume.
• Add carrier lookups only where line type or carrier matters.
• Import the phone_e164 column, not the original, so your tools see one clean format.

To test a single number first, use the free phone number validator.