How to Export iPhone Contacts as 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 365 or Google Contacts, is to export them to a single CSV file and import to your preferred contact manager from there.

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 Outlook, as well as to Microsoft Contacts on your PC, or 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 the USB cable.
3. In TouchCopy, open the "Contacts" section.
4. Select the contacts you wish to copy and click "Save to CSV".
5. You can open your saved CSV in Excel, or import to another contact manager as detailed below.

Detailed Steps

TouchCopy allows you to browse your iPhone contacts from your computer. Once TouchCopy has connected to your device, open the "Contacts" section on the left-hand side of TouchCopy. You can then scroll down the list of all the 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 prompt 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 organise huge batches of important contacts, and also to 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 add contacts from the CSV created by TouchCopy to your favourite 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.