Improve company productivity with a Business Account.Sign Up

x
?
Solved

How do I import a spreadsheet into a Sharepoint contacts list?

Posted on 2011-02-22
8
Medium Priority
?
614 Views
Last Modified: 2012-05-11
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
Comment
Question by:Johnette Connelley
  • 4
  • 4
8 Comments
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 34955627
Site Settings  menu.
Select Create .

from the List menu select Import Speadsheet.


Best of luck.


0
 

Author Comment

by:Johnette Connelley
ID: 34956154
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
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 34956329
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 

Author Comment

by:Johnette Connelley
ID: 34961081
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
 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 200 total points
ID: 34961159
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
 

Author Comment

by:Johnette Connelley
ID: 34961256
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
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 34961269
Select the List actions , -> Connect to Outlook.
0
 

Author Comment

by:Johnette Connelley
ID: 34961378
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

These days socially coordinated efforts have turned into a critical requirement for enterprises.
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question