VCF to CSV Converter

How to use it

1. Add your fileChoose vCard to CSV and add one or more .vcf files, or choose CSV to vCard and add a CSV.
2. Check the previewEvery contact is one row. The first 50 are shown. For the CSV direction, the tool shows which of your columns it matched.
3. DownloadSave contacts.csv, or the .vcf file. Two options help when the CSV goes to Excel.

When people use it

• You are changing phones and want your contacts in a spreadsheet to clean up first.
• You have a list of customers or members in Excel and need it as a contacts file for a phone.
• You want to merge contacts from several .vcf files into one sheet.

Good to know

Contact apps store different fields, so the tool keeps what fits the columns and puts the rest of the phones, emails and addresses into Notes. Photos are not copied. Names with accents are kept, and the CSV is saved as UTF-8. A phone number is never changed, but Excel can change how it shows a number when it opens the CSV, so read the questions below about phone numbers before you open the file there. Check a few contacts in the result before you import it anywhere.

Worked example: two contacts from a phone

We added this vCard file, made up for the example. The first contact has a second phone with a custom label and a comma in the note. The second has an accented name and no email:

BEGIN:VCARD
VERSION:3.0
N:Okafor;Chidi;;;
FN:Chidi Okafor
ORG:Lagos Logistics Ltd;
TEL;type=CELL;type=pref:+234 803 123 4567
item1.TEL:0802 000 1111
item1.X-ABLabel:Office Line
EMAIL;type=WORK:[email protected]
NOTE:Met at expo\, brought samples
END:VCARD
BEGIN:VCARD
VERSION:3.0
N:Öztürk;Şeyma;;;
FN:Şeyma Öztürk
TEL;CELL:+90 532 000 0000
END:VCARD

The tool found 2 contacts and wrote contacts.csv:

Name,Given Name,Family Name,Organization,Title,Phone 1 Type,Phone 1,Phone 2 Type,Phone 2,Phone 3 Type,Phone 3,Email 1 Type,Email 1,Email 2 Type,Email 2,Address Type,Address,Website,Birthday,Notes
Chidi Okafor,Chidi,Okafor,Lagos Logistics Ltd,,Cell,+234 803 123 4567,Office Line,0802 000 1111,,,Work,[email protected],,,,,,,"Met at expo, brought samples"
Şeyma Öztürk,Şeyma,Öztürk,,,Cell,+90 532 000 0000,,,,,,,,,,,,,

• The type of the first phone is Cell. The pref marker is not a type, so it is ignored.
• The second phone kept its label. The line that starts with item1. is tied to the label Office Line, and that label became the type of Phone 2.
• The note with a comma is wrapped in quotes, so the comma does not split the cell.
• The accents in Şeyma Öztürk came across. The file starts with a UTF-8 marker so Excel shows them correctly, and that marker is not shown above.
• The second contact has blank cells where it has no email, address or note.

Where to go next

• If the same person appears twice, remove duplicate rows from the CSV.
• To combine contact lists from several people, merge the CSV files.
• To share a list without names and numbers, anonymize the CSV.