1 Star2 Stars3 Stars4 Stars5 Stars (13 votes, average: 4.38 out of 5)

You can easily edit your iPhone contacts in Excel using CopyTrans Contacts. This article demonstrates how to export your iPhone contacts to an Excel list, edit your contact list within Excel and then re-import the newly-edited contact list to your iPhone via CopyTrans Contacts.

CopyTrans contacts is compatible with all iOS devices such as your iPhone, iPad, or iPod Touch. As a result, you can edit your iPhone, iPad, or iPod Touch contacts in Excel easily.

Exporting iPhone contacts to Excel

  1. Download CopyTrans Contacts from the following page:
    Edit iPhone Contacts in Excel

  2. Install the program. If you need help installing CopyTrans Contacts, please refer to this article

  3. Run CopyTrans Contacts and connect your iPhone. Your iPhone contacts will appear in the program’s main window iphone contacts before edit in excel

  4. Select the iPhone contacts you want to edit in Excel from the contacts list. To edit all of your iPhone contacts in Excel, tick the checkbox next to “Contacts”. To edit a limited number of contacts, tick the checkbox next to each contact. Now click the “Export selected” button export iphone contacts to edit in excel

  5. A new window with several choices will appear. Select “Excel (single .xls file)” export iphone contacts to excel

  6. Navigate to the location on your PC where you want to save the Excel contacts file and click OK

  7. Your iPhone contacts will be saved to your PC in the form of a single Excel file in the location of your choice. You can now open the Excel file and begin editing your iPhone contact list directly via Excel. iphone contacts exported to PC in excel format

Editing iPhone contacts in Excel

Once you have your Excel file listing your iPhone contacts, open the document and start adding/editing your iPhone contact details via Excel. iphone contacts edit in excel

Excel limitations: Excel does not support pictures and therefore your Excel contact list will not contain your iPhone contact photos. It is recommended that you back up your iPhone contacts to your computer in advance in vCard format in order to save your contact photos. To back up your iPhone contacts in vCard format, please refer to this article.

Note: in order for your iPhone to be able to correctly recognize contact data upon re-importing your Excel document, keep the exact column structure and sequence in the Excel file, which CopyTrans Contacts produced, intact. It is not obligatory that you fill up all columns. Titles of columns supported by the iPhone are as follows –

  • First Name – for example: Gregory

  • Middle Name – for example: Thomas

  • Last Name – for example: House

  • Title – for example: Duke of Edinburgh

  • Suffix – for example: Mr.

  • Nickname – for example: Greg

  • Phonetic First Name – used for non-Latin scripts

  • Phonetic Middle Name – used for non-Latin scripts

  • Company – for example: WaterGate Inc.

  • Job Title – for example: Executive

  • Department – for example: Accounting

  • Notes – for example: Martha’s best friend

  • Birthday – for example: 1952-09-15

  • Phone 1 – Type – for example: Work

  • followed by Phone 1 – Value – for example: 00 1 365 884 911

  • Phone 2 – Type – for example: Mobile

  • followed by Phone 2 – Value – for example: 00 1 365 884 912

  • Address 1 – Type – for example: Home

  • Address 1 – Street

  • Address 1 – City

  • Address 1 – PO Box

  • Address 1 – Region

  • Address 1 – Postal Code

  • Address 1 – Country

  • e-mail 1 – type – for example: Personal

  • followed by e-mail 1 – value – for example: greg.house@watergate.inc

Importing the edited list of Excel contacts back to your iPhone

Once you are ready with editing your iPhone contacts in Excel, you can import the Excel file back to your iPhone using CopyTrans Contacts. To do so:

  1. Run CopyTrans Contacts and connect an iOS device such as your iPhone, iPad, or iPod Touch

  2. Click on the „Import contacts“ button and from the newly-opened window, navigate to the location where you saved your Excel contact list. Click “Open” impot excel edited contacts to iphone

  3. Your newly-edited Excel contacts will be imported to your iPhone excel edited contacts imported to iphone

This is how to easily edit iPhone contacts in Excel.

Avatar for krasimir

By krasimir

Krasimir is an avid marketing aficionado and a tech-support specialist in charge of the English-speaking market. He grew up in Bulgaria and on the island of Mauritius where he became passionate about windsurfing and photography.