How to Import Email Addresses from Excel to Outlook (2024)

In this article, we will show you how to import email addresses from Excel to Outlook. Simply follow the process below. 

How to Import Email Addresses from Excel to Outlook

Follow the steps below to easily import email addresses from Excel to Outlook. 

1. Organize Email Addresses in Excel and Save as CSV

Ensure your Excel file has email addresses organized properly. Each email should be in its own cell, ideally in a single column. Label the top cell of the column with a descriptive title like 'Email Addresses'.

2. Convert and Save Excel File in CSV Format

Click on 'File' in Excel, then choose 'Save As'. Select 'CSV (Comma delimited) (*.csv)' as the file format. Save the file to a location on your computer that you can easily remember or access.

3. Launch Outlook and Navigate to Contacts Management

Launch Microsoft Outlook and log into your account. In the bottom left corner, click on the 'People' icon to access the Contacts section.

4. Initiate Import/Export Process in Outlook

Click on 'File' in the top menu, then select 'Open & Export', and choose 'Import/Export'. This opens the Import and Export Wizard.

5. Select 'Import from File' Option in Import/Export Wizard

In the wizard, choose 'Import from another program or file' and click 'Next'.

6. Locate and Upload CSV File, Choose How to Handle Duplicates

Click 'Browse' to upload your file in CSV format. You will have options to 'Replace duplicates with items imported', 'Allow duplicates to be created', and 'Do not import duplicate items'. Choose as per your preference and click 'Next'.

7. Map CSV Columns to Outlook Contact Fields

Choose the destination for your imported contacts, usually 'Contacts'.

Tick the option to import CSV file then select 'Map Custom Fields'.

Map the CSV columns to the corresponding fields in Outlook. Ensure the email addresses column in CSV matches the email field in Outlook.

8. Complete the Import Process and Add Contacts to Outlook

After mapping, click 'Finish'. Outlook will start importing the email addresses from your CSV file. Once done, you will see them in your Contacts list.

9. Check Outlook Contacts for Successful Import

Check your Contacts list to ensure all email addresses have been imported correctly. If any are missing, you may need to repeat the process or check your CSV file for errors.

We hope that you now have a better understanding of how to import email addresses from Excel to Outlook. If you enjoyed this article, you might also like our article on how to copy email addresses from Excel to Outlook or our article on how to import email addresses from Excel to Gmail.