Comment 20 for bug 755043

iMac's excellent suggestion at #16 worked for me, but I had many more messed up contacts than he did. I found an easier way to clean up my contacts. I:

1) Exported my Google contacts as a "Google CSV" file.
2) Opened the file in LibreOffice calc
3) Sorted by "Custom Field 1 - Value" (column BW when I did my export)
4) For all the contacts that had a value in that column, but no value in "Custom Field 1 - Type", I edited the contact in the Google Contacts web interface, and put a label on the value (it was in a section called "Custom" when i edited the contact).

Then I was able to import all my contacts into Evolution.