Skip to content
Blink Brief
Language:

Guide · Office and email

How to export iPhone contacts to Excel (or print them), free, without an app

By Blink Brief · Updated  · How pages are made

On a computer, go to icloud.com/contacts, choose Select All Contacts, then Export vCard: Apple says it exports “a single vCard containing all of them”. Open that .vcf file in the free VCF viewer and press Download for Excel (.csv) for a sheet with one row per contact, or Print or save as PDF for a printed list. No app, and the file is read in the browser tab, never uploaded.

Short answer

  • Export: icloud.com/contacts › Select All Contacts › Export vCard (on a computer).
  • To Excel: VCF viewer › Choose a .vcf file › Download for Excel (.csv).
  • To print: Print or save as PDF in the viewer, or Print Contacts on iCloud.com.
  • Missing contacts: turn on Contacts for iCloud on the iPhone, or export from the account that holds them (Gmail, Outlook).

On a computer: iCloud.com › Export vCard

iCloud.com has the iPhone’s contacts when Contacts syncs with iCloud. Apple’s iOS 27 steps on the iPhone: go to Settings › [your name] › iCloud, tap See All next to Saved to iCloud, then turn on Contacts. Then, on the computer, Apple’s steps:

  1. Go to icloud.com/contacts and sign in to your Apple Account.
  2. Select the Select Menu button (a down arrow) and choose Select All Contacts. For some of them only, hold Command (Mac) or Control (Windows) and click each one.
  3. Select the Actions button and choose Export vCard.

Apple: “If you select multiple contacts, Contacts exports a single vCard containing all of them.” The .vcf file goes to the computer’s downloads. Selecting one contact exports one: if the file seems too small, check the count in the viewer before you go on.

On a Mac: the Contacts app

With the iPhone’s contacts on the Mac, Apple’s macOS 27 guide gives two routes. File › Export › Export vCard saves the selected contacts as one .vcf. Or select the contacts, drag them into a Numbers spreadsheet, and choose File › Export To, then Excel or CSV. Apple warns that this route includes fields you chose to keep private on your own card, such as notes and photos.

Open it in the VCF viewer: Download for Excel (.csv)

  1. Open the VCF viewer and press Choose a .vcf file, or drop the file on the box.
  2. Check the heading: it counts the contacts. Search the contacts finds one by name, number or email.
  3. Press Download for Excel (.csv) and open the file in Excel.

Each contact is one row, with the columns First name, Last name, Company, Title, Mobile, Home phone, Work phone, Other phones, Email 1 to 3, Address, Birthday, Website and Notes. The first mobile, home and work number each get their own column; any other number, such as a second mobile or one with a custom label like Babysitter, goes under Other phones, without its label. The file starts with a byte order mark, so Excel reads accents and Japanese names correctly, and a number that starts with + or 0 keeps it.

In a region that writes 1,5 for one and a half, as in Germany or France, Excel expects semicolons between columns: the viewer uses the separator of your browser’s language, and a second press saves the file with the other one. For Google Contacts or Outlook instead of Excel, Download for Google Contacts (.csv) and Download for Outlook (.csv) use those apps’ own column names; import a .vcf file into Outlook has the steps.

The file you open is read in this browser tab and never uploaded; close the tab and it’s gone.

  • From the VCF viewer: press Print or save as PDF. It prints the name, company, phones and emails of each contact, and nothing else from the page. Choose Letter or A4 in the print window, or Save as PDF.
  • From iCloud.com: Apple’s steps are icloud.com/contacts › Select Menu button › Select All Contacts (or select some) › Actions button › Print Contacts.
  • From Excel: after Download for Excel (.csv), hide the columns you don’t want and print the sheet.

On the iPhone only: export a list as contact cards

Apple’s iPhone User Guide for iOS 27 has an export in the Contacts app itself, for some or all contacts:

  1. Open the Contacts app and go to your lists.
  2. Touch and hold a list, or create one with Add List.
  3. Tap Export, select the fields to include, and confirm.
  4. Choose how to send or save the contact cards, such as Messages or Mail.

For a single contact, Apple’s steps are: tap the contact, tap Share Contact, choose the fields, then a way to send it. Mail the export to yourself and open the attachment in the VCF viewer on a computer, or in the iPhone’s browser. Untested: there was no iPhone here, so we can’t say what each screen shows or whether the file lands in the Files app.

Contacts not in iCloud (Gmail, Outlook accounts)

If iCloud.com shows fewer contacts than the iPhone, the others are likely saved in another account on the phone, such as Gmail, Outlook or an Exchange account at work. Export those from the account itself:

  • Google: at contacts.google.com, select the contacts, click More actions, then Export. Google offers a CSV or a vCard file.
  • Outlook.com or a Microsoft 365 account: in Outlook on the web, People › Manage contacts › Export contacts; in new Outlook, People › Export contacts. Microsoft’s export is a CSV file.

A .vcf from Google opens in the VCF viewer the same way, if you want the Excel columns above.

What the CSV keeps and leaves out

  • Kept: names, company and title, every phone number (the first mobile, home and work number in their own columns, any other in Other phones without its label), every email, the addresses (one cell), birthday, website and notes.
  • Left out: photos (a spreadsheet cell can’t hold one; the viewer marks contacts that have one), nicknames, social profiles, anniversaries and other dates, and fields an app adds for itself.
  • Every contact: the list shows the first 1,000, and every download keeps all of them.

To keep the photos, keep the .vcf: Download all (.vcf) writes the contacts as one vCard 3.0 file with their photos. To make a .vcf from a sheet instead, Excel to VCF converts a contact list.

Tested here: a .vcf shaped like an iCloud export (vCard 3.0, custom phone labels, a photo, accented and Japanese names, invented people) opened in the VCF viewer in Chromium and WebKit, and its Excel CSV checked. Not tested: iCloud.com, the iPhone’s and the Mac’s exports, and Excel itself, as no Apple or Microsoft account was signed in. More on the phone side: import a .vcf file on an iPhone or Android.

Questions

Can I export iPhone contacts to Excel for free?

Yes. With Contacts turned on for iCloud on the iPhone, go to icloud.com/contacts on a computer, choose Select All Contacts, then Export vCard. Open that file in the free VCF viewer and press Download for Excel (.csv): one row per contact, which Excel opens. No app to buy, and the file is read in the browser tab, never uploaded.

How do I print contacts from my iPhone without iCloud?

Apple’s iPhone guide has no print step, but it has an export that needs no iCloud.com: in the Contacts app, touch and hold a list, tap Export, choose the fields, and send the contact cards to yourself, by Mail for example. Open that file in the VCF viewer and press Print or save as PDF. We haven’t tried this route on an iPhone.

Can I export iPhone contacts to Excel without a computer?

Apple’s iOS 27 guide gives the export on the iPhone itself (Contacts › touch and hold a list › Export). The VCF viewer works in the iPhone’s browser too, so you can open the file there and download the CSV. We haven’t tested it on an iPhone; on a computer the iCloud.com route is Apple’s documented one.

Sources