In the Contacts section of GMail, I go to the More... menu, select the .csv file of my contacts and the click Import. The browser thinks for a minute or so then comes back.

However, none of the contacts are imported. And no error message comes up. How do I troubleshoot this?

Some facts about my contacts:

  • There are 9,800 contacts in the csv file.
  • Contacts are exported from Thunderbird
  • I've also tried exported from Thunderbird as a .vcf file and importing that - with same problems.
  • I tried importing contacts to Outlook and it worked perfectly.
  • 1
    @pnuts This was several hours ago, but i tried the same thing yesterday as well. Aug 7 '17 at 1:44
  • 1
    Could you try exporting/importing a single contact, and see if that works? Aug 7 '17 at 5:10
  • 1
    Since you can import into Outlook, have you tried exporting from Outlook into Gmail? Or tried doing a single contact in a .csv file, as @VidarS.Ramdal suggested? It sounds like there's some issue with your source file.
    – freginold
    Aug 7 '17 at 13:14
  • @VidarS.Ramdal Per your suggestion, I cut down the .csv file to a single contact and imported it. It worked. Aug 7 '17 at 15:39
  • 2
    That's probably good news. Then the problem is with either one (or more) of your contacts, or the number of contacts. You could try exporting/importing 50% of your contacts, and try again. If that works, try with 50% of the remaining contacts and so on. If there's a problem, reduce the set until you have found the troublesome contact(s), which you can then remove manually. Aug 7 '17 at 16:52

I suspect your csv file is formatted incorrectly.

see # 4 in https://www.ablebits.com/office-addins-blog/2014/05/01/convert-csv-excel/ tom

  • 2
    Can you summarize the information at the link, please. If the link goes dead, the answer won't be able to stand alone.
    – jonsca
    Aug 7 '17 at 1:46
  • 1
    I am not sure how #4 is relevant. the data was exported from Thunderbird and it does have headers. Aug 7 '17 at 3:10
  • open the exported file in a simple text editor and see if it is really plain text. I have seen people think they are creating a text file bit is really something different. Another thought is at the end of each record there probably should be a carriage return and a line feed... (these are usually hidden unless you look at a files actual characters)
    – Tomwest
    Aug 8 '17 at 12:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.