Usually, a "unsupported format" problem occurring during Excel contact imports to iCloud indicates improper file type. You must first convert your Excel contacts into a format iCloud recognizes if you are solving this. Creating a CSV file from your Excel file and subsequently modifying that CSV file into a VCF file is a great approach to achieve this. If that sounds complicated, don’t worry — there’s a handy tool called GainTools CSV to VCF Converter that can make the job really simple. It enables fast conversion of your contacts into the appropriate format so you may import them to iCloud without any problems. Especially if you're not technical, using a program like this saves time and eliminates all the formatting problems. You are also able to test it out cost-free by using its free trial edition.
I had the same issue when I tried to load my contacts from Excel into iCloud. I kept getting a "unsupported format" error. I learned that iCloud does not directly support Excel files. It only works with.vcf vCard files, which is why it keeps giving you that warning. DataVare Excel to vCard Converter was the tool that helped me the most. Following that, I put the vCard into iCloud and it worked properly with no problems. I was really glad because I didn't want to copy all of my emails by manual. If you're having the same problem I did, try that converter. It helped me a lot and saved me a lot of time and stress. I hope this helps someone else who is having the same problem!
