Although 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.

Fortunately there is another, more graphical (WYSIWYG), way to do this as well;

1. Change your view to a table view like the “Phone List” view;
   • Outlook 2010
     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
     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
     
     Note that you can choose even more fields by using the dropdown list.
3. Press OK until all the open screens are closed.
4. Choose Edit-> Select All or press CTRL+A to select al your contacts.
5. Choose Edit-> Copy or press CTRL+C.
6. Open up Excel and select cell A1.
7. Choose Edit-> Paste or press CTRL+V to paste all contact information.
8. Save your Excel sheet

Note: This is an export and not a backup. For info on backing up and restoring your Outlook contact and other data click here.