iPhone contacts to Excel — iCloud export to a spreadsheet
Export iPhone contacts from iCloud as a .vcf and turn them into an Excel sheet: names, every phone, emails, addresses and birthdays.
About this conversion
The iPhone itself has no “export to Excel”, but iCloud gives every contact out as a vCard: on icloud.com open Contacts, select all, then Export vCard. That file is the input here. iPhone cards carry Apple's own labels for phones and dates and often a photo; the labels are kept as column types, and the result is an .xlsx with one person per row that opens in Excel or Numbers.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
The same contacts, any way out
The file is read once and stays open, so the format is picked at the end: the same list
can leave here as CSV, CSV for Google Contacts, CSV for Outlook or PDF. Before that you can search it, see which people are saved
twice — the same number written as (555) 201-4477 in one file and
+15552014477 in another counts as one — and fold the duplicates into a single
card without losing any phone, address or note.
Questions
- Can I do it without iCloud?
- Share a contact from the Contacts app (or several, selected in the list) by mail or message — that is a .vcf too. Several such files can be dropped together.
- Are contact photos kept?
- Not in the spreadsheet — a cell cannot hold a picture. Save as vCard if you need them.