4 Ways to Export Contacts from iPhone to Excel or CSV without or with iTunes

2018-12-06 21:24:04 / Posted by Rosa Reyes to Utility Follow @ Rosa

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 (not separate CSV files for each contact)? ― A question from discussions.apple.com

There is actually more than one way to export contacts from iPhone to Excel XLS or CSV. This article will show you four different methods to do the exporting on Mac and PC. These methods are generally applicable, regardless of iPhone generations such as iPhone XR, iPhone X, iPhone 8, iPhone 7 or the older models.

Best way to export contacts from iPhone to Excel or CSV

Applicable to: Mac

Benefits:

  1. Export contacts from iPhone directly to Excel or CSV in 3 easy steps
  2. Can also export iPhone contacts to TXT, DOCX, Numbers, Pages, vCard, etc.
  3. Detect and merge/remove duplicate contacts (if any) at once
  4. Find and fix formatting issues (if any) at once

With Cisdem ContactsMate, you can easily export iPhone contacts to Excel or other formats you may need. Below are the step-by-step instructions. Of course, first, you need to download and install Cisdem ContactsMate on your Mac. A free trial is offered.

In a dialog box that appears upon opening it for the first time, you will be asked to give the app permission to access the Contacts app on your Mac. Click OK.

Instructions

Step 1. Make contacts to sync between iPhone and iCloud. Ignore this step if you have already down so. If you haven’t, go to Settings > (your name) > iCloud. Tap the toggle switch next to Contacts to enable it.

Step 2. Open ContactsMate. Click Add Account in the menu bar. The Internet Accounts window will show up.

cisdem contactsmate add account

Click iCloud and signing into it using your Apple ID and password. Select the checkbox next to Contacts. Close the window.

add iCloud account

Step 3. In the left panel of ContactsMate, you will find the group iCloud. Right-click on it. Click Export.

export contacts to Excel

A dialog box will appear. In the bottom-left corner of the dialog box, click Option. From the Format dropdown list, select Excel. Click Save.

export contacts to Excel

This is how to export contacts from iPhone to Excel on Mac. Before export the contacts to Excel, you can also use ContactsMate to easily find and merge duplicate contacts or fix formatting issues.

Note: You can also use ContactsMate and same steps to export iPad contacts to CSV or Excel with super ease.

Alternative method 1. Export contacts from iPhone to Excel or CSV with iTunes

Applicable to: Windows PC

You can also export iPhone contacts to Excel or CSV with iTunes, which is free. This method also involves the use of Windows Contacts, a contact manager on Windows 7, 8 and 10, and can be a bit complicated.

Step 1. Connect your iPhone to a PC installed with iTunes. Launch iTunes which will automatically detect the iPhone. Select your phone from the device section.

Step 2. In the left panel, click Info under the Summery tab.

Step 3. Select the checkbox next to Sync Contacts with.

Step 4. Select Windows Contacts. Select All contacts.

Step 5. Click Sync.

sync iPhone contacts via iTunes

Step 6. Search wab.exe in the Start Menu. Find your iPhone contacts synced from iTunes.

Step 7. Select Export in the top right corner. Select CSV (Comma Separated Values). Click Export.

export Windows Contacts to CSV

Step 8. Open the exported CSV file in Microsoft Excel and save it as Excel XLS.

Alternative method 2. Export contacts from iPhone to Excel or CSV with vCard to CSV converter

Applicable to: Windows PC & Mac

To export iPhone contacts to CSV without iTunes, you can use icloud.com and a vCard to CSV converter, which is free. To export them to XLS, you only need to convert CSV to Exel.

Step 1. Sync your iPhone contacts to iCloud.

Step 2. Go to icloud.com and log into your iCloud account. Click Contacts.

Step 3. Select all the contacts you need to export from iPhone to Excel.

Step 4. Click the gear-like icon in the bottom-left corner. Click Export vCard. Save the exported VCF file on your computer.

export iCloud contacts to vCard

Step 5. Go to labs.brotherli.ch/vcfconvert. Click Choose File to upload the VCF file.

Step 6. In the Format field, select CSV. Select Comma. Mark the checkbox next to Add header line. You can select or unselect the encoding and filtering options according to your needs.

vCard to CSV converter

Step 7. Click the convert button. Save the converted file.

Step 8. Open the converted CSV file in MS Excel and save it as Excel XLS if needed.

Alternative method 3. Export contacts from iPhone to Excel or CSV via Gmail

Applicable to: Windows PC & Mac

Another way to export contacts from iPhone to Excel or CSV without iTunes is to use Gmail or Google Contacts. There are two options.

Option 1

Step 1. Sync contacts from iPhone to iCloud.

Step 2. Go to icloud.com and export the contacts as vCard. You can find the detailed instructions in the third method.

Step 3. Sign into Google Contacts using your Gmail and password.

Step 4. Select your iPhone contacts and click Export from the More dropdown list.

Step 5. From the three export formats, select Google CSV or Outlook CSV according to your needs. Click Export.

export Google Contacts to CSV

Step 6. To export your iPhone contacts to Excel, open the exported CSV file in Microsoft Excel and save it as XLS.

Option 2

Step 1. Go to Settings on your iPhone. Select Contacts > Accounts > Add Account.

Step 2. Tap Google. Sign into using your Gmail and password.

Step 3. Enable the Contacts option by tapping the toggle switch next to it.

sync iPhone contacts to Gmail

Step 4. Export your iPhone contacts using Google Contacts to CSV or Excel by following the instructions in Option 1.

CSV vs. Excel: Which format is better when it comes to exporting contacts?

Excel and CSV are two popular export formats for iPhone contacts. Both formats can be opened and edited in Microsoft Excel. Which one should I choose when I export my iPhone contacts?

  Excel CSV
File extension .xls, .xlsx .csv
Type of format Spreadsheet Multi-platform, serial data streams
Store plain text Yes Yes
Store formatting Yes No
Compatibility Widely supported Limited

If you only export iPhone contacts to view and look up on your computer, then both formats are okay. If you need to import your iPhone contacts to a third party app or service that only supports Excel XLS, then Excel is the only choice. If you export your iPhone contacts only to back them up, then CSV is recommended. CSV is a widely used and supported format. You can later import contacts from the CSV file with ease to Android devices, Skype, Outlook, iCloud and many other devices or services.

Conclusion

The four ways to export contacts from iPhone to Excel are generally useful regardless lf iPhone models or iOS versions. If you are a Mac user, the first method is recommended. An effective contact management app will make it easy to sync, edit and manage contacts and help perform all your contact-related tasks.

Most Popular Downloads

New

Data Recovery Mac

Safe & affordable data recovery software for Mac.

49.99 69.99
Learn More
Hot

Duplicate File Finder Mac

Find and remove duplicate files on Mac.

19.99 29.99
Learn More

Hot Articles

  • How to Import Contacts into Outlook?

    We can store our contacts through many channels, like iPhone, mac and some media applications. With my situation, I prefer to manage all of my contacts at one place, it will be very easy to call, message or email someone. In order to make email be convenient, this article will introduce how to import contacts into outlook.

  • Tutorial: How to Delete Duplicate Contacts?

    Communication becomes more convenient through phone, message, Facebook, What’s App, Twitter, etc, but after we merge them at one place, there are so many duplicate contacts. In this tutorial, I will introduce some ways about how to delete duplicate contacts on iPhone, android and mac by the system itself or some contact management software.

  • 5 Solutions to Merge/Remove Duplicate Contacts on Mac (macOS Mojave Included)

    Many times, we are likely to repeat storing contacts of some people. Plenty of duplicate contacts caused a lot of inconvenience for contact management. So what we should to do to deal with those tiresome duplicate contacts? Merging duplicate contacts seems a good solution to this troublesome problem.

0 Comments Leave a Reply