The contents of excel spreadsheet can mainly divided into two parts: column headers in the first row and the rest contacts’ detail information rows. Each column header name must be a valid property name. Each row represents one contact, if firstname, middlename, lastname, and company are all empty, this row cannot be imported.
Column headers must be valid property names, otherwise the app will beep on error when you import. Above picture is a list of all valid column headers.
Just choose the column headers you need from Prat I & Part II.
l choose the column headers you need from Prat I & Part III.
l You have to define your own column headers if you want to make custom labels for phone numbers. The format is <CustomLabel>Phone, eg: CarPhone, PrivatePhone.
l If you have multiple mobile numbers, the column headers should be “Mobile1”, “Mobile2”,etc. Similarly, column headers for multiple work phone numbers are “WorkPhone1”,”WorkPhone2”, etc.
l Column headers for multiple email addresses are “EmailAddress1”,”EmailAddress2”, etc. Similarly, for multiple website urls are "WebsiteURLs1", "WebsiteURLs2", etc.
l You can use Mixed column headers and Separate column heads in one excel spreadsheet for importing, which means column headers as follows is allowed:
l Since only custom labels defined for phone numbers can be imported and exported in Separate properties style, Mixed would be a better choice if you want to keep all the customs labels.
l If you find the format a little too complicated, we suggest you edit an example contacts with all the properties you need in your iPhone, then export it to get a template excel file. Next time you can enter contact information directly without worrying about the column headers' validness.
Enter contacts' information
If you edit excel in Separate style, then no particular format required in cells. But for Mixed style, the values in the cells of these properties should follow specific format: Phonenumbers, Addressed, EmailAddresses, WebsitURLs, InstantMessageIDs, AssociatedDates.(Format is shown below)
l the Country Code should be an ISO 3166 country code, for example gb: United Kingdom, us: United States. If Empty, use default country on your iPhone.
l The size of input for “Note” is limited to 4KB. The part in excess will lose.
l If cells’ date type is set to TEXT, when you enter date, five ways for your choice:
MM/DD/YYYY, YYYY-MM-DD, YYYYMMDD, DD-MM-YYYY, DD.MM.YYYY
l Use ALT+Enter to make a line break in one cell.
Add contact photos
Method 1: Insert photos into the corresponding cells in Excel file directly.
Step 1: Create a folder named "images". Copy all photos into it.
Step 2: Enter the photo filename including file extension in excel file.