Contact Field Validator and Formatter

Clean contact columns, apply an entered country prefix to national phone numbers and remove exact duplicate rows.

On-device No sign-up Free to use

Format contacts controls

Showing an example. Edit to see your own.

?

Paste a table or choose one UTF-8 file; up to 1 MiB, 5,000 rows and 30 columns.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    ?

    Uses a literal national prefix and calling code from the pinned Google metadata. It does not check local length, assignment, extensions or reachability.

    ?

    Only removes rows with identical original cells. Rows with different notes or other information are kept.

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Review the syntax of six contact values across Ada and Sam's two rows.

    Reviewed 6 contact values across 2 rows; 0 exact duplicate rows removed.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/contact-field-validator-formatter · 20 November 2026

    Was this helpful?

    How to use Contact Field Validator and Formatter

    1. Paste a contact table or choose one UTF-8 CSV or TSV file, then check its delimiter.
    2. Enter the exact headers for the email, phone and HTTP(S) URL columns you want to review. Leave a field blank to skip that contact type.
    3. If national phone numbers need a prefix, choose their country explicitly. The tool applies only its bundled literal prefix rules; confirm the resulting number.
    4. Optionally remove completely identical source rows. Run the review and compare each original, normalized value and status before using contacts-reviewed.csv or contact-review.json.

    Example: Contact Field Validator and Formatter

    Review the syntax of six contact values across Ada and Sam's two rows.

    You add
    Contact CSV / TSV: name,email,phone,url Ada,Ada@example.com,+1 (202) 555-0123,HTTPS://EXAMPLE.COM Sam,sam@example.com,+44 20 7946 0958,https://example.com/path; Email column name (blank skips): email; International phone column name (blank skips): phone; HTTP(S) URL column name (blank skips): url; Remove exact duplicate contact rows: false
    You get
    Reviewed 6 contact values across 2 rows; 0 exact duplicate rows removed.

    Options

    Contact CSV / TSV
    Paste a table or choose one UTF-8 file; up to 1 MiB, 5,000 rows and 30 columns.
    National phone number country (optional)
    Uses a literal national prefix and calling code from the pinned Google metadata. It does not check local length, assignment, extensions or reachability.
    Remove exact duplicate contact rows
    Only removes rows with identical original cells. Rows with different notes or other information are kept.

    Supported inputs and limits

    • One CSV/TSV table up to 1 MiB.
    • Original values and different source notes are retained.
    • Plain statuses report syntax or required review, not deliverability, reachability or ownership.
    • Country-prefix formatting uses the bundled source snapshot and simple literal prefixes; extensions and complex national dialing rules need review.
    • Deduplication removes identical complete source rows only.
    More details

    CSV formula guards can change exported text.

    Where your input is processed

    This tool does not upload your inputs. See the limits for anything saved on your device.

    Syntax-only results still need context

    A plausible address, international digit string or normalized URL does not prove that a mailbox exists, a number is assigned or a website is reachable. Review rows marked for manual checking instead of deleting them automatically. Export guards protect spreadsheet formula prefixes and may affect displayed text, so compare the resulting cells before replacing another contact list.

    Questions about Contact Field Validator and Formatter

    Does a valid email result mean the mailbox exists?

    No. It is a syntax check with no delivery or DNS request.

    Does phone formatting prove a number is assigned?

    No. It checks international digit syntax, not national numbering rules or assignment.

    Are original values overwritten?

    No. The review retains original cells alongside normalized values and findings.

    Page updated · Project managed by Tony Hines · Report a problem with Contact Field Validator and Formatter