How to Use csv2vcf to Migrate Contacts to Your Phone or Email

Convert CSV to VCF: Quick Guide for Contact Imports

What it is

Convert CSV to VCF is the process of transforming a CSV (comma-separated values) file—typically containing contact fields like name, phone, and email—into one or more VCF (vCard) files that devices and email clients can import as contacts.

Why use it

  • Compatibility: Most phones and contact apps accept vCard (VCF) but not raw CSVs.
  • Preserves fields: vCard supports structured fields (multiple phones, addresses, photos).
  • Batch imports: One VCF can contain many contacts for easy transfer.

Quick workflow (prescriptive)

  1. Prepare CSV
    • Ensure headers: use clear names like firstname, lastname, phone, email, address.
    • Normalize formats: phone numbers in international format, dates as YYYY-MM-DD.
    • Remove duplicates and empty rows.
  2. Map fields
    • Choose or create a mapping from CSV headers to vCard properties (e.g., phone → TEL; email → EMAIL; address → ADR).
    • Include type qualifiers if supported (TEL;TYPE=cell).
  3. Convert
    • Use a tool or script (e.g., csv2vcf utility, Python script) to read CSV and write VCF.
    • For command-line tools, specify input file, output file, and mapping if required.
  4. Validate
    • Open resulting VCF in a text editor or import into a contacts app to check field correctness.
    • Fix mapping or CSV issues and re-run if needed.
  5. Import
    • Import the VCF into your target device or service (Google Contacts, iPhone, Outlook). Follow the service’s import steps.

Common field mappings

  • firstname + lastname → FN, N
  • phone → TEL (with TYPE)
  • email → EMAIL
  • street, city, state, zip → ADR
  • company → ORG
  • title → TITLE
  • photo URL/base64 → PHOTO

Tools and approaches

  • Dedicated utilities named csv2vcf (CLI or GUI).
  • Short Python example: use the csv module and write vCard lines per contact.
  • Spreadsheet export + online converters (verify privacy before uploading).

Tips & pitfalls

  • Encoding: Save CSV as UTF-8 to preserve non‑ASCII characters.
  • Phone formats: Use +countrycode to ensure correct import.
  • Field limits: Some apps ignore uncommon vCard properties—stick to standard ones.
  • Privacy: Avoid uploading sensitive contact lists to untrusted online converters.

Minimal vCard example (vCard 3.0)

Code

BEGIN:VCARD VERSION:3.0 N:Doe;Jane;;; FN:Jane Doe TEL;TYPE=CELL:+1234567890 EMAIL:[email protected] END:VCARD

If you want, I can provide a ready-made csv2vcf script (Python or shell) tailored to your CSV headers.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *