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.

To export iPhone contacts as CSV, follow the steps below...

1. Download and install TouchCopy.
2. Connect your iPhone to your computer using a USB cable.
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...

Detailed Steps

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.

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.

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.

Import CSV with iPhone Contacts into Gmail

1. Open Google Contacts in your browser.
2. Click "More" > "Import..."
3. Locate your copied CSV file.
4. Click "Import" to save all your contacts to Gmail.