Solved

Sharepoint list - import and append

Posted on 2012-04-10
2
515 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
2 Comments
 
LVL 31

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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. …
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
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…

820 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