If you see a "unsupported format" warning while importing Excel contacts into iCloud, iCloud does not immediately accept the Excel file (.xls or.xlsx). iCloud just lets import contacts in vCard (.vcf) format. You so must first convert your Excel file into a vCard format.
Here's a basic, detailed solution:
Make sure your Excel file includes separate columns with appropriate contact information including First Name, Last Name, Phone Number, Email, etc.)
Launch your Excel file and save it as a CSV file. Click File > Save As in Excel then select CSV (.csv) format.
iCloud does not handle CSV files either, hence you now have to convert the CSV into (.vcf) format. iCloud only accepts this format of data.
Import vCard into iCloud.
Log in by going to iCloud.com.
Move to "Contacts."
Click the gear icon at bottom left and select "Import vCard."
Choose your.vcf file and upload.
Once you do this, your contacts should appear in iCloud without errors.
This process of converting CSV to VCF can be little bit tricky if you are a non-technical user. To make easy you can use the second solution that is an automated tool. I recommend using the Softaken CSV to VCF converter, it can convert CSV to vCard without any data loss issues and in just a few simple steps. This application is a quick as well as efficient solution for anyone who want to migrate CSV to vCard. You are able to operate this software without any difficulty because of its user-friendly interface. This tool can be simply load on all Windows versions and can complete the conversion of the files in bulk. Before getting its licensed edition you can use its demo version that is completely free.
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.
