If​‍​‌‍​‍‌​‍​‌‍​‍‌ done manually, importing frequently results in a broken format since Excel is not created to directly map the contact fields into the mobile or email apps. For instance, a mobile number, job title, and address are the fields that may not get correctly aligned. By using a tool like Softaken Excel to vCard Converter, you can almost be sure of not having this problem, as it accurately recognizes each column and keeps the layout intact while you export Excel contacts to vCard. Rather than taking the risk of having your data in an unorganized way, the tool utilizes a built-in Excel to VCF Converter engine that is capable of safely dealing with all contact properties. Besides that, it provides you with the option to convert Excel to vCard depending on the device that you are using. In case you are having a lot of entries, the Batch Excel to vCard Conversion feature will be a great time saver, as it will perform the file processing automatically. This is the way your contacts can be imported cleanly without any missing fields or formatting ​‍​‌‍​‍‌​‍​‌‍​‍‌issues.
Learn more info: https://www.softaken.com/excel-to-vcard-converter