To bulk import contacts in Gmail, I resorted to a specialized Excel to VCF converter and realized mapping was quite important. I would definitely recommend that you remove any unwanted characters, standardize your phone formats, and use uniform column names even before the conversion. Softaken Excel to vCard Converter had a Batch Excel to vCard Conversion feature, which I used to quickly convert the files and leave no fields unaccounted for. After creating the files, I randomly checked some vCard files for Gmail compatibility. This tool preview showed how the records would look, so it gave me a way to fix the mapping problems in a very short time. In fact, it operated perfectly and made the whole Gmail import process much easier today.