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. – AngryHacker Aug 7 '17 at 1:44
  • 1
    Could you try exporting/importing a single contact, and see if that works? – Vidar S. Ramdal 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. – AngryHacker 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. – Vidar S. Ramdal 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

| improve this answer | |
  • 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. – AngryHacker 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.