CONTACTS.CSV IMPORT FAILED TRANSLATOR – GMAIL TO OUTLOOK

If you look at the contacts.csv file generated by Google and compare it to the one Outlook usually exports, you will notice that the Outlook one contains quotes around every field. This gave me the clue that perhaps the data itself was the culprit when the import failed with the “translator failed” message, and indeed I traced the error to a contact that had a photo assigned to him. The contact’s photo was a very long URL beginning with http://…… and after taking this one contact out of the csv file the import worked fine. Suggestion: Google; add quotes around your fields when you generate a CSV file!