Free - No signup - Your phone list stays in your browser

Validate a CSV phone list as E.164.

Pick the phone column and a default country, catch Excel damage, split extensions, check NANP structure and duplicates, then export a clean list and a masked flagged list.

A CSV phone validator normalizes every number in one column to E.164 (a + sign, country code, and at most 15 digits) or an RFC 3966 tel URI, and flags rows it cannot normalize safely. This workspace runs entirely in the tab and makes no carrier, HLR, or line-type lookup.

01 - How it works

From a messy column to one format.

The whole file is checked locally before any data download is enabled.

i. load

Open CSV or Excel

Drop a file, paste CSV, TSV, or semicolon text, or load an imperfect or ready sample. Excel sheets are converted in the tab.

ii. describe

Column and country

Confirm the suggested phone column, pick the default country for numbers without +, and choose E.164 or tel: URI output.

iii. export

Clean and flagged lists

Acknowledge that format is not reachability, then download the clean list, the masked flagged list, and a counts-only report.

02 - What it checks

Structure you can prove from the file.

Every rule names a severity, and nothing depends on an outside lookup.

  • 01

    Excel damage

    Scientific notation such as 1.23457E+11 blocks the row because digits are gone; missing trunk zeros in digits-only cells are reviews.

  • 02

    Country handling

    00 and 011 international prefixes become +, and the default country's trunk prefix is handled per its rule.

  • 03

    NANP structure

    +1 numbers need ten digits with area and office codes starting 2-9; N11 and 555-01XX fictional numbers are reviews.

  • 04

    Duplicates and extensions

    Exact normalized duplicates leave the clean list; ext., x, and # extensions move to their own column.

"A well-formed number is not proof it is assigned, reachable, or consented for calls/SMS."
csvtodashboard.com
Scope

Know what a format check cannot see.

The validator never contacts a carrier or lookup service.

  • No lookups

    Assignment, porting, line type, reachability, and do-not-call status are not queried.

  • Country rules

    Length rules are enforced only where sourced (E.164's 15-digit cap and the NANP ten-digit plan); other short numbers are reviews.

  • Consent

    Permission to call or text is a legal and business question outside the file. Keep consent records with the list.

03 - FAQ

Phone list CSV questions.

What is E.164 format for a phone number?
E.164 is the ITU-T international numbering plan. Written for machines, a number is a plus sign, the country calling code, and the national significant number with no spaces or punctuation, for example +12025550143. The whole number is at most 15 digits.
No. Parsing, normalization, checks, masked evidence, and downloads all happen in the current browser tab. No number is sent to a carrier, lookup service, or csvtodashboard.
No. The tool checks structure only. A well-formed number is not proof it is assigned, reachable, or consented for calls or SMS, and no carrier, HLR, or line-type lookup is made.
The column was stored as a number instead of text. Scientific notation in a saved CSV means digits were rounded away, so the original number must be recovered from the source system, not repaired from the file.
Keep the extension out of the main number. The validator moves ext., x, or # extensions into a separate column; in an RFC 3966 tel URI the extension becomes the ;ext= parameter.
You choose a default country. The validator removes that country's national trunk prefix where its rule is known, adds the calling code, and counts how many rows relied on the default.
NANPA reserves 555-0100 through 555-0199 for fictitious use in entertainment and advertising, so a +1 number in that range is flagged for review rather than treated as a real contact.
Exact duplicates after normalization, including the same extension, are blocked from the clean list and kept in the flagged list. The same number with a different extension is a review.