iCloud Contacts VCF to CSV Converter

Turn iCloud contacts into a spreadsheet

A spreadsheet is the easiest way to review, sort or share a contact list, but iCloud exports contacts as a vCard (.vcf), not as CSV. This converter reads the vCard in your browser and writes a CSV file you can open in Excel, Numbers, LibreOffice or Google Sheets.

Export your contacts from iCloud first

1. Sign in to iCloud.com on a computer and open Contacts.
2. Select the contacts you need, or select all.
3. Choose Export vCard from the share or settings menu. A .vcf file is downloaded.
4. On a Mac you can instead select contacts in the Contacts app and use File, Export, Export vCard.

The converter only sees the file you choose. It does not connect to iCloud.

Choosing columns

Every field the converter understands is listed with the number of contacts that actually use it, so you can leave out empty columns. Name parts, nickname, organization, department, job title, phones, emails, addresses, websites, birthday, anniversary, other dates, social profiles, instant messaging, notes and categories are available.

Combined or expanded layout

• Combined puts all values of a kind in one cell, for example mobile: +1 555 555 0101; home: +1 555 555 0102. It is compact and easy to read.
• Expanded gives each value its own label and value columns, such as Phone 1 Label and Phone 1. It suits importing into CRM and mailing tools that expect one value per column. Addresses get street, city, region, postal code, country and PO box columns.

Excel-compatible output

The file is UTF-8 with a byte order mark, which tells Excel on Windows to read accented, Arabic, Chinese and emoji characters correctly instead of guessing an old code page. Values containing commas, quotes or line breaks are quoted according to RFC 4180. Notes and names can contain text written by anyone, so any cell that begins with =, +, - or @ is prefixed with an apostrophe. Spreadsheets then show it as text instead of running it as a formula.

What a CSV cannot hold

After you load a file, the converter lists exactly what will be missing from the CSV for that file: embedded or linked photos, contact group membership, custom fields added by other apps, fields you did not tick and extra values beyond the column limit. The original .vcf still contains all of it, so keep it as your backup.

vCard version notes

Versions 2.1, 3.0 and 4.0 are all read. Quoted-printable text from older phones is decoded, Apple custom labels are used as phone and email labels, and birthdays saved without a year are written as month and day only.

Limitations

• One file of up to 25 MB and 20,000 contacts at a time.
• Expanded mode creates at most 10 columns for a repeated field; extra values are listed as left out.

Privacy

Reading, converting and building the CSV all happen in your browser. The contacts file is not uploaded to A2Z Tools.

A2Z Tools is an independent service and is not affiliated with or endorsed by Apple Inc. iCloud, iPhone and Apple are trademarks of Apple Inc.