- In Outlook, on the File menu, click Import and Export.
- Click Export to a file, and then click Next.
- Click Microsoft Excel, and then click Next.
- In the folder list, click the Contacts folder, and then click Next.
- Browse to the folder where you want to save the contacts as an Excel file (.xls).
- Type a name for the exported file, and then click OK.
- Click Next.
- To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, clickMap Custom Fields.
- In the From box, drag the field you want to convert onto the Outlook field that is listed in the To box.
Note The Name field doesn't appear in the From box, because Outlook reserves the first row of a named range 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 ensure 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.
- To display additional fields in the From box, click the plus sign (+) next to the field. For example, to display theBusiness Street and Business City fields, click the + next to Business Address.
- Click Finish.