How to Export Outlook Address Book Contacts

A knowledge base article about How to Export Outlook Address Book Contacts provided by the UC Berkeley IT Service Hub - Knowledge Portal

How to Export Outlook Contacts from Outlook 2003-2010

Before you begin

To Export Contacts from Outlook 2010

  1. Open Microsoft Outlook 2010
  2. Go to File > Options > Advanced and click Export.
  3. Choose Export to a File > Next > Comma Separated Values (Windows) > Select the Contacts folder and click Next.
  4. Name the file (e.g. UsernameContacts.csv) 
  5. Click OK > Next > Finish
  6. Close the Advanced Options window. 

 

To Export Contacts from Outlook 2007 and 2003 

  1. In Outlook, on the File menu, click Import and Export.
  2. Click Export to a file, and then click Next.
  3. Click Comma Separated Value and then click Next.
  4. In the folder list, select the contacts folder you want to export, and then click Next.
  5. Choose a location on your computer to save the file. NOTE - You can delete this file after your contacts are imported into bMail.
  6. Name the file, and then click OK.
  7. Click Next.
  8. Click Finish.
  9. Log on to your bMail account (bmail.berkeley.edu).
  10. In the left column, click Contacts.
  11. Click on More, select Import.
  12. Under Import Contacts, click Browse.
  13. Select the file you exported.
  14. Click Open.
  15. Click Import Contacts.

 

To Export Autocomplete Contacts From Outlook 2003 or 2007 NK2 Files

  1. Find the N2K file in the user’s profile. In Windows XP the AutoComplete .nk2 file is located in C:\Documents and Settings\user_name\Application Data\Microsoft\Outlook. In Windows 7 and Windows Vista the same file is located in c:\users\user_name\AppData\Roaming\Microsoft\Outlook.  at C:\Documents and Settings\%username%\Application Settings\Microsoft\Outlook
  2. Download N2KView from http://www.nirsoft.net/utils/outlook_nk2_autocomplete.html
  3. Open the N2K file with N2KView, and select the contacts you want to export
  4. Go to File > Save selected items
  5. Make sure it says comma delimited text file at the bottom and give the file a location, a name and click Save.
  6. Navigate to the file and open for editing.
  7. Delete all columns except for A and B.
  8. Insert a row at the top.
  9. Call column A:   Name
  10. Call column B:   E-mail 1 - Value
  11. Save the file and keep it in .csv format if it asks. 

 

For additional assistance, contact CSS IT at 510-664-9000 and follow the prompts to reach a technician from between 8 am to 5 pm, Monday through Friday. A ticket may also be submitted through http://sharedservices.berkeley.edu/it/ or by e-mailing itcsshelp@berkeley.edu