How to Export Your Outlook Contacts to a CSV File GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office

How to Export Your Outlook Contacts to a CSV File

Create a contacts list to use in Excel

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 February 26, 2020 Tweet Share Email Tweet Share Email MS Office Outlook Word Excel Powerpoint

What to Know

Convert contacts to CSV: File > Open & Export > Import/Export. Choose Export to a file > Next > Comma Separated Values > Next.Highlight the Contacts folder and select Next. Select Browse and then save and name your CSV file. To export, go to Outlook.com.Open your contacts list and select Manage > Export Contacts. Choose All Contacts > Export. The CSV file will be in your Downloads folder. This article explains how to save your Outlook contacts as a CSV file and import them elsewhere. Instructions cover Outlook 2019-2010, Outlook for Microsoft 365, and Outlook.com.

Convert Your Contact List to a CSV File

To export your contact lists, open Outlook and follow these steps: Go to the File tab and select Open & Export. Lifewire Select Import/Export to start the Import and Export Wizard. Lifewire Choose Export to a file, then select Next. Lifewire Choose Comma Separated Values, then select Next. Lifewire Highlight the Contacts folder for your email account, then select Next. Lifewire Select Browse. In the Browse dialog box, navigate to the location where you want to save the file, enter a file name, then select OK. Select Next. Select Finish. The CSV file is exported to the location you designated.

How to Export Outlook Contacts from Outlook Online

If your contacts are stored in the online version of Outlook, the export settings are in a different location. When you export your contacts from Outlook online, they will be saved as a CSV file that can be imported into another email service or account. Log into your Outlook.com account. Select the People icon at the bottom of the navigation pane on the left side of the screen to open your list of contacts. Lifewire Select Manage on the toolbar above the contacts list and choose Export Contacts from the drop-down menu that appears. The Export Contacts dialog box will open. Lifewire Choose All Contacts if you want to export all the contacts in your account. If you want to export contacts in another folder, select that folder. Select the Export button to continue. Lifewire The exported contacts will be in a CSV file located in your device's default Downloads folder. 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 Export Your AOL Mail Contacts CSV File (What It Is & How to Open One) How to Export Contacts in Mozilla Thunderbird How to Import Outlook Contacts Into Apple Mail How to Export Contacts From iPhone How to Add Members to a Distribution List in Outlook How to Export Contacts From Windows Mail Export Mac Mail Address Book Contacts to CSV File How to Export Data to Excel How to Import Addresses Into Gmail From Other Email Services How to Print Your Outlook Address Book How to Export Your Yahoo Mail Address Book How to Export Contacts and Email Addresses From Hotmail How to Use macOS Contacts With Outlook How to Create a vCard in Microsoft Outlook 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