Solved

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

Posted on 2011-02-22
8
570 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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This video discusses moving either the default database or any database to a new volume.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 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