100% Client-Side Privacy
Adawaty Pro • adawaty-pro.com
48+ Offline Client-Side Converters & Technical Guides
Home / Legacy Data & Business / CSV / XLSX to VCF
Read Technical Guides →

CSV / XLSX to VCF

Convert spreadsheet contacts (Name, Phone, Email) to .vcf vCard — 100% private client-side processing.

100% Client-Side JS

Active Converter

Smart Auto-Fix:
1. Source File(s) or Paste Input: No file selected
2. Live Output (Editable):
Bulk Phonebook Generation (vCard 3.0)

CSV / Excel to VCF: Building Bulk iOS & Android vCard Contact Archives

Technical Anatomy of Spreadsheet-to-vCard Mapping

Smartphones cannot natively import raw .xlsx spreadsheets into their dialer address book—they require structured vCard 3.0 (.vcf) envelopes. Converting a CSV or Excel workbook into .vcf parses the header row to detect contact attributes, iterates over every data record, sanitizes reserved vCard delimiter characters (escaping commas and semicolons), and serializes each row into an RFC 2426 compliant block containing VERSION:3.0, FN, N, TEL;TYPE=CELL, EMAIL, and ORG.

Because SheetJS reads binary .xlsx workbooks directly in browser memory alongside plain UTF-8 .csv files, you can upload an entire company directory or WhatsApp broadcast customer list and produce a single multi-contact .vcf file in under a second.

Spreadsheet Row Input vs. Generated vCard 3.0 Output

# Input: Excel / CSV Sheet (clients.csv)
Name,Phone,Email,Company
"Sara Benali","+212662114455","sara@medtech.ma","MedTech Solutions"

# Generated Multi-Contact .VCF Output:
BEGIN:VCARD
VERSION:3.0
FN:Sara Benali
N:Benali;Sara;;;
TEL;TYPE=CELL:+212662114455
EMAIL;TYPE=INTERNET:sara@medtech.ma
ORG:MedTech Solutions
END:VCARD

Real-World Software & Hardware Ecosystem

E-commerce COD merchants, HR onboarding teams, and event organizers generate bulk .vcf files from Google Sheets, Microsoft Excel, Shopify / WooCommerce customer exports, and Airtable, then import them directly into iPhone Contacts, Android Google Contacts, WhatsApp Business (so customer names appear automatically in chats), and macOS Contacts.

Troubleshooting & Edge Cases

  • Missing Country Codes for WhatsApp: WhatsApp requires international E.164 phone prefixes (e.g., +971... or +212...) to match contacts reliably. Prepend country codes in Excel before generating your .vcf.
  • Semicolon-Delimited European CSVs: French, German, and Spanish Excel installations often export CSV files separated by semicolons (;) instead of commas. Uploading the native .xlsx file avoids delimiter ambiguity completely.
  • Line-Ending Compatibility (CRLF): RFC 2426 specifies \r\n (CRLF) line endings for vCard records; older Outlook versions reject bare \n files, so always verify clean line breaks before importing into desktop Outlook.

Spreadsheet Column Mapping Reference for vCard 3.0

Excel / CSV Column Header Target vCard 3.0 Property Formatting Tip for iOS & Android
Name / Full NameFN: & N:Keep first and last names clean; avoid commas inside names.
Phone / Mobile / TelTEL;TYPE=CELL:Use E.164 format (+212661...) for instant WhatsApp sync.
EmailEMAIL;TYPE=INTERNET:Single address per cell; strip trailing whitespace.
Company / OrganizationORG:Populates the company badge under the caller name on iOS/Android.

Step-by-Step iPhone, Android & WhatsApp Business Import Checklist

  1. Format Phone Columns as Text in Excel: Before saving your workbook, select the phone column and choose Format Cells → Text so Excel never converts +971501234567 into scientific notation.
  2. Generate One Combined Multi-Contact .VCF: Drop your .xlsx or .csv file into the workbench above to build a single RFC 2426 compliant vCard file containing all rows.
  3. Import Without Losing Existing Contacts: On Android, open Contacts → Fix & Manage → Import from file and pick your Google account. On iOS, AirDrop or email the .vcf to yourself and tap Add All Contacts, then open WhatsApp and tap Refresh so every customer name appears automatically.

Frequently Asked Questions

Which column headers should my Excel or CSV file use so contacts import cleanly into iPhone and Android?

Place Name (or Full Name), Phone (or Mobile/Tel), Email, and Organization (or Company) in row 1. Our mapper recognizes common header variations automatically and generates valid VERSION:3.0 vCard entries accepted by iCloud, Google Contacts, and Android.

How do I import the generated .VCF file into an iPhone without using iTunes?

Email the .vcf file to yourself or AirDrop it to your iPhone, tap the attachment, and choose 'Add All Contacts'. Alternatively, sign in to icloud.com/contacts, click the gear icon, and select 'Import vCard'.

Will international country codes like +212, +966, or +1 stay intact in the generated vCard?

Yes. Phone values are written directly into TEL;TYPE=CELL properties in E.164 international format. Avoid formatting phone columns in Excel as scientific notation before uploading.

Why did Android reject a vCard 4.0 file when vCard 3.0 worked?

Many stock Android dialers and older car Bluetooth systems only implement vCard 2.1 and 3.0 parsers. Generating standards-compliant VERSION:3.0 blocks with explicit FN and N properties ensures near-universal import compatibility across iOS, Android, and Outlook.