Solved

Sharepoint list - import and append

Posted on 2012-04-10
2
517 Views
Last Modified: 2012-04-11
Is there a method I can use an existing spreadsheet to add a batch of new items to a pre-existing SharePoint list?
0
Comment
Question by:K_Deutsch
[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
2 Comments
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 250 total points
ID: 37830134
If MOSS 2007 you can open the list with Excel, make changes and save.

If SharePoint 2010, not with Excel - no longer supported.

You can use MS Access to edit and add items to the list in 2010. When in the list view, the ribbon should have a open in Access button. (It also has an open in excel button but it's read only).
0
 
LVL 2

Assisted Solution

by:ArticalBadBoy
ArticalBadBoy earned 250 total points
ID: 37831506
You should be able to perform this action in both SharePoint07 or SharePoint2010 if you download and install “Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists” to your copy of Excel 2007/2010.

In the case mentioned, it will be a little more complicated though, as from my understanding you have already got a sharepoint list, and ALSO a spreadhseet ith additional data.

You would need to export the current list as a spreadsheet; ensure it was a table, then copy and paste the data from the other spreeadheet into this newly exported one, and then syncronise back into SharePoint. You need the Add-in toget it syncronised back into SharePoint.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

734 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