How to Export iPhone Contacts to CSV

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.

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

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.

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

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.

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.

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

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.

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.

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.

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

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.

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.

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

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

Your contacts will be exported in CSV format.

Further Reading: How 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.