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?
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.