Outlook Importing Contacts, header shown as one

Bonne 1 Reputation point


I am trying to import contacts from a CSV-file with different headers (first name, last name, email, etc.). However when I try to assign the headers of the file to the corresponding fields in Outlook, the headers from my file are shown as one header (see picture). What can I do for Outlook to recognize the different headers in the file?


Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,003 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Faery Fu-MSFT 17,901 Reputation points Microsoft Vendor

    Hi @Bonne ,
    Welcome to our forum!
    According to my search, this issue occurs if you are using a .csv file in a different format than expected during the Outlook import operation. Outlook Import must be able to recognize the data in the .csv file to correctly map it to the fields used by contacts in Outlook.

    To work around this issue, create a .csv file that uses the format expected by Outlook:
    Step1: Export your Outlook contacts into a .csv file that will be used as a template, and here is an article for your reference.

    Step2: Copy the data in your original .csv file and paste it into the template file. It is recommended that you put the two csv files side by side, except for the headers in the first row, copy the data of the same column into the template file.

    Step3: Repeat step 2 for each column of data, then save and close the file.

    Step4: Import the .csv file that you have editd, and see if it can work successfully.

    Although this method requires you to manually copy the data, I personally think this is an effective method at present, hope this can help you:)

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.