CSV / XLSX to VCF
Convert spreadsheet contacts (Name, Phone, Email) to .vcf vCard — 100% private client-side processing.
Active Converter
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.xlsxfile avoids delimiter ambiguity completely. - Line-Ending Compatibility (CRLF): RFC 2426 specifies
\r\n(CRLF) line endings for vCard records; older Outlook versions reject bare\nfiles, 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 Name | FN: & N: | Keep first and last names clean; avoid commas inside names. |
| Phone / Mobile / Tel | TEL;TYPE=CELL: | Use E.164 format (+212661...) for instant WhatsApp sync. |
| EMAIL;TYPE=INTERNET: | Single address per cell; strip trailing whitespace. | |
| Company / Organization | ORG: | Populates the company badge under the caller name on iOS/Android. |
Step-by-Step iPhone, Android & WhatsApp Business Import Checklist
- Format Phone Columns as Text in Excel: Before saving your workbook, select the phone column and choose Format Cells → Text so Excel never converts
+971501234567into scientific notation. - Generate One Combined Multi-Contact .VCF: Drop your
.xlsxor.csvfile into the workbench above to build a single RFC 2426 compliant vCard file containing all rows. - 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
.vcfto yourself and tap Add All Contacts, then open WhatsApp and tap Refresh so every customer name appears automatically.
Frequently Asked Questions
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.
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'.
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.
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.