Related TopicsĬreate, view, and edit contacts and contact lists in Įxport contacts from to a CSV fileĬlean up or remove duplicate contacts in From Import a File window, Choose Comma Separated Values and click on the Next. From Import and Export wizard, Choose Import from another program or file option and click on the Next button. Click on the Open & Export and select the Import/Export option. If you're having trouble importing contacts to your account, see Fix problems importing contacts to . Step 2: Import Gmail contacts to Outlook. Enter a name for your file, and select CSV UTF-8 (Comma delimited) (*.csv) as your file type.
#Import contacts to outlook from csv windows#
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. There click on the Open & Export category and click on Import/Export option there. In the upper left corner of the program you will find a File menu click on that. Browse to your exported CSV file (you may have to select to display Text Files (.csv) to see it). Just follow these easy steps mentioned-below and import contacts safely: Start with opening Outlook in your system. Select the open and export button Hit import/export button Select Import from another program or file option and press next.
#Import contacts to outlook from csv how to#
In Excel, create a new blank document (workbook).įrom the Data menu, select From Text/CSV. How to Import CSV Contacts in MS Outlook 2013, 2016, and 2019 Open Outlook in your system > Click on file option at the top left corner. 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.