Solved

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

Posted on 2011-02-22
8
601 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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 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: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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

624 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