How to Export iPhone Contacts to CSV

If you want to view your iPhone contacts in an Excel-compatible format, you can export your iPhone contacts to a CSV file. Read this post to get efficient ways to export iPhone, iCloud, Apple contacts to CSV.

Author Avatar Joy Taylor Last Updated: Feb. 28, 2022
AnyTrans – Export iPhone Contacts to Excel Easily

With AnyTrans installed, you can directly export iPhone contacts to CSV format and save them on your computer. Besides, you can also add contacts from your computer, sync contacts between iPhones, etc.

I wish to export all my iPhone contact data to a single excel worksheet. Is there a way to export the data to an xls or a csv format. I have the contacts in both my iPhone and the iCloud, but iCloud allows export as a vCard only.

Usually, you can backup your iPhone contacts by exporting with iCloud, and iTunes. However, you can only access contacts from iCloud by vCard. Most users prefer CSV files, which can open in many apps including Microsoft Excel. Then, how do I export iPhone Contacts to a CSV file?

This guide will focus on exporting iPhone contacts to a CSV file. And, you can export contacts from iPhone to computer in bulk. Just keep reading and find your way!

How to Export iPhone Contacts to CSV Directly

If you are looking for the easiest way to export your iPhone contacts to a CSV file, we’d like to recommend AnyTrans to you. It is a fully-featured iOS data management tool. So you can transfer your iPhone contacts over to a computer with CSV format. Once you connect your iPhone with a computer, you can first preview all the contacts on your iPhone and choose what to export. AnyTrans supports Windows PC and Mac computer, also, the latest iPhone 13 is supported.

Here are the steps to export iPhone contacts:

Step 1. Install the latest version of AnyTrans on your computer.

Free Download

Free Download

* 100% Clean & Safe

Free Download * 100% Clean & Safe

Step 2. Launch AnyTrans and plug in your iPhone via USB cable > Click the More button to find the Contacts tab.

Choose Device Manager and Click on More

Connect your iPhone and Go to Contacts

Step 3. Here you can view all your iPhone contacts (if your iCloud Contacts is enabled, first sign in your Apple ID). Select any contacts you want to export > Click To PC button > Choose Export as Google/Outlook CSV format.

Choose Contacts and Click To PC

Choose Contacts to Export as CSV

Step 4. Waiting for the transferring process completed, view exported contacts on your computer as below.

Check Exported iPhone Contacts on PC

Check Exported iPhone Contacts on PC

How to Export Apple Contacts

If you are using macOS Catalina, you can sync your contacts with Finder, which is the same as iTunes for transferring iPhone data with Mac. Once you synced contacts with Finder, you can export Apple contacts with the steps below:

  1. Launch Apple Contacts on your Mac.
  2. Click All Contacts from the top-left corner.
  3. Tap on the File and find Export.
  4. Choose Export vCard.

How to Export iPhone Contacts via iCloud

Since iPhone users normally sync their contacts with iCloud, you can actually export iCloud contacts to a CSV file and it will be equivalent to converting iPhone contacts to CSV.

The following are the steps you can follow to do the task on your device.

Step 1. On your iPhone, head to Settings > [your-name] > iCloud and turn on the option that says Contacts.

Enable iPhone contacts sync

Enable iPhone contacts sync

Step 2. Open a browser on your computer and head over to the iCloud website. Log-in to your account if you are not already.

Step 3. Click on the option that says Contacts on your screen.

Access contacts on iCloud

Access Contacts on iCloud

Step 4. Select all your contacts, click on the settings icon at the lower-left corner, and choose Export vCard.

Export Contacts from iCloud

Export Contacts from iCloud

To Export Apple Contacts and iCloud Contacts to CSV File

  1. With the above two methods, now you can get your contacts as vCard.
  2. Head over to the vCard converter site and upload your vCard file.
  3. Select CSV from the Format menu, Comma from the menu next to it.
  4. Click on convert at the bottom. It will download your iPhone contacts in a CSV file on your computer.
Convert Contacts to CSV

Convert Contacts to CSV

Export iPhone Contacts to CSV with iTunes

iTunes helps you sync your iPhone contacts with your computer and you can then export your contacts to any file format you want. This method only requires you to have a computer with iTunes installed on it and you are good to go.

The following steps should help you sync your contacts with iTunes and then export them in the CSV format.

Step 1. Connect your iPhone to your computer and launch the iTunes app.

Step 2. Click on your iPhone in the app and select the option that says Info in the left sidebar.

Access the Info Menu in iTunes

Access the Info Menu in iTunes

Step 3. Use the options on the right-hand side pane to sync your contacts with your computer.

Step 4. Open a File Explorer window and head over to the following path.

C:\Users\<username>\Contacts

Step 5. Click on the option that says Export to export your iPhone contacts.

Export Contacts from File Explorer

Export Contacts from File Explorer

Step 6. Select CSV from the format list and click on the Export button.

Export Contacts in CSV from File Explorer

Export Contacts in CSV from File Explorer

Your iPhone contacts will be exported in a CSV file on your computer.

Export iPhone Contacts to CSV via Outlook

The Outlook app on your computer can also be used to export iPhone contacts to a CSV file. First, you need to sync your contacts with Outlook and then export contacts from Outlook to a CSV file on your machine.

The below steps will help you accomplish the task on your computer.

Step 1. Download and install iCloud for Windows on your computer.

Step 2. Enable the Mail, Contacts, Calendars, and Tasks option while setting it up on your computer.

Sync iPhone Contacts with your Computer

Sync iPhone Contacts with your Computer

Step 3. Your iPhone contacts should now be available in Outlook and you can export them to a CSV file.

Step 4. Launch Outlook on your computer, click on File, select Open & Export, and finally click on Import/Export.

Import and Export Options in Outlook

Import and Export Options in Outlook

Step 5. Select Export to a file and click on Next.

Export Outlook Contacts to a File

Export Outlook Contacts to a File

Step 6. Choose Comma Separated Values, hit Next, choose your contacts on the following screen, and you will be all set.

Export Outlook Contacts to CSV

Export Outlook Contacts to CSV

Your contacts will be exported in CSV format.

Further ReadingHow to Sync Outlook Contacts with iPhone >

The Bottom Line

That’s all for how can you export iPhone contacts to CSV or excel. And, AnyTrans helps you export iPhone contacts to computer in bulk directly. Just free download it and have a try.

Free Download

Free Download

* 100% Clean & Safe

Free Download * 100% Clean & Safe

Author Avatar
Joy Taylor Twitter Share Facebook Share

Member of iMobie team as well as an Apple fan, love to help more users solve various types of iOS & Android related issues.

Back to Top Icon