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.
Download and launch the Export Contact app on your iPhone. Download Export Contact Tap OK to allow the app to access your iPhones contact. Select the file format in which you want to export your contacts: vCArd, CSV, or Excel. In this example, we’ll select CSV. Tap Continue. 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. You’ll see a message that 100 contacts were prepared. Tap Export to continue. 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. 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.
On your iPhone, tap Settings > your name > iCloud. 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. On a computer, open a web browser, go to iCloud, and sign in to iCloud with your Apple ID. You may need to use Apple’s two-factor authentication to log in. Choose Contacts. 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. After the contacts are selected, tap Settings again and choose Export vCard. 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.
