Johnette Connelley
asked on
How do I import a spreadsheet into a Sharepoint contacts list?
I have to create an emergency contacts list in Sharepoint. I have the information in a spreadsheet. How can I import it into the list. The last thing I want to do is individually add this information.
ASKER
Sorry George, not in this version. SharePoint Server 2010 seems to have taken away more options than it provides. I can export the file, but there is no import function that I can find. See the screenshot below. jconnelley44-412441.flv
No no , that is still in the 2010 too
You are inside the list already
but that process I have described actually creates a new list for you.
you need to go to to the site level , - > Create - List under lists.
You are inside the list already
but that process I have described actually creates a new list for you.
you need to go to to the site level , - > Create - List under lists.
ASKER
My fault here entirely. I need this to be a CONTACTS, as in email contacts, list. Not just a regular list. I do not want these contacts in my regular Outlook contact list. By creating a separate contacts list here I can add that list to Outlook, and my users will be able to access and update their information.
If I create this as a simple List, and import the data, can I move that data over to a CONTACTS list?
If I create this as a simple List, and import the data, can I move that data over to a CONTACTS list?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I believe I have come up with a solution. I created the Contact list, switched to Datasheet view, and copied the information into it. Now all I need to do is figure out how to access it outside of Sharepoint.
Select the List actions , -> Connect to Outlook.
ASKER
You have been a great help sir.
After many frustrating forays into the Sharepoint knowledge base, I found a one sentence answer to the original post. You cannot import a spreadsheet into a contacts list.
MicroSoft: Fail.
GeorgeGergues: Pass!
Thanks again.
After many frustrating forays into the Sharepoint knowledge base, I found a one sentence answer to the original post. You cannot import a spreadsheet into a contacts list.
MicroSoft: Fail.
GeorgeGergues: Pass!
Thanks again.
Select Create .
from the List menu select Import Speadsheet.
Best of luck.