Import Contacts From Excel or a CSV File Into Outlook GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office

How to Import Contacts from a CSV File into Outlook

Your Excel spreadsheet of contacts can be added in a few steps

By Heinz Tschabitscher Heinz Tschabitscher Writer University of Vienna A former freelance contributor who has reviewed hundreds of email programs and services since 1997. lifewire's editorial guidelines Updated on December 28, 2020 Reviewed by Jessica Kormos Reviewed by Jessica Kormos Saint Mary-of-the-Woods College Jessica Kormos is a writer and editor with 15 years' experience writing articles, copy, and UX content for Tecca.com, Rosenfeld Media, and many others. lifewire's editorial guidelines Tweet Share Email Tweet Share Email MS Office Outlook Word Excel Powerpoint

What to Know

Desktop: Go to File > Open & Export > Import/Export to open the Import/Export Wizard.Then choose Import from another program or file > Comma Separated Values. Select the CSV file and follow the on-screen steps.Outlook.com: Open Applications Launcher > People > Manage > Import contacts > Browse. Select the CSV file and choose Open. Contact data stored in a database or spreadsheet can be easily imported into Outlook. In this guide, we show you how to import contacts from a CSV file using Outlook 2019, 2016, 2013, 2010, Outlook for Microsoft 365, and Outlook.com.

Import Contacts from a CSV File Into Outlook

In the database or spreadsheet program, export the contacts data to a CSV (comma separated values) file. Make sure the columns have meaningful headers, though they don't need to correspond precisely to the fields used in the Outlook address book. You can manually map columns to fields during the import process. The screenshots below are for Outlook 2016. Screens in other versions of Outlook may differ slightly, but the steps are the same. Any variations for older versions will be noted. Go to File. Click Open & Export. In Outlook 2010, then click Open. Click Import/Export. In Outlook 2010, click Import. In the Import and Export Wizard, select Import from another program or file, then click Next. Select Comma Separated Values, then click Next. Click Browse, then locate the CSV file that contains the contacts you want to import. If you use Gmail, export your Gmail contacts to a CSV file, then import your Gmail contacts into Outlook. Choose one of the following: Do not import duplicate items. Replace duplicates with items imported. If the data in the CSV file is more recent or more complete, this might be the best choice. Allow duplicates to be created. If duplicates are created, you can always search for and eliminate them using a duplicate removal utility, for example. Click Next. Select the Outlook folder into which you want to import the contacts. This may be your Contacts folder, or it can be a Contacts folder in any of your other folders. You can also create an Outlook folder just for imported items. Click Next. Click Map Custom Fields. Map all columns from the CSV file to the desired Outlook address book fields. Outlook automatically maps some fields; change these if they are not mapped correctly. To map a field, drag the Value to the desired Field. Click OK, and then click Finish to begin the import process.

Import Contacts on Outlook com

You can upload your contacts CSV file to Outlook.com as well. The process is a bit different from the software versions. Open the Applications Launcher and click People. Click Manage > Import contacts. Click Browse. Select the CSV file, then click Open. In the Import contacts dialog box, click Import. Your contacts are uploaded and imported to your Outlook.com email account. When the process is finished, click Close. You'll find the new contacts in your Outlook address book. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Export Emails From Outlook How to Add Members to a Distribution List in Outlook CSV File (What It Is & How to Open One) How to Import Addresses Into Gmail From Other Email Services How to Import Outlook Contacts Into Apple Mail How to Print Your Outlook Address Book How to Export Your Outlook Contacts to a CSV File How to Export Your AOL Mail Contacts How to Add Your Outlook.com Email to Outlook for Windows Forward Multiple Emails Individually in Outlook How to Export Data to Excel How to Open Your Outlook.com Address Book What Is a VFC File? How to Export Contacts in Mozilla Thunderbird How to Export Contacts From Windows Mail How to Export Contacts From iPhone Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies