Solved

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

Posted on 2011-02-22
8
580 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:jconnelley44
  • 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:jconnelley44
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
 

Author Comment

by:jconnelley44
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 50 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:jconnelley44
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:jconnelley44
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now