A Complete Guide to Export Outlook Address Book to Excel CSV Format

  •   Written By
  • Published on
    March 22nd, 2014
  • Updated on
    July 26, 2022
  • Read Time
    5 minutes
Rate this post
Summary:-Microsoft Outlook stores all the address book data into a file, known as WAB or Windows Address Book file. If you have multiple identities in Outlook, the individual data of each identity is stored in a folder by the user name. But sometimes, you may need to separate the address book data for different identities or export Outlook address book to CSV format of Excel. That’s why, in this write-up, we will try to explain methods to export address book to Excel CSV from Outlook 2019, 2016, 2013, 2010, and Office 365.

What is the Use of Address Book in Outlook?

Outlook Address Book stores all the address books or address lists created on your Outlook folders. It allows users to select names, email addresses, and distribution lists when they address email messages. However, if you are using Outlook with your Exchange Server account, it includes the added book with Global Address List (GAL); basically, it is a list of everyone who has an Outlook account on the Exchange Server.

Reasons to Export Outlook Address Book to CSV(Excel)

There are multiple reasons to download the Outlook address book to CSV format of Excel.

  • Users need to take a backup.
  • To relocate the address book.
  • Users try to shift to a different platform for their basic needs.
  • You want to share the contact list information with others.

Whatever the reason is, to export Outlook export address book to CSV, you need to export them. So, go for the below-mentioned methods to export the Contacts of Outlook to CSV or Excel sheet.

Also Read: How to Recover Corrupted Excel File?

Best Methods to Export Outlook Address Book to CSV Format

The Outlook is available in different versions. Each version has a different way of handling it. So for exporting the data, I’m going to describe the methods for different Outlook versions.

How to Export Address Book from Outlook 2016?

To export the address book of the 2013, 2016 and 2019 versions, you need to follow the below steps:

  1. On the File menu, click on Open & Export, then Import/Export.
  2. Select Export To a File and then click on Next
  3. Now, select the Comma Separated File and hit the Next
  4. Select the Mail Backup folder that you created.
  5. From the personal folder, select the Contacts folder to export.
  6. Hit the Next
  7. Click on browse, and provide the name and location for the file.
  8. Click on Next.
  9. Hit the Finish button.

How to Export Address Book from Outlook 2010?

Follow the simple steps to export Outlook Address Book to CSV:

  1. Launch the Outlook application.
  2. Click on the Contacts on the left-hand.
  3. In the Current View, click on the List
  4. Select the contacts to copy.
  5. Use Ctrl+C to copy the selected contacts.
  6. Simply paste the contacts into an Excel spreadsheet using Ctrl+V.
  7. Now, save the copied contacts in XLS or CSV format.

How to Export Address Book from Outlook 365?

Follow the below steps to export the address book of MS Outlook 365 or Office 365:

  1. Open Outlook.
  2. Click on the application button in the top-left corner.
  3. Select People from the menu.
  4. Now, click on Manage and then on Export Contacts.
  5. Select specific or all contacts.
  6. Click on the Export.
  7. Now, your browser will ask you to either Open or Save the file.

How do I Export Outlook Address Book to CSV File?

Follow the below method if you want to export Address Book to CSV format in Outlook Express:

  1. On the File menu, click on Export. And then click on Address Book.
  2. Click on Text File (Comma Separated Values), and then click on Export.
  3. Click on Browse.
  4. Select the Mail Backup folder that you created.
  5. In the File Name box, type address book backup. And then click on Save.
  6. Click on Next.
  7. Click to select the checkboxes for the fields which you want to export. And then click on Finish.
  8. Now, click OK and then Close.

After exporting Outlook address book to CSV file, go through the file and look for any errors or data mismatches. If there is no integrity issue in your file, then you are good to go, and your backup is ready.

What if your Outlook address book file,i.e., WAB, gets corrupted or inaccessible for users? In that case, users can use the SysInfo WAB File Recovery. The software recovers vital contacts and other crucial information from corrupt address books of MS Outlook and Outlook Express. Furthermore, the software is compatible with all Windows OS like 11, 10, 8, 7, Vista, 2003, XP, and 2000.


The need to export the contacts arises due to many reasons. It is possible that the user wants to create a backup of the address book, share the contacts, or migrate those to other platforms. Whatever the reason, these methods are helpful for you and provide a complete solution to export Outlook address book to CSV. So, now you can easily export the address book from Outlook to CSV format or Excel. I hope it helped you out.

Related Post