how to import contacts into outlook fom excel

Now that we have a CSV file, we need to import the contacts in Outlook. Remember the location you saved this file, you will need to find it to import the contacts to Outlook. To save the file as a CSV, go to File > Save As and make sure “Save as type:” is set to “CSV UTF-8 (Comma delimited)(*.csv)”.

If it is in any other format, you will need to save a copy as CSV (Comma Separated Value). If you already have your Excel file saved as a. Without a header row, importing the contacts into Outlook will not work correctly. If your file does not have a header row, please add one. Note that the first row of the file is a header row – it has labels describing what data the column contains. The position will be discarded when we import the file. It features separate First and Last name fields, an email address field, as well as each player’s position. It is dummy data, but made to be similar to something you might receive as a list of players on a sports team. Pictured above is the file with the contacts I would like to import. Then, we will map it and import the contacts. xlsx format so we will first convert it to. In this article we are going to import contacts to Outlook from an Excel file.

How to import contacts into outlook fom excel