It has taken a while to work out what to do with Google contacts (which I want to be the central store for my contacts). Having various attempts at sync cause massive duplication (up to 6x in the end) I went back to a known good set from a couple of months ago.
The answer was to create my own CSV file completely in line with Google’s own export/import format. That looks like the following (you can copy and paste special>transpose in Excel):
NameE-mailNotesSection 1 – DescriptionSection 1 – EmailSection 1 – IMSection 1 – PhoneSection 1 – MobileSection 1 – PagerSection 1 – FaxSection 1 – CompanySection 1 – TitleSection 1 – OtherSection 1 – AddressSection 2 – DescriptionSection 2 – EmailSection 2 – IMSection 2 – PhoneSection 2 – MobileSection 2 – PagerSection 2 – FaxSection 2 – CompanySection 2 – TitleSection 2 – OtherSection 2 – AddressSection 3 – DescriptionSection 3 – EmailSection 3 – IMSection 3 – PhoneSection 3 – MobileSection 3 – PagerSection 3 – FaxSection 3 – CompanySection 3 – TitleSection 3 – OtherSection 3 – Address
Then line up your own items with these (or not as the case may be). I still get an error (”The file may have been too big”) but the contacts appear to come over OK.
Now to see if GooSync, my current sync saviour will work with these new contacts, and to work out quite how many new ones I have lost from the last few months.