Export Contacts to Excel

Export to Excel buttonAlthough the Import and Export wizard allows you to export to an Excel spreadsheet, the Wizard doesn’t allow you to export all the fields and filtering the mapped fields is a cumbersome process as well.

The export to Excel option has been removed from Outlook 2013 mainly because it was still using the old xls-format instead of the new xlsx-format. You can still achieve the same by exporting to the csv-format but that can be even more cumbersome.

Fortunately there is another, more graphical (WYSIWYG), way to do this as well via the copy/paste method.

  1. Change your view to a table view like the “Phone List” view;
    • Outlook 2010 and Outlook 2013
      Home tab-> group: Current View-> Phone
    • Outlook 2007
      View-> Current View-> Phone List
    • Outlook 2003
      View-> Arrange By-> Current View-> Phone List
    • Outlook 2002 and previous
      View-> Current View-> Phone List
  2. Insert and arrange the columns you want to export to Excel
    • Outlook 2010 and Outlook 2013
      Tab View-> group: Arrangement-> button Add Columns
    • Outlook 2007
      View-> Current View-> Customize Current View…-> button Fields…
    • Outlook 2003
      View-> Arrange By-> Customize…-> button Fields…
    • Outlook 2002 and previous
      View-> Current View-> Customize Current View…-> button Fields

      You can choose between even more fields by selecting “All Contact fields” from the “Select available columns from” dropdown list.  
      You can choose between even more fields by selecting “All Contact fields” from the “Select available columns from” dropdown list.

  3. Press OK until all the open screens are closed.
  4. Press CTRL+A to select al your contacts.
    (In Outlook 2007 and previous, you can also use Edit-> Select All)
  5. Press CTRL+C to copy your selected Contacts.
    (In Outlook 2007 and previous, you can also use Edit-> Copy)
  6. Open up Excel and select cell A1.
  7. Press CTRL+V to paste all contact information or use the Paste button on the Ribbon or on the Toolbar.
  8. Save your Excel sheet ;-)

Note:
This is an export and not a backup. For information on backing up and restoring your Outlook Contacts and other data see the guide: Backup and Restore all Outlook data.