how to import contacts into outlook from excel file

Check that characters are displayed correctly in Excel.

In the dialog box that appears, under File Origin, choose the encoding that makes the characters in the text appear correctly, for example, Cyrillic Windows 1251, and then select Load.

Browse to your exported CSV file (you may have to select to display Text Files (….csv) to see it).

From the Data menu, select From Text/CSV.

In Excel, create a new blank document (workbook).

How to convert your CSV file to UTF-8 using Microsoft Excel 2016: How to do this will be different between apps and app versions. If you can’t export your contacts using UTF-8 directly, you can convert the exported CSV file using Excel or third-party apps. Therefore, you should save the contacts file with UTF-8 encoding if you have that option during export. However, if the contact information includes characters not found in the English alphabet, such as Greek, Cyrillic, Arabic, or Japanese characters, this can cause problems when importing contacts. Typically, you can import contacts without worrying about the underlying details of how the text is stored in the CSV file. To learn more about UTF-8 encoding, see Why should I care about UTF-8 encoding? Convert your CSV file to use UTF-8 encoding, and restart the import. You will need a file in UTF-8 encoding to continue. If the text is not displayed correctly, select Cancel. The import tool will then show you some example contacts from your file, and you can check that the text is readable and correct.

Note: If the file doesn’t have UTF-8 encoding, the import tool may not recognize and display all text correctly.

How to import contacts into outlook from excel file