The fastest way to get your iPhone contacts into Excel

The most direct route is to export your contacts through iCloud on a computer, then open the file in Excel. Apple does not offer a built-in iPhone-to-Excel export, but iCloud lets you download your contacts as a file that Excel can read. The process takes about five minutes and works whether you use an iPhone, Mac, or Windows computer.

You will need an iCloud account (the same one you use on your iPhone), a computer with a web browser, and Excel or another spreadsheet program. If you do not have Excel, Google Sheets and LibreOffice Calc both open the files iCloud creates.

Key Takeaways

  • iCloud is the fastest way to export contacts — sign in on a computer, select your contacts, and download them as a file Excel can open.
  • The file iCloud creates is a vCard (.vcf) file, which Excel opens but does not format perfectly; you may need to clean up the columns afterward.
  • If you use Google Contacts instead of iCloud, you can export directly to CSV format, which Excel reads more cleanly than vCard files.
  • Do not delete contacts from your iPhone until you have opened the exported file and confirmed all the data came through.

Exporting through iCloud on a computer

Go to iCloud.com in any web browser and sign in with your Apple ID — the same account you use on your iPhone. If you have two-factor authentication turned on, you will receive a code on your iPhone to complete the sign-in.

Click Contacts in the app grid. You will see all the contacts stored in your iCloud account. Select the contacts you want to export by clicking the first one, then holding Shift and clicking the last one to select a range, or by holding Command (Mac) or Ctrl (Windows) and clicking individual contacts. To select all contacts at once, press Command+A or Ctrl+A.

Once your contacts are selected, look for a gear icon or settings menu at the bottom left of the screen. Click it and choose Export vCard. Your browser will download a file with a .vcf extension — this is the format iCloud uses. Save it somewhere you can find it, like your Desktop or Downloads folder.

Opening the vCard file in Excel

Open Excel and go to File > Open. Navigate to the .vcf file you downloaded and select it. Excel will ask how you want to import the data — choose Delimited and click Next. On the next screen, uncheck all the delimiter options (Tab, Semicolon, Comma, Space) and click Next again.

Excel will show you a preview of how your contacts will look in the spreadsheet. The data will likely be messy — contact names, phone numbers, and email addresses may all be crammed into single cells or spread across columns in an order that does not match what you expected. This is normal. Click Finish to import the data anyway.

Once the file is open, you can clean it up manually. Separate phone numbers, email addresses, and names into their own columns by using the Text to Columns feature under the Data menu, or by copying and pasting data into the right cells. This step takes longer than the export itself, but it is necessary if you plan to sort or search by specific fields.

Using Google Contacts for cleaner Excel export

If you sync your iPhone contacts to a Google account, you can export them in CSV format, which Excel reads more cleanly than vCard files. Go to contacts.google.com, sign in with your Google account, and click the menu icon (three horizontal lines) in the top left.

Select Export and choose which contacts to download — you can export all contacts, a specific label, or a custom selection. Google will give you the option to export as Google CSV or Outlook CSV. Choose Google CSV for the most complete data. Download the file and open it directly in Excel — the columns will be labeled and organized much better than a vCard import.

To sync your iPhone contacts to Google Contacts in the first place, go to Settings > Contacts > Accounts & Passwords on your iPhone, add your Google account, and toggle Contacts on. Your iPhone contacts will sync to Google within a few minutes.

What happens to your contacts after export

Exporting your contacts does not remove them from your iPhone or iCloud account. The file you download is a copy. Your original contacts stay on your device and in iCloud until you manually delete them. This means you can export, check that the file looks right, and then decide whether to delete the originals.

If you plan to move to a different phone or service, keep the exported file in a safe place — cloud storage like Google Drive or OneDrive works well. If you ever need to import these contacts back into an iPhone or another device, most phones can read .vcf or CSV files directly.

Troubleshooting common export problems

If iCloud.com will not let you sign in, check that you are using the correct Apple ID and that two-factor authentication is set up on your account. If you see a message about your browser not being supported, try a different browser like Chrome or Firefox.

If the exported file is empty or contains only a few contacts, make sure you selected the right contacts before exporting. Some contacts may be stored on your SIM card or in a different account (like Gmail or Outlook) rather than in iCloud. Check Settings > Contacts on your iPhone to see which accounts are syncing contacts, and export from each one separately if needed.

If Excel shows strange characters or symbols in the contact data, the vCard file may have encoding issues. Try opening it in Google Sheets instead — Google Sheets often handles vCard formatting better than Excel. You can then download the cleaned-up version as a CSV file and open it in Excel.

Frequently Asked Questions

Can I export contacts directly from my iPhone without using a computer?

No, iPhone does not have a built-in export feature. You must use iCloud.com on a computer or sync your contacts to Google Contacts and export from there. Some third-party apps claim to export contacts, but they require you to grant access to your contact list and are not necessary for this task.

Will exporting my contacts to Excel remove them from my iPhone?

No. Exporting creates a copy of your contacts. They remain on your iPhone and in iCloud until you manually delete them. You can safely export, check the file, and keep the originals as long as you want.

What if some of my contacts are missing from the exported file?

Contacts stored only on your SIM card or in a separate account (like Gmail or Outlook) will not appear in an iCloud export. Check Settings > Contacts on your iPhone to see which accounts hold your contacts, and export from each account separately if needed.

Can I import the Excel file back into my iPhone later?

Yes, but not directly. You can upload the CSV file to Google Contacts, then sync Google Contacts to your iPhone. Alternatively, convert the CSV back to a vCard file and email it to yourself, then open it on your iPhone to add the contacts back.

Is there a way to export contacts without using iCloud?

If you sync your contacts to Google, Outlook, or another service, you can export from that service instead. Google Contacts exports to CSV, which Excel handles better than iCloud's vCard format. Check which accounts are syncing to your iPhone in Settings > Contacts > Accounts & Passwords.