Solved

Sharepoint list - import and append

Posted on 2012-04-10
2
513 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 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

23 Experts available now in Live!

Get 1:1 Help Now