UseFreeTools

Contact Field Validator and Formatter

Review contact columns in CSV while retaining originals and marking syntax or normalization issues.

Files stay on your device No sign-up Free to use
How this works

The tool runs in this browser. Your file or text is not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

Privacy details

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

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

    How to use Contact Field Validator and Formatter

    1. Paste contact CSV and name the relevant columns.
    2. Run the syntax and formatting review.
    3. Compare originals, normalized values and row findings before using the export.

    Example: Contact Field Validator and Formatter

    CSV contact rows containing [email protected], +1 202 555 0123 and an HTTPS URL.

    You add
    Contact CSV / TSV: name,email,phone,url Ada,[email protected],+1 (202) 555-0123,HTTPS://EXAMPLE.COM Sam,[email protected],+44 20 7946 0958,https://example.com/path Delimiter: Email column name (blank skips): email International phone column name (blank skips): phone HTTP(S) URL column name (blank skips): url
    You get
    Reviewed 6 contact values across 2 rows. Sample rows: 1 | email | [email protected] | [email protected] | syntax-only | Local-part case retained; domain lowercased. Existence and delivery are not checked.; 1 | phone | +1 (202) 555-0123 | +12025550123 | syntax-only | E.164-like digit syntax only; country assignment, length by locale and reachability are not validated..

    Options

    Input source
    Paste the table or select one UTF-8 CSV/TSV file. Clear the pasted text before choosing a file; the tool refuses two simultaneous sources.
    Column names
    Match the exact header for each contact type. Leave a name blank to skip that type. Original columns remain beside the added normalized values and status columns.

    Supported inputs and limits

    Pragmatic email syntax, E.164-like international phone syntax and HTTP(S) URL normalization only. No locale number validity, mailbox deliverability, DNS checks or URL fetch. Quoted and internationalized email forms need separate review. Export cells have spreadsheet formula protection.

    Where your input is processed

    This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save 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.

    Project manager: Tony Hines · Content updated 4 October 2026 · Report a problem

    Related tools

    All tools in Data and Spreadsheets

    CSV Viewer

    Filter, sort and export matching CSV rows.