how to import contacts into outlook from csv

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 If your contacts are stored in Excel, the following tutorial will be useful: How to import contacts to Outlook from Excel.

How to import contacts into outlook from csv