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/