Import contacts from Excel to Outlook

Applies to
Microsoft Office Outlook® 2003
Microsoft Outlook® 2002
Microsoft Office Excel 2003
Microsoft Excel 2002

The Import and Export Wizard in Outlook makes it easy to import contact information from an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) into your Outlook Contacts folder.

  1. In Outlook, on the File menu, click Import and Export.
  2. Click Import from another program or file, and then click Next.
  3. Click Microsoft Excel, and then click Next.
  4. In the File to import box, browse to find the Excel file (.xls) that contains the content you want to import.
  5. Click one of the following:
    • Replace duplicates with items imported
    • Allow duplicates to be created
    • Do not import duplicate items
  6. Click Next.
  7. In the folder list, click the Contacts folder where you want the imported contact information to go, and then click Next.
  8. To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields.

 Note   The Map Custom Fields button in the Import a File dialog box might not be available when you try to import data from another program or file. In the The Following Actions Will Be Performed box, select the Import check box, and then the Map Custom Fields button is available.

ShowHow?

  1. In the From box, drag the field that you want to convert onto the Outlook field that is listed in the To box.

 Note   The Name field doesn't appear in the To box, because Outlook reserves the first row of a named (name: A word or string of characters in Excel that represents a cell, range of cells, formula, or constant value.) range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) for field names. If the range that you import does not contain field names, the first row of data will be interpreted as field names and will not be imported as data. To make sure that all of the data in the named range is imported, use the first row for field names.

  • To see additional records in the From box, click Previous or Next.
  • To remove all mapping, click Clear Map.
  • To reset the original mapping, click Default Map.
  1. To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the plus sign (+) next to Business Address.
  1. Click Finish.
 
 
Applies to:
Excel 2003, Outlook 2003