Is is possible to populate a SharePoint list from an Excel sheet?

Question

So you can export a list to a spread sheet, but can you do the opposite? Preferably from an Excel sheet.

Answer 1

Yes, you can do it from Excel 2003 :( bit is bit limiting. There is a workaround to do the same from Excel 2007...

But, to achieve best results you should use Access 2007 because it provides you with everything you need. It allows you to do the same you can as from the web interface.

Answer 2

Go the the Create menu in sharepoint and upder Custom Lists, click Import Spreadsheet. Type the name of the list, browse to the spreadsheet and click Import.

You can also sync your spreadsheet and list on a continual basis by making a list on your spreadsheet and then publishing that to sharepoint.

1. Open your sheet
2. Select your data
3. Click Crtl+l
4. Click ok
5. Right click list
6. Publish list
7. type name of sharepoint site
8. name of sharepoint list
9. click Finish

Answer 3

Yes, it is possible to import excel sheet into SharePoint. Its an Out of the Box feature of SharePoint.

Please refer following SharePoint tutorial which describes step by step how to import excel sheet into SharePoint.

http://www.etechplanet.com/post/2008/11/26/How-to-import-an-Excel-SpreadSheet-in-SharePoint-and-save-it-as-a-Custom-List.aspx