Search code examples
excellistsharepoint-2010sharepoint-2007

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]


Solution

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