Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

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?

share|improve this answer
    
Datasheet view and access solved my problem. –  Rohita Khatiwada Feb 4 '13 at 20:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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