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.
#HOW TO IMPORT CSV CONTACTS INTO OUTLOOK 2016 HOW TO#
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
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.