Tool to import Excel sheet data to Sharepoint list

问题:

Are there any tools to import Excel sheet data to Sharepoint list ? I have found a tool to do that. Are there any alternatives to do this task?

[should be support any Excel version and any SharePoint version]

回答1:

IMHO

Simple copy/paste form Excel to DataSheet view can cover simpler scenarios (if you are copying text and/or numeric values) If you need to copy some other data like usernames things can get difficult.

Bulk copy and paste into a SharePoint List

One alternative is to code your own solution using eg. console application and web services (2007 and 2010) or using client object model (2010). It is not difficult to even write PowerShell script to do some specific and/or semi-generic import job.

There are so many different possibilities (eg. how excel file is formatted) that finding universal tool is not an easy task. If you are able to make some Excel formatting standards then developing own solution is much more effective then buying some robust universal tool.

回答2:

Sharepoint have OOB features to import the excel sheet.

you can check it over here.

http://sharepointbuzzer.com/2010/10/22/import-excel-sheet-as-sharepoint-list/

回答3:

Copy the data from excel and open the list in Datasheet view in IE Browser and then paste it in second column.