Import excel data to SharePoint list

This is one of the nice and best SharePoint feature that we have implemented. By default SharePoint will provide us an option to edit in spreadsheet or download list items in spread sheet. But, it doesn't have the option to import the excel data to SharePoint list. When we have data in excel format and want to import that data to a sharepoint list, then how to do. That is why we took it as a challenge and implemented this.

And second reason is, this feature has a nice and wonderful feature of column mapping. You can manually choose column to column mapping, so that the column names not needed to be exactly same. This is one of the best option in this feature.

This feature works for both SharePoint and WSS.

The installation is simple and it is using the codeplex sharepoint installer package to install the feature. As it is developed as a SharePoint feature, you can get this feature associated with each list under the actions tab once you activated it. You can call this feature by going to specific list, under actions menu item just click on the feature name. Then it will take to a page which has a nice user interface to upload an excel, then choose specific sheet and then map the fields as you want.

You can take a look at it here on CodePlex.

http://spreadsheet2splist.codeplex.com/

I think, this will help you out to import data from excel to SharePoint list problem. Isn’t it?