How to use Contact Field Validator and Formatter
- Paste a contact table or choose one UTF-8 CSV or TSV file, then check its delimiter.
- 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.
- If national phone numbers need a prefix, choose their country explicitly. The tool applies only its bundled literal prefix rules; confirm the resulting number.
- 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.
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.