SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I imported a bunch of outlook contacts to a OOTB sharepoint contacts list.

it however did not copy some contacts with similar names.

Is there a way for me to force copy all contacts to the list??


share|improve this question
up vote 1 down vote accepted

can you see if this works out for you?

and / or check this out:

  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.

taken from

hope this helps :)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.