To import CSV contacts to Outlook, choose Comma Separated Values and click Next.You choose Import from another program or file and click Next. In Microsoft Outlook, click File > Open & Export > Import/Export.To import contacts from a CSV file into Outlook 2019, Outlook 2016 or Outlook 2013, carry out these steps:

How to import contacts to Outlook from CSV file How to export contacts from Outlook Online.How to export contacts from Outlook desktop.In the below linked tutorials, will find the detailed guidance on exporting contacts to a CSV file: But Outlook only supports the comma as a field separator, so you need to replace semicolons or any other delimiters with commas before importing your CSV file into Outlook. For example, in many European countries, the default list separator is the semicolon. Depending on your locale, a different list separator is set by default.

Make sure the values in your CSV file are separated by commas.

To prevent possible issues, export contacts into a CSV UTF-8 file if such an option is available to you, or convert CSV to UTF-8 with Excel. Arabic, Cyrillic, Chinese or Japanese, such contacts may not be imported correctly.

If contact details contain some characters that do not exist in the English alphabet, e.g.

csv file, which can be imported into Outlook with a few adjustments: If you keep your contact information in Excel or another spreadsheet program or have exported your contacts from another email provider, such as Gmail or Yahoo Mail, they will typically be in a.

pst file, contacts are already in the right format and require no further amendments.įor more information, please see How to export Outlook contacts to PST file.ĬSV (Comma Separated Values). It's a special file format for storing data in Outlook, Exchange Client and other Microsoft software. Microsoft Outlook allows importing contacts from two file types, PST and CSV. Prepare contacts for importing into Outlook

Importing contacts to Outlook from PST file.

Importing contacts to Outlook from CSV file.

Preparing contacts for importing into Outlook.

Whatever the reason, Outlook provides a straightforward way to import all your contacts in one go. For example, you inherited an external database with a list of contacts, or you are migrating from another mail server, or perhaps you are setting up a new account. There may be different reasons why you may want to transfer contacts into your Outlook address book. pst file, and shows how to transfer contacts to Outlook Online. This tutorial talks about two ways to import contacts into Outlook desktop, from.

How to import contacts to outlook com