SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Your Answer


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.