• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

SharePoint 2010 Export LIsts/add/amend/delete data then Import List back to SharePoint

with SharePoint 2010 is it possible to Export LIsts/add/amend/delete data then Import List back to SharePoint.

This would be done as part of a bigger macro which would compare the data on the downloaded List against external data. Changes would then be made and then I would like to upload the list back to sharepoint with the changes.

Possible or not?

If possible would appreciate step by step as I am not that familiar with Sharepoint

1 Solution
JagwarmanAuthor Commented:
I should add, I am looking to this this with Excel 2010
The MS recommended way is to use Access and the MS Excel link has been 'deprecated' - but they may change their minds again :)

I don't speak from personal experience here but I believe that its possible to use the 2007 add-in with 2010 - you can download it here:-

However I don't think it provides the sort of 'round trip' you are looking for - its more a way of synchronizing excel table with a sharepoint site.

There is a third party tool here which purports to do the same thing better but I have never used it:-
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now