Skip to main content

Secondary navigation:

Information Technology Services

Importing a CSV file into Outlook 2002

Tip: We recommend that you print these instructions.

Part 1: Create a New Contact Folder

To create a new contact folder:

  1. From your Outlook menu, select File > New > Folder.
    The Create New Folder window will appear.
  2. In the Name: field type a descriptive name for your address book.
  3. In the Folder contains: field, select Contact Items.
  4. In the Select where to place the folder: window, select Contacts.
  5. Click OK to save your changes and close the Create New Folder window.
  6. You may see a dialog box asking if you want to add a shortcut to your Outlook Bar. Select Yes if you want your new address book to appear in the My Shortcuts area.  

Part 2: Import your .csv file

To import your .csv file:

  1. From your Outlook menu, select File > Import and Export.
    The Import and Export Wizard should appear.
  2. Select Import from another program or file and click Next.
  3. Select Comma Separated Values (Windows) and click Next.
  4. Use the Browse button to select the converted .csv file on your desktop (not the .txt file you exported) then click OK.
  5. Choose one of the following options:
    - Replace duplicates with items imported
    - Allow duplicates to be created
    - Do not import duplicate items
  6. Click Next.
  7. Select Contacts as the destination folder and click Next.
    Note: If you created a subfolder in your Contacts area for this address book (using Part 1), you should expand the Contact area by clicking on the (+) sign. Then select the subfolder.
  8. Review the action that will be performed then click Finish to import the file and close the Import Wizard.
  9. Verify that your contacts have been imported properly by viewing your Contacts area.