0

In Sharepoint 2010 it is possible to export list into excel sheet format, but is it possible to edit list and then export it back to same Sharepoint list?

For example:

1) Sharepoint list (lets say MySharepointList) --> exporting to Excel 2) Make some changes in the Excel sheet. 3) Export changed excel list back to Sharepoint list (i.e MySharepointList).

My purpose, is to use Excel sheet for editing. Because sometimes when there are many columns and we need to edit only one , in Sharepoint we are bound to open whole row for editing. i.e. we cannot click in a column and edit directly in a list.

Improve this question
1

1 Answer 1

Reset to default
1

You can't sync back again, not OOTB. There is a plugin from Microsoft, but then you need to create the list from Excel, and if I remember correctly all fields will be strings. There is an blog post on sharepoint.microsoft.com on how to use it. What about using DataSheet View, Access or SharePoint Workspaces?

Improve this answer
2
  • Datasheet view and access solved my problem.
    – Rohita Khatiwada
    Commented Feb 4, 2013 at 20:30
  • @Anders-Aune Actually this is supported, just not easily and has some caveats to it. See my answer linked above. :)
    – Chiramisu
    Commented Nov 14, 2017 at 18:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.