How to Export Outlook Contacts into Excel

Exporting Outlook Contacts into a spreadsheet can be used to move data from Outlook into another mail client or as contact backup in case of an emergency. This guide shows how to export Office 365 Contacts from Outlook Desktop into an Excel spreadsheet.

Export Contacts with Outlook

  1. Open Outlook Desktop.
  2. Click File > Open & Export.
  3. Click Import/Export. (See figure below.) The Import and Export Wizard will open. (See figure below.)
  4. Click Export to a file under Choose an action to perform.
  5. Click NEXT. You will be taken to the Export to a File wizard. (See figure below.)
  6. Click NEXT.  You will be taken to the next step of the wizard. (See figure below.)
  7. Choose the desired Contact Folder to export from. In this example, choose the main Contacts folder.
    NOTE: Exporting the parent folder will not export subfolder content.
  8. Click NEXT. You will be taken to the next step of the wizard. (See figure below.)
  9. Click Browse and select the destination for the export.
  10. Click Next. You will be taken to the next step of the wizard. (See figure below.)
  11. Click Map Custom Fields to customize which contact fields appear in the exported file.
    NOTE: Skip to Step 12 to export the default contact fields.
  12. Click Finish. 
    NOTE: Exporting a file may take a few minutes. This procedure cannot be canceled.

Recommended reading: How to Add a Shared Mailbox to Outlook?

Copying and Pasting Contacts into Excel

  1. Open Outlook Desktop.
  2. Click the People View icon at the bottom of the left-hand navigation panel. (See figure below.)
  3. Your Outlook Address Book will appear. (See figure below.)
  4. Click List from the Current View drop-down. (See figure below.)
  5. Collapse all undesired contact fields.
  6. Copy all contacts desired contacts.
  7. Open Excel.
  8. Paste all copied contacts into Excel.

 

Related Articles:

Set up and start syncing contacts to business smartphones in less than 5 minutes.

Try for Free

jon-harris

Jon Harris is a Technical writer with experience working for cybersecurity and tech related companies. He has a bachelor's degree in computer science and likes to read, hike, and fish in his spare time. He began his career in computer science before pursuing a career as a writer, and editor.