William Leggett

If you are using Outlook or Outlook 2007 and working with a personal contact list, here is how you can make use of the export functionality inside of Outlook.

1. Click on File > Import and Export
2. Choose Export to a file and then next
3. Choose Comma (or Tab) separated values (Windows) and then next
4. Navigate to Contacts in the list of folders and then next
5. Provide a filename and location to save the contacts list and then Next
6. To customize the fields to export, choose Map Custom Fields
7. Modify the fields that you wish to export
8. Click OK and then Finish to export the file.
9. Open the file in Excel and then save it as an excel document (XLS or XLSX)
10. Go to SharePoint and choose to create a new list.
11. Select Import from Excel under Custom Lists
12. Import your contacts list.

This should allow you to work with contacts. However, if the contacts are in the Global Address List (Exchange Servers), you’ll have to make a copy to a personal contacts list first and then do the export.