Export Contacts to Excel

Although the Import and Export allows you to export to an Excel spreadsheet I think that the Wizard isn’t much of a help in getting it exported the way you want it. Also mapping and choosing fields to export isn’t much fun in the wizard either. Fortunately there is another, more graphical (WYSIWYG), way to do this as well;

1. Change your view to a table view like 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 2003: View-> Arrange By-> Customize…-> button Fields…
   Outlook 2002 and previous: View-> Current View-> Customze Current View…-> button Fields
   note that you can even choose more fields by using the dropdown list
3. Press OK twice to close all the open screens.
4. Choose Edit-> Select All to select al your contacts
5. Choose Edit-> Copy
6. Open up Excel and select cell A1
7. Choose Edit-> Paste 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 data click here.