Can't get an Excel spreadshe doc. to export into Oultook Contacts

I'm a beginner when it comes to the import/export function. I have been
trying without success to export an Excel worksheet doc. into Outlook
Contacts. The document contains a long list of client contact information.
Everytime I reach the import into Outlook section I get a message stating:
"ODBC error, an error has occurred in the Microsoft Excel translator while
gettng the contents of a file system. It also states that my "file has no
named ranges, use Microsoft Excel to name the range or data you want to
import -- how do I do this? SOMEONE PLEASE HELP ME!

If you are not able to export your excel spreadsheet outlook contacts into, then i have another solution for your issue, first you can convert your excel contacts in vcf format, to convert you can use osttopstapp.com/xlstovcf.html Excel to vCard Converter software to convert your excel data in vcf format, after convert you can use another software like osttopstapp.com/vcard-export-import.html vCard Export Import to export your vcf contacts in outlook format.