Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Icloud contacts import error causes duplicate records

ICloud contact import gives error. But it has uploaded some. Then I search till where it uploaded. And after finding that I cut that out from the cvf and create another file and import. But in the end there is duplicate. Apparently even after the error message from icloud it still is importing in the background. What is the ideal way to resolve this issue?


iPhone 15 Pro Max

Posted on Sep 30, 2023 11:37 AM

Reply
3 replies

Oct 2, 2023 2:03 PM in response to Never_ever

Hello Never_ever,


Welcome to Apple Support Communities. We understand that when importing contacts they are duplicated. We are happy to help.


We recommend trying the steps here: Resolve duplicates while importing contacts into Contacts on Mac - Apple Support


  1. "In the Contacts app  on your Mac, when you see the message that duplicate cards have been found, choose what to do:
    • Accept duplicates without reviewing: Click Import.
    • Review duplicates and resolve discrepancies: Click Review Duplicate(s) and continue to the next step.

2. Review the first duplicate by clicking the buttons above the card, then click the button with the option you want.

    • Keep Old: Keep the old card, and discard the new one (the one you’re importing).
    • Keep New: Keep the new card, and discard the old one.
    • Keep Both: Keep both cards.
    • Update: Create an updated card that merges information from both cards.

3. If that was the only duplicate, click Import. If there are more duplicates, do one of the following:

    • Resolve all duplicates the same way: Select Apply to All, then click Import.
    • Review each duplicate: Click Next. When you’re done reviewing duplicates, click Import."


These steps may help. Please let us know if you have further questions.


Take care.

Oct 4, 2023 10:44 PM in response to Never_ever

1) The simplest solution was to import to the apple_id and apple_id contacts will appear in Iphone contacts. The apple ID email we use could be outlook/gmail/other providers. And they will accept import without any problem.

2) If we still want to import to Icloud these are the steps.

a) Download google contacts to .csv (outlook)


b) Open in Excel, set header and sorting save as .xlsx

c) Remove abnormalities (Do a sorting of each field and you could perhaps observe email fields with numbers, phone fields with emails, unwanted chars in Notes, etc)

d) Sort by first name

e) split the xlsx into files with 1000 contacts each. (keep them as xlsx)

f) save each file as .csv (and then never open it with excel again as it can change the format)

g) import this to another(or new) google/outlook account (clear all contacts in it before you use it)

h) export these contacts as vcf

i) if you split the contacts(if you have 1000+ contacts) at #e step then do #g and #h again

j) at this point we have max 1000 contacts per VCF and it is sorted on first name (we also have corresponding .csv and .xlsx for these files)

k) now start the import to Icloud with the vcf.

l) if there is error, find out on which contact it failed by opening the corresponding xlsx (never open .csv) and doing a search in Icloud to see if the contact exists. Since it is sorted, it is easy to find the last letter uploaded to icloud.

J) you will have to fix the erroneous contact and start the whole process again!

It is hectic but that is what we get when use Icloud contacts!! It is badly built.


Icloud contacts import error causes duplicate records

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.