1,385 articles and 9,407 comments as of Monday, February 15th, 2010

News Feed Comments

You are here: Home / Author / Guest Post / Jason Rendel / Import Contacts into SharePoint
Tuesday, March 10, 2009

Import Contacts into SharePoint

Comments: 3

A note from Mark Miller: This article was sent in by Jason Rendel, a frequent reader of EndUserSharePoint.com. If you’ve got a special tip, let me know. — Mark

In Office 2007 you can synchronize the list with your contacts. Unfortunately we don’t have Office 2007 so it is a bit trickier.

In Outlook, navigate to the contacts list:

  • File  
  • Import and Export  
  • Proceed to export contacts to a spreadsheet
  • Make note of where the file is saved, the default is you’re “My Documents” folder 

    • In SharePoint from your contacts page:

  • Select Actions -> Edit in Datasheet
  • Ensure that there is at least one row in the list
  • Click and drag the auto fill on a cell down to create enough rows for your contacts In Excel:
  • Open the worksheet you exported earlier
  • Select the row values from a column for all contacts
  • Copy In SharePoint:
  • Right Click in the first cell in the datasheet
  • Paste 

    • Proceed to bulk import data. You may be able to work on multiple columns at one time but this depends on how similar your spreadsheet and list are.

    Guest Author: Jason Rendel

    I recommend SharePoint resources daily on my twitter account here.

    Posted by Natasha on Tuesday, March 10, 2009 at 10:06 pm 
    Filed under Tips and Tricks · Tagged with , , , ,

     

    Please Join the Discussion

    3 Responses to “Import Contacts into SharePoint”
    1. Don Pham-Doan says:
      October 14, 2009 at 2:31 pm

      I have been trying for months to copy around 2500 contact addresses from Outlook 2007 to the contact of SharePoint Server 2007, by drap and drop.
      At >95% of the action, MS Outlook crashes. Then the copied contact adresses start to duplicate on SharePoint. If I don’t delete them, they will be around 5000 addresses in few days.
      Have you any idea?
      Regards,
      Don

    Trackbacks

    Check out what others are saying about this post...
    1. SharePoint Daily says:
      March 11, 2009 at 8:28 am

      SharePoint Daily for March 11, 2009…

      Top News Stories SharePoint Gets Smart Accessibility Capabilities (CMSWire) Accessibility is an important…

    2. Microsoft SharePoint Bloggers says:
      March 18, 2009 at 3:03 am

      Wednesday Morning SharePoint Reads And More…

      URL: Wednesday Morning SharePoint Reads And More Body: Have a busy busy day today. Did want to get out…



    Notify me of comments to this article:

    Speak and you will be heard.

    We check comments hourly.
    If you want a pic to show with your comment, go get a gravatar!