The fastest way: use iCloud on a computer

The simplest route is to sign into iCloud on a web browser, read your contacts as a file, and open that file in Excel. This works on any computer — Mac or Windows — and takes about five minutes.

Go to iCloud.com in any web browser and sign in with your Apple ID and password. Click Contacts. Select all your contacts by pressing Ctrl+A (Windows) or Command+A (Mac). Click the gear icon at the bottom left, then choose Export vCard. This downloads a file called contacts.vcf to your computer.

Open Excel and go to File > Open. Find the contacts.vcf file you just downloaded. Excel will ask how you want to import it — choose Delimited and click Next. On the next screen, check the box for Comma and click Finish. Your contacts now appear as rows in a spreadsheet, with names, phone numbers, and email addresses in separate columns.

Key Takeaways

  • iCloud.com is the fastest method because it works on any computer and requires no software installation.
  • The contacts.vcf file that iCloud exports can be opened directly in Excel and will automatically split into columns.
  • If you use a Mac, the Contacts app can also export directly to Excel without needing a web browser.
  • Third-party apps like PhoneView or iMazing can export contacts if iCloud is not available to you.

Exporting from the Contacts app on a Mac

If you have a Mac, you can skip the web browser and export straight from the Contacts app. Open Contacts, select all contacts with Command+A, then go to File > Export > Export vCard. Save the file to your desktop.

Open Excel and follow the same import steps as above: File > Open, select the vCard file, choose Delimited, check Comma, and click Finish. The contacts will populate into columns automatically.

What happens if you only have an iPhone

You cannot export contacts directly from an iPhone to Excel — the iPhone does not have a built-in export feature. You must use a computer. If you do not have access to a Mac or Windows PC, you can borrow one for the five minutes this takes, or use a library or internet café computer.

The iCloud method works even if you have never used iCloud before. As long as your iPhone is set up with an Apple ID, your contacts are already synced to iCloud automatically. You just need to sign in at iCloud.com to retrieve them.

Using third-party apps if iCloud is not an option

If you cannot access iCloud for some reason, apps like PhoneView (Mac only) or iMazing (Mac and Windows) can connect your iPhone to a computer and export contacts. These apps cost money — iMazing is around $40 for a one-time purchase — but they work if iCloud is blocked or unavailable.

PhoneView costs about $30 and runs only on Mac. Both apps let you plug in your iPhone, browse your contacts, and export them as a vCard or CSV file that Excel can open. This route is slower and more expensive than iCloud, so use it only if iCloud genuinely will not work for you.

Organizing your contacts once they are in Excel

Once your contacts are in Excel, you may notice that some columns are empty or that names and numbers are not split the way you want. You can rearrange columns by right-clicking a column header and choosing Insert or Delete. You can also sort by last name, company, or any other column by clicking a cell and going to Data > Sort.

If a contact has multiple phone numbers and they all landed in one cell, you can split them manually or use Excel's Text to Columns feature under the Data menu. Highlight the column with the mixed data, click Text to Columns, choose Delimited, and pick the character that separates the numbers — usually a comma or semicolon.

Keeping your Excel file and iPhone in sync

Excel and your iPhone do not automatically stay in sync. If you add a new contact to your iPhone, it will not appear in your Excel file unless you export again. If you edit a contact in Excel and want it to update on your iPhone, you need to import the file back into iCloud or your iPhone.

To import an edited Excel file back to your iPhone, save it as a CSV file in Excel (File > Save As, then choose CSV from the format dropdown). Go to iCloud.com, click Contacts, click the gear icon, and choose Import vCard. Select your CSV file. The contacts will merge with your existing ones — duplicates will not be created if the names and numbers match.

Troubleshooting common problems

If Excel does not open your vCard file, try renaming it from contacts.vcf to contacts.csv before opening. Some versions of Excel prefer the CSV format. If that does not work, open Excel first, go to File > Open, and change the file type filter at the bottom to All Files before selecting the vCard.

If your contacts appear in one giant column instead of split across multiple columns, you skipped the Delimited step. Close the file without saving, open it again, and this time choose Delimited when Excel asks how to import it. If special characters like accents or emoji in names cause problems, save your Excel file as CSV UTF-8 instead of the default format — go to File > Save As and pick that option from the format list.

Frequently Asked Questions

Do I need to pay for anything to export my contacts?

No. iCloud is free, and Excel is usually already on your computer. If you own an iPhone, you already have an Apple ID and iCloud access. The only reason to pay is if iCloud does not work for you and you need a third-party app like iMazing.

Will exporting my contacts delete them from my iPhone?

No. Exporting makes a copy. Your contacts stay on your iPhone exactly as they are. You can export as many times as you want without losing anything.

What if some of my contacts are missing from the export?

Contacts stored only on your SIM card or in other apps like Gmail or Outlook will not appear in the iCloud export. To get those, you need to export from each app separately or add them to your iPhone's main Contacts app first. Go to Settings > Contacts and make sure Default Account is set to iCloud, then sync any other contact sources manually.

Can I export just some of my contacts instead of all of them?

iCloud exports everything at once. If you need only certain contacts, export all of them and then delete the rows you do not want in Excel. Alternatively, some third-party apps like iMazing let you select individual contacts before exporting, but you will pay for that convenience.

What format should I save the Excel file in?

Save it as .xlsx (the standard Excel format) unless you need to import it back into iCloud or another service, in which case save it as .csv. CSV is a simpler format that more programs can read, but it does not preserve Excel formatting like colors or merged cells.