This article describes the process of importing contacts from a .csv or .xls file to your iPhone.
This guide will help in the following situations:
Let’s get started!
Import CSV or Excel contacts to iPhone
Install and open CopyTrans Contacts, go to the Contacts tab, and click “Import contacts” in the top left corner:
A dialogue window will appear. Select: “From a file” and choose your .csv file:
You can also just simply drag and drop your CSV or Excel file into the program:
The white columns are the columns that were automatically matched by the program.
The red columns are the ones that could not be matched automatically. If you want to import data from those columns to your iPhone, you need to manually select the appropriate column header for those columns from the drop-down list.
When you change a column header the column turns blue.
The CSV import wizard will open.
You will see the data of the CSV file as a table. Here you will need to match the columns from the source file (.csv or .xls) with the iPhone contact fields (like first name, middle name, phone number, etc.) Just select a column header for each column from the drop-down list.
If you have any questions or problems with this step, refer to the troubleshooting guide below.
There are a lot of different types of CSV files. The Import Wizard is designed to customize the transfer and prevent data loss. In some CSV files, the information is presented in two columns: data type and data value. For example, the phone number information consists of the data type (such as home, business, mobile, etc.) and data value i.e. the phone number itself, like +1-313-123456.
Those two-column files should be matched accordingly in the Import Wizard:
You can exclude some or more contacts from the import – just simply uncheck the checkbox next to the contact.
If you do not want to import a column from the source file to your iPhone, select “Do not import” from the drop-down list.
To make your job easier, you can choose to only view the unmatched columns. This way only the red columns will be displayed.
The first line of the CSV file usually contains the column header name and therefore is grayed out by default and will not be imported. If you wish to import it, uncheck the “Do not import the first line” in the advanced settings to avoid losing data.
If you regularly import CSV files from a particular source, you can save your import settings. To do this, enter the title of the backup once you’ve finished customizing the fields, and click the Save icon. You can use these parameters during the next transfer simply by selecting them from the list. You can also choose the “Last used” to use the last import settings.
I do not see any of my contacts from CSV file
Please try to change the encoding. Sometimes the encoding of the source file can not be detected automatically.
My contacts are not displayed correctly: special characters like é, è, ç are not displayed.
In this case, it is quite possible that your contacts are not properly stored in the CSV file. Open the CSV file with a text editor (ex. in Notepad++) and check if your data is displayed correctly there. You can then edit them manually directly in the file or in your iPhone after the import.
I get an error message “1/1 of your contacts could not be imported”
This means that the source file is probably corrupted. We recommend opening it in Microsoft Excel and saving it: this may be enough to fix it. Then try importing it into CopyTrans Contacts again.
I noticed an error in the contact details
To edit your contacts, open the source file in Excel or Notepad++ and then re-import it. You can also do it in CopyTrans Contacts on your iPhone after the transfer.
For other questions please contact us by email at firstname.lastname@example.org
Import CSV or Excel contacts to iCloud
To import your contacts to iCloud, make sure you have logged in to your iCloud account in CopyTrans Contacts.
Then follow the steps above to import the contacts into the iPhone. After that, select the contacts you wish to transfer to iCloud and right-click. You have two options: Copy To and Move To. In the first case, the contacts will stay on the iPhone and also will be copied to iCloud. If you choose to move them, these contacts will be removed from the iPhone and will be transferred to iCloud.
The method works when importing the CSV or Excel contacts from the following sources:
- Slack CSV