To get help and troubleshoot other Microsoft products and services, enter your problem here. If you can't sign in, click here.įor other help with your Microsoft account and subscriptions, visit Account & Billing Help. To contact us in, you'll need to sign in. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes. To get support in, click here or select on the menu bar and enter your query. Enter a name for your file, and select CSV UTF-8 (Comma delimited) (*.csv) as your file type. 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.Ĭheck that characters are displayed correctly in Excel. Browse to your exported CSV file (you may have to select to display Text Files (.csv) to see it). In Excel, create a new blank document (workbook).įrom the Data menu, select From Text/CSV. 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.
0 kommentar(er)
