How to Export iPhone Contacts to CSV (Excel)

Summary

The contacts stored on your iPhone contain lots of valuable information such as phone numbers, emails and physical addresses. The easiest way to copy all your iPhone contacts to another contact manager (such as Outlook or Google Contacts), is to export them to a CSV file and then import them to your preferred contact manager.

TouchCopy is a trusted Windows and Mac app which can export all your contacts as CSV in a few clicks. TouchCopy can also save your contacts as vCards, and even copy your iPhone contacts directly to the Address Book on your Mac.

How to Export iPhone contacts as CSV

1. Download and install TouchCopy.
2. Connect your iPhone to your computer using a USB cable or via Wi-Fi.
3. In TouchCopy, open the "Contacts" section.
4. Select the contacts you want to copy and click "Save to CSV".
5. You can open your saved CSV in Microsoft Excel, or import to another contact manager as detailed below.

The best way to learn more about TouchCopy is to try it free...

More information on exporting contacts as CSV with TouchCopy

TouchCopy allows you to browse your iPhone contacts, and other content, from your computer. Once TouchCopy has connected to your device, open the "Contacts" section on the left-hand side of TouchCopy. You can then browse the list of contacts stored on your iPhone. Click a contact's name to see their details.

TouchCopy will show any information stored for a given contact on your iPhone. This includes, but is not limited to: Name, Image, Phone Numbers (home, work, mobile etc.), email addresses and home addresses.

Next, you'll need to decide which contacts you want to export into your CSV file.

• Select a single contact simply by clicking it from the list in TouchCopy.
• To select multiple contacts, hold "Ctrl"(PC) or "cmd"(Mac) on your keyboard when clicking multiple contacts from the list.
• To select all your contacts, click a single contact, then hit "Ctrl+A"(PC) or "cmd+A"(Mac) on your keyboard to select all contacts in the list.

Once you've made your selection, you're ready to export the contacts. To do this, simply click the "Save to CSV" button in TouchCopy. You will now see a window which prompts you to select a location on your computer. Choose the location you'd like to save your CSV file to, then click "Save" to proceed with the export.

Great! You've now exported your iPhone contacts as a CSV file. You can now open your CSV file in a spreadsheet management app like Microsoft Excel. This will make it easy for you to organize huge batches of important contacts, and also keep them safe in case anything should happen to your iPhone.

In Excel, go to File > Open, and select the CSV file saved using TouchCopy.

How to import contacts into Outlook / Gmail

So, now you know how to export your iPhone contacts as a CSV file, and how to open the file in Microsoft Excel. All that's left to do is to add contacts from the CSV to your favorite contact manager. Watch our video to see how to restore contacts to your iPhone, or read on for instructions.

Import CSV with your iPhone Contacts into Outlook

1. Open Outlook on your computer.
2. Go to "File" > "Open & Export".
3. Select "Import from another program or file", and then click "Next".
4. Choose the CSV created by TouchCopy to import your contacts

If you're using Outlook on the web see Microsoft's guide.

How to sync contacts from Microsoft Outlook with your iPhone >

Import CSV with iPhone Contacts into Google Contacts

1. Open Google Contacts (contacts.google.com) in your browser.
2. Click "Import" and then "Select File".
3. Locate and select your copied CSV file.
4. Click "Import" to save all your contacts to Google Contacts.

How to sync your Google Contacts with your iPhone >