How to Export iPhone Contacts to Excel or CSV with or without iCloud

Rosa Reyes
October 26, 2022 Preview 10.7K Preview 1
share it facebook share it Twitter

Sometimes in order to backup your iPhone contacts or to use them somewhere else (such as in an email client), you need to export contacts from an iPhone to an Excel spreadsheet. However, iPhone’s Contacts app only supports exporting a contact to a VCF file. Don’t worry. This article will show you how to easily export iPhone contacts to Excel (or CSV) in different ways.

 

Method 1. Export iPhone contacts to Excel easily with ContactsMate

Applies to: Mac

If you are a Mac user, you can use Cisdem ContactsMate to effortlessly export iPhone contacts to the format you need. It is a professional contacts manager app designed for efficiently manage and use all your contacts in one place and up-to-date.

Steps: How to export iPhone contacts to Excel or CSV

1. On your iPhone, go to Settings > [your name] > iCloud.

2. In the Apps Using iCloud section, turn on Contacts.

turn on Contacts

3. Click Merge. And now all your iPhone contacts are in iCloud.

4. Download and install ContactsMate.

Free Download

5. When you open the app for the first time, click OK to allow access.

click the OK button

6. Click Add Account.

click the Add Account button

7. On the right, click iCloud. Sign in to it.

click the iCloud option

8. Select the Contacts checkbox.

select the Contacts checkbox

9. Click the  button next to the Updated contacts detected message. Now you should see iCloud in the left sidebar. Clicking it will display your iPhone contacts.

iCloud in the left sidebar

10. Control-click (or right-click) iCloud and choose Export.

choose the Export option

11. To export your iPhone contacts to Excel, click the Format pop-up menu and choose Excel. Click Save.

choose the Excel format to export iPhone contacts to an Excel file

Now your iPhone contacts are exported to an Excel file.

If you want to export iPhone contacts to CSV instead, choose CSV in step 11.

Tips

Select the fields you want to export.  If you only need to export certain fields to your Excel file, such as contacts’ name and their phone numbers, this app can greatly meet your needs. Cisdem ContactsMate will export valid fields by default. But you can choose “Custom Fields” from the Field drop down menu in step 11, and then you are able to click the gear icon that appears to custom which fields to export. 

export fields

Backup contacts on iPhone and restore them.  Your iPhone contacts list contains many people’s phone number, email, address, birthday, etc. You may worried about lose them. Using ContactsMate to backup your iPhone contacts can be a good choice. To do that, go to menu bar and choose Cisdem ContactsMate. Enter the “Preferences” window. Click on Backup & Restore tab. After specifying the backup save path, select iCloud and click on “Backup” on the bottom. To restore them to your iPhone, just select the backup file then click on “Restore”.

backup iPhone contacts

Move iPhone contacts to other sources directly.  Some of you are finding ways of exporting contacts from iPhone to Excel in this article to import them into certain contacts systems. In fact, using ContactsMate can help you directly transfer iPhone contacts to other sources such as Outlook, Facebook, Exchange, Gmail, etc. Click “Add Account” in the sidebar. Sign in other Internet account with email address and password. Then you’ll find the contacts in this account have synced to this tool. Go to iCloud group then drag and drop selected iPhone contacts to another account group.

drag and drop iPhone contacts

Method 2. Export iPhone contacts to vCard and then convert vCard to Excel

Applies to: Windows PC, Mac

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

Here’s another method to do the export.

1. Follow the first three steps of the first method.

2. On your computer, go to www.icloud.com/contacts.

3. Click the Show Actions Menu icon the Show Actions Menu icon in the bottom-left corner of the page and choose Select All.

choose Select All to select all iPhone contacts for export

4. Click the same icon again and choose Export vCard.

5. A vCard file will be downloaded to your computer. The file contains all your iPhone contacts.

6. Go to www.aconvert.com/document.

7. Click Choose Files. Select the vCard file downloaded in step 5 and click Open.

8. Click the Target format pop-up menu and choose XLSX or XLS.

choose XLSX or XLS to export an Excel file

9. Click Convert Now.

10. When the conversion is done, click the Save icon.

11. Click the file URL to download the Excel file containing your iPhone contacts.

Method 3. Export contacts from iPhone to Excel using iTunes for free

Applies to: Windows PC

If you are not a fan of iCloud, this method is for you. The method involves the use of iTunes and Windows Contacts. The latter is a contact manager included in Windows 11, Windows 10 and some earlier Windows versions.

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.

2. In the left panel, click Info.

3. Select the checkbox next to Sync Contacts with.

4. Select Windows Contacts. Select All contacts.

5. Click Sync.

click the Sync button

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

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

click the Export button

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

Method 4. Export your iPhone contacts to Excel using Google

Applies to: Windows PC, Mac

It’s also possible to download iPhone contacts to an Excel file using Google Contacts.

1. On your iPhone, go to Settings > Contacts > Accounts.

2. Tap Google.

3. Sign in using your Google account.

4. Turn on Contacts. Now your iPhone contacts are in Google Contacts.

turn on Contacts

5. On your computer, go to contacts.google.com.

6. On the left, click Export.

7. In the Export as section, choose Outlook CSV or Google CSV. Click Export. Now your iPhone contacts are exported to a CSV file.

choose the Outlook CSV or Google CSV format

8. Open the CSV file in Microsoft Excel and save it as Excel Workbook (*.xlsx). Alternatively, you can use an online CSV to Excel converter.

Method 5. Export iOS contacts to Excel with SA Contacts Lite

Applies to: iPhone

The four methods above involve the use of a computer, and this method doesn’t. You can directly export the contacts on your phone to Excel, CSV and a few other file formats with an iOS app called SA Contacts Lite. It’s compatible with iOS 11 or later.

1. On your iPhone, open App Store.

2. Search for SA Contacts Lite.

3. Install the app on your iPhone.

4. When you open the app for the first time, tap OK to allow it to access your iPhone contacts.

5. If you want to export all your iPhone contacts, stick with the default All Contacts option in the Choose Contacts section. To export a contact group only, choose the Groups option and specify the group. You can also export selected contacts.

the Choose Contacts section provides the All Contacts option

6. To export your contacts to Excel, tap the Property Style pop-up menu and choose Outlook.

choose Outlook to export contacts from iPhone to an Excel file

7. Tap Start.

8. Select how you would like to receive the Excel file.

Benefits of exporting iPhone contacts to Excel

  • Backup iPhone contacts as an Excel file to avoid accidental deletion or loss of iPhone contacts.
  • Some contacts systems only supports importing contacts from Excel.
  • Excel file looks cleaner and allows us to easily remove unwanted columns.
  • Helps you easily organize large numbers of contacts. You can change the sort order of contacts in Excel.

Conclusion

This article describes five ways to export iPhone contacts to Excel, without iCloud or with it. The first four methods apply to almost all iPhone models (such as iPhone 14, iPhone 13, iPhone 12, iPhone 11, iPhone X, iPhone 8, iPhone 7 and iPhone 6) and all iOS versions (such as iOS 16, iOS 15, iOS 14, iOS 13, iOS 12, iOS 11, iOS 10 and iOS 9). Once your iPhone contacts are in an Excel spreadsheet, you can easily organize and use them.

avatar
Rosa Reyes
share it facebook share it Twitter

Rosa has worked in Mac software industry for more than eight years. She believes that the purpose of software is to make life better and work more productively. In addition to writing, Rosa is also an avid runner.

share it facebook share it Twitter
Comments (1) Leave a Reply

Name *

Comment *

  • Volker Zanetti

    This article was extremely helpful for me. Thank you Rosa!

    0 months ago Reply

    Name *

    Comment *

Hot Articles

How to Transfer Contacts from Android to Computer and Other Devices How to Export Contacts from Yahoo Mail Easily How to Delete Duplicate Contacts on iPhone in Bulk or Individually: 6 Easy Ways
Home > How to Export iPhone Contacts to Excel or CSV with or without iCloud