TechNeate.com iPhoneate.com QueComico.com MiamiGlobalRadio.com

How to export your iPhone contacts to a .csv file

by menorah / July 4, 2016 11:51 AM EDT

A CSV file allows you to store a large amount of information in a document that can be opened with spreadsheet applications like Microsoft Excel, or Apple 's Numbers app , just like other spreadsheet file types. This is a great way to back up your contact information in case you have a problem with your computer, iPhone, or other iOS device. In this tutorial, we'll show you how to export your contacts to a CSV file.

Export your contacts from iPhone or other iOS device to CSV:

Create a CSV file of your contacts from your iCloud account

The most convenient way to do this from a Mac or PC is via iCloud.com, which can be accessed from any device you have on hand.

  • Go to iCloud.com in your preferred web browser and sign in.

Log-in-to-iCloud-website-Apple-593x380

  • Now click on the contacts application in the list of services provided.

iCloud-Website-Contacts-App-593x415

  • Next, wait for your contacts to load and then click on the settings gear at the bottom left of the webpage.

iCloud-Website-Contacts-Settings-Button-593x415

  • From the list, click on the option "Select all" to make sure you have all your contacts selected before proceeding to the next step.

iCloud-Website-Contacts-Select-All-593x415

  • Once selected, click on the settings gear once more, and this time click on the export vCard option.

iCloud-Website-Contacts-Export-vCard-593x415

  • A vCard file will now be downloaded to your computer in the downloads folder.

vCard-File-Mac-Finder-Downloads-Folder-593x336

  • Open your favorite web browser once more and visit the following URL: http://Labs.brotherli.ch/vcfconvert/

CSV-Converter-Website-593x415

  • Click the Choose File button and select the vCard file you downloaded earlier. Then, configure the following options:

          Format: Choose CSV, select Comma, allow adding header line
Encoding: select Unicode (UTF-8)
Filter: Do not change anything
Modifications: do not change anything

          Once configured, click the convert button.

CSV-Converter-Website-Convert-Button-593x415

  • A CSV file will now be downloaded to your computer's downloads folder.

Mac-Finder-Downloads-Folder-CSV-File-593x336

  • Try opening the file in Microsoft Excel or Apple Numbers. Everything should display in an organized manner.

CSV-File-in-Microsoft-Excel-593x456

And that's it! Your contacts will be organized by name and information in the spreadsheet.