How to use
VCF to Excel (CSV)
- Pick VCF → Excel (CSV) and drop a
.vcffile or paste its text. You can open several files and merge them. - Choose a column layout (Basic, Google Contacts CSV or Outlook CSV) and a phone format (hyphenated, digits only or as is). Turn on “Merge contacts with the same name and number” if the same person appears more than once.
- Check the table preview and press Download CSV.
Excel (CSV) to VCF
- Pick Excel (CSV) → VCF and open a CSV file, or copy a table from Excel and paste it.
- Columns are matched automatically from header names such as
Name,Mobile,EmailandCompany(Korean headers work too). Fix any column that was matched wrongly. - Choose vCard 3.0 (works on iPhone and Android) or 4.0 and press Download VCF to get every contact in one .vcf file.
Supported formats
| Item | Handling |
|---|---|
| vCard versions | Reads 2.1, 3.0 and 4.0; writes 3.0 and 4.0 |
| Encodings | ENCODING=QUOTED-PRINTABLE from 2.1 (soft line breaks with a trailing =, CHARSET=UTF-8 or EUC-KR). A file that is not valid UTF-8 is read as EUC-KR (CP949); CSV files saved by Korean Excel are read the same way |
| Properties | N, FN, TEL, EMAIL, ADR, ORG, TITLE, BDAY, NOTE, URL, group prefixes such as item1.TEL, several TYPE=CELL,VOICE values, X-PHONETIC-* |
| Photos | Not read; you are told how many were left out |
| Google and Outlook CSV | Google Contacts headers (Name, Given Name, Family Name, Phone 1 - Type, Phone 1 - Value, E-mail 1 - Type…) and Outlook headers (First Name, Last Name, Mobile Phone, Business Phone, E-mail Address…). Only a subset of the columns each service recognizes is written |
Korean phone number rules
The hyphenated format follows Korean numbering. Numbers that are not Korean are left as they are.
| Input | Result |
|---|---|
01012345678 |
010-1234-5678 |
+82 10-1234-5678 |
010-1234-5678 (+82 becomes 0) |
0212345678 |
02-1234-5678 |
0311234567 |
031-123-4567 |
15881234 |
1588-1234 (business hotline) |
1012345678 |
010-1234-5678 (a mobile number whose leading 0 Excel dropped) |
Values with extra text such as (home), foreign numbers and unknown patterns are not changed. “Digits only” turns +82 into 0 and removes the other symbols.
Name splitting and the VCF output
When the CSV has a single name column, the contact is saved as N:;홍길동;;; plus FN:홍길동. With “Split Korean names” on, a Hangul name of 2 or 3 characters takes its first character as the family name, and a 4-character name takes two characters when it starts with a double surname such as 남궁, 황보, 선우, 제갈, 독고, 사공 or 서문, giving N:홍;길동;;;. If separate last-name and first-name columns are mapped, they are used as they are. Commas, semicolons, backslashes and line breaks in values are escaped, and lines longer than 75 bytes are folded without cutting a UTF-8 character in half.
For example, with columns Name, Mobile, Email, Company, the row 홍길동, 010-1234-5678, gd@example.com, 가나다상사 becomes:
BEGIN:VCARD
VERSION:3.0
N:홍;길동;;;
FN:홍길동
TEL;TYPE=CELL:010-1234-5678
EMAIL;TYPE=INTERNET:gd@example.com
ORG:가나다상사
END:VCARD
Moving contacts on and off a phone
Menu names differ between devices and versions, so this is only the general route.
- iPhone: to export, use iCloud contacts on the web and export the selected contacts as vCard. To import a VCF, open the file and choose to add all contacts, or import the vCard through iCloud on the web.
- Android: in the Contacts app settings, use the import/export option to save or load a
.vcffile. - Google Contacts: on the web (contacts.google.com), export as Google CSV or vCard, and import CSV or vCard files.
To put a spreadsheet list on a phone: give the sheet a header row, make a VCF here, then import it as above. Try a few contacts first before importing everyone.
Garbled text and privacy
Excel on Windows shows non-English text as garbage when a CSV has no UTF-8 BOM. The CSV downloaded here includes the BOM, so it opens correctly with a double-click. In the other direction, CSV files saved by Korean Excel are usually EUC-KR, which this tool detects automatically. Excel also strips the leading 0 from digits-only numbers (01012345678), so the hyphenated format is safer. Values that start with =, +, - or @ can be run as formulas by Excel, so they are exported with a leading '.
Contacts hold personal data such as names, numbers and addresses. Be careful who receives the file and where it is stored.
Related tools
- JSON to CSV Converter | turn CSV into JSON and back
- ICS Calendar Viewer | open calendar files and export them to CSV
- Text Encoding Converter | convert between EUC-KR and UTF-8
- Remove Duplicate Lines | clean duplicate lines in a list
Your files are processed in this browser and never sent to a server.