Bulk phone validation

Bulk phone number validation: upload a CSV, download the results

Validate a whole list of US and Canadian numbers from a CSV upload in your dashboard, with no code: up to 1,000,000 rows or 50 MB per file. We deduplicate the list, look up each unique number once, and hand back a results CSV with the same fields as the API.

  • Up to 1,000,000 rows
  • Duplicates billed once
  • Files deleted after delivery
Example: a 20,000-row CSV
Rows in the file
20,000
Unique numbers
16,000
Credits used
16,000
With the litigator scrub
32,000
Rows in the results
20,000

Duplicates are looked up and billed once, and still get their own row.

How it works

  1. Step 1

    Sign up and pick a plan

    The Free plan works for small lists once a card is on file. We verify it with your bank without charging it.

  2. Step 2

    Upload and check the preview

    Open Bulk CSV in the dashboard and choose a .csv file. We detect the header row and the phone column. You confirm them, optionally pick an IP column, and choose whether to keep your original columns.

  3. Step 3

    Pick add-ons

    The TCPA litigator scrub, the landline SMS lookup, and the free state DNC and complainer checks.

  4. Step 4

    Start the job

    We email you when the results file is ready, and you download it from the dashboard.

File requirements

WhatRequirement
Format.csv only. Export Excel files (.xlsx, .xls) to CSV first.
SizeUp to 1,000,000 rows or 50 MB per file.
DelimiterComma, semicolon or tab, detected automatically.
Phone numbersAny common format. Spaces, dashes, parentheses and + are stripped; each number has to come out as 10 digits, or 11 starting with 1. Rows without a valid US or Canadian number aren't looked up or billed.
Header rowOptional. Detected automatically; you can change it in the preview.
IP columnOptional. Map one to add IP-based location and ipResult per row.

What goes in and what comes out

An input file with a duplicate number, and the results with "keep my original columns" on. Selected columns shown; the real file has every column listed below.

Your file
name,phone
Jane Example,(212) 555-0147
Sam Sample,312-555-0142
Jane Example,(212) 555-0147
Results file
name,phone,subscriber,action,deliverable,nanpType,dipPorted,dipCarrier,dipCarrierType,timezone
Jane Example,(212) 555-0147,2125550147,send,true,mobile,false,AT&T,mobile,America/New_York
Jane Example,(212) 555-0147,2125550147,send,true,mobile,false,AT&T,mobile,America/New_York
Sam Sample,312-555-0142,3125550142,send,true,mobile,true,AT&T,mobile,America/Chicago

Three rows come back and two lookups are billed. Duplicate rows sit together, in the order each number first appears in your file.

Deduplication

Every row with a valid number gets a row in the results file, duplicates included, so the output lines up with your input. Behind the scenes each unique number is looked up and billed once. If you map an IP column, the same number with a different IP counts as a separate lookup, because each pair is its own location check.

What's in the results file

The results CSV uses the same field names as the API response, one column per field, plus credits_used. Add-on columns only appear when you switch the add-on on. If you keep your original columns, they come first.

GroupColumnsIncluded
Validation and deliverabilitysubscriber, optDate, action, deliverable, error, reason, deactivationDate, blackList, smsEligible, doNotSmsAlways
Line type and carriernanpType, nanpCarrier, dip, dipLrn, dipPorted, dipOcn, dipCarrier, dipCarrierType, dipCarrierSubTypeAlways
LocationipResult, geoCountry, geoState, geoCity, geoMetro, geoSource, timezone, tzOffsetAlways (ipResult is filled when you map an IP column)
Litigatorlitigator, litigator_type, litigator_nameWith the TCPA litigator scrub
Landline SMSThe five dipMessaging* fieldsWith the landline SMS lookup
State DNC and complainersdncStateChecked, dncStateResult, dncComplainerChecked, dncComplainerResult (plus the legacy dncOtherChecked and dncStateCovered)With the state DNC and complainer checks

What a job costs

Credits come from your plan, the same as API calls.

  • Base lookup

    1 credit

    Per unique number.

  • TCPA litigator scrub

    +1 credit

    Per unique number, when you switch it on.

  • Landline SMS lookup

    +1 credit

    Only when the number is a landline.

  • State DNC and complainers

    Free

    No extra credits.

Plans

A 20,000-row file with 16,000 unique numbers uses 16,000 credits, or 32,000 with the litigator scrub on.

  • Free $0/mo 500 lookups included Hard cap, no overage
  • 1K $5/mo 1,000 lookups included Then $0.005 each
  • 10K $30/mo 10,000 lookups included Then $0.003 each
  • 100K $100/mo 100,000 lookups included Then $0.001 each
  • 500K $450/mo 500,000 lookups included Then $0.0009 each

Failed lookups are free. Annual billing is 15% off. Above 500,000 lookups a month, ask for a volume quote. Every detail is on the pricing page.

Good to know

  • We don't keep your list

    The uploaded file is deleted once we've read it. The results file is deleted 1 hour after you download it, or 24 hours after the job finishes if you never do. See our privacy policy.

  • CSV upload or the live API?

    Use the CSV upload for lists you already have: a CRM export, a lead file, a list to scrub before a campaign. Use the live API when the answer has to come back while a user is on your form. Both return the same fields at the same price.

Bulk validation: common questions

How many phone numbers can I validate at once?

Up to 1,000,000 rows or 50 MB per CSV file. For more, split the list into several files.

Are duplicate numbers billed twice?

No. Each unique number is looked up and billed once, and every duplicate still gets its own row in the results file. If you map an IP column, each number and IP pair counts once.

Can I upload an Excel file?

Not directly. Export it as CSV from Excel, Numbers or Google Sheets first. Comma, semicolon and tab delimiters are all detected.

Do you keep my list?

No. The uploaded file is deleted once we have read it. The results file is deleted 1 hour after you download it, or 24 hours after the job finishes if you never do.

Can I run a bulk job on the Free plan?

Yes, once a card is on file (we verify it with your bank without charging it). The job has to fit in the free credits you have left that month, so larger files need a paid plan.

What if part of a job fails?

If a batch of numbers cannot be processed, its rows still appear in the results file with error set to "true" and the reason "batch failed", and they are not billed.

Validate your first list

The CSV uploader is in your dashboard. Create a free account to use it: 500 credits a month on the Free plan, paid plans from $5 a month.