How to export all contacts from iphone to excel

Use vCard files or Excel/CVS format to transfer contact data to other platforms

Updated on February 17, 2022

What to Know

• Easiest option: Get the Export Contact app and allow it to access your contacts. Select a file format > tap Continue > Export.
  
• Next easiest: Settings > your name > iCloud > turn on Contacts > exit. Go to iCloud > Contacts > Select all > Export vCard.
• Save or share the file to use in Excel or however you wish.

This article explains how to export contacts from iPhone using the Export Contact app or iCloud on iPhones with iOS 10 and later. Instructions are also for macOS Catalina (10.15) through OS X Yosemite (10.10).

How to Export Contacts From iPhone to Excel/CSV Format

Although there are several apps designed to handle this task, Export Contact is free and well-reviewed by users.

1. Download and launch the Export Contact app on your iPhone.

   Download Export Contact

2. Tap OK to allow the app to access your iPhones contact.

3. Select the file format in which you want to export your contacts: vCArd, CSV, or Excel. In this example, we'll select CSV.

4. Tap Continue.

5. Tap Continue again to accept that the Contact Pro free version can export only your first 100 contacts. (Tap Learn More if you want to upgrade to Export Contact Pro.)

   The free version Export Contact is ad-supported, so you may see ads throughout the process.

6. You'll see a message that 100 contacts were prepared. Tap Export to continue.

7. Your Contacts text document is prepared and ready to download. Tap Save to Files, email the file to yourself, or use another method to share or save the file.

8. The CSV file you save can be imported into any program that accepts CSV format files, including Excel.

Export Contacts From iPhone to vCard Using iCloud

If you don't want to use a third-party app, export your iPhone contacts to the vCard VCF format via your iCloud account. The VCF format of a vCard is similar to the look and feel of an online business card and is a standard address book format.

1. On your iPhone, tap Settings > your name > iCloud.

2. Turn on the Contacts toggle switch. If this setting is turned off, contacts on the device won't sync with your iCloud account and cannot be exported to a file.

3. On a computer, open a web browser, go to iCloud,andsign in to iCloud with your Apple ID.

   You may need to use Apple's two-factor authentication to log in.

4. Choose Contacts.

5. On the Contacts screen, in the lower-left corner, select the Settings icon (gear) > Select All.

   To choose specific contacts to export, press Shift or Ctrl to select contacts one by one.

6. After the contacts are selected, tap Settings again and choose Export vCard.

7. The selected contacts are saved to your computer as a .vcf file.

Use the VCF File or Convert It to CSV

A vCard file is an industry-standard contacts file format. Many programs, including Microsoft Outlook, support vCards. vCards load naturally into most contact lists, making the format ideal for transferring contact information with a minimum of complexity.

If the application you want to import your contacts doesn't support the VCF format, use an online converter to convert the VCF file to a CSV file, such as the AConvert online conversion tool. To use it, choose the VCF file you exported from iCloud and select CSV as the Target format. Select Convert Now and then download the CSV file.

FAQ

• How do I export contacts from Android to iPhone?

  Use the Move to iOS app from Google Play to transfer contacts from Android to iPhone. Another option is to use the Android SIM card: On the Android, open Contacts, tap Settings > Import/Export > Export > SIM card > insert theSIM card in your iPhone.

• How do I export contacts from iPhone to Gmail?

  On your iPhone, go to Settings > Mail > Accounts > select your Gmail account and turn on Contacts. If you haven't set up your Gmail account on your iPhone, go to Settings > Mail > Accounts > Add Account > Google > enter the Gmail address and password, then turn on Contacts.

Thanks for letting us know!

Get the Latest Tech News Delivered Every Day

Subscribe