Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 613
  • Last Modified:

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.
0
Johnette Connelley
Asked:
Johnette Connelley
  • 4
  • 4
1 Solution
 
GeorgeGerguesCommented:
Site Settings  menu.
Select Create .

from the List menu select Import Speadsheet.


Best of luck.


0
 
Johnette ConnelleyBudget Analyst / ProjectsAuthor Commented:
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
0
 
GeorgeGerguesCommented:
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.  
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Johnette ConnelleyBudget Analyst / ProjectsAuthor Commented:
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?



0
 
GeorgeGerguesCommented:
If you are looking to migrate some contacts to the Contacts list  .

you can do the following

1- Open your contact list in datasheet view
2- Make a note of your field headers name and sequence , for example ,  [ FirstName , LastName , Company , Phone ...]
3- Format your columns and order in your Excel sheet in that same sequence.

4- open the excel sheet Select your items and select Copy.
5- Open your contacts list in Datasheet view and do a paste at the end of your list it will add the items to the end of your list.


I do recommend doing this drill with one entry first , then do a large batch

Best of luck.
0
 
Johnette ConnelleyBudget Analyst / ProjectsAuthor Commented:
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.
0
 
GeorgeGerguesCommented:
Select the List actions , -> Connect to Outlook.
0
 
Johnette ConnelleyBudget Analyst / ProjectsAuthor Commented:
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.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now