A few weeks ago, I experienced the similar problem when I had to transfer a large contact list from Excel to my phone and feared losing crucial information like phone numbers and emails. After trying a few manual methods that didn’t work well, I came across a tool called DataVare Excel to VCF Converter. As it happened, it was really beneficial. The application converted all of my Excel contacts into VCF form without altering any data and was simple to use. The fact that it maintained everything precisely as it was—name, phone, email address, everything around—kept me most interested. I so highly advise anybody trying to convert Excel contacts into VCF without losing any data to give this program some try. It saved much time and effort as well as tension.

Read more: https://www.datavare.com/blog/export-excel-contacts-to-vcf.html

A while back, I had to transfer about 300 contacts from an Excel file into my Android phone. The file was not particularly complicated—just names, phone numbers, and a few notes—but I wanted to save all the information throughout the conversion. Either the formatting failed or some data didn't show up correctly when I attempted copy-pasting into Google Contacts and even experimenting with CSV > VCF converters.
I eventually used a tool called GainTools Excel to vCard Converter, and it was surprisingly solid. It let me map each column properly and exported everything cleanly into VCF format. The contacts imported into my phone exactly as expected. I’d say it's definitely worth checking out — saves a lot of hassle.

Read more: https://www.gaintools.com/how/convert-excel-xls-file-to-vcard-vcf-file/