Is it possible to import an excel spreadsheet into Windows SharePoint Servicesv2 and create a list? If yes, how is this done?If this can be done then can it also be done if the workbook has multiple sheetswith data? Will this data all get loaded into one list or create multiple lists
Well, you can publish an excel list to sharepoint and create a list, notsure about "importing" so much as "publish" and there is a difference. Ibelieve it allows you to set the parameters so that it will publish a sheetor the entire workbook. Look for the checkbox in the dialogue when you doit.We do this from Quickbooks to Excel to Sharepoint all the time (Although Iwish there were a more direct method without so much headache).In Excel, go to: Data/list/create list, then check "my list has headers"(these act as the list column names) then go back to Data/List/ and select"Publish list".Just enter the normal website url and the name of your workbook becomes thelist name you want to create. So that if your excel workbook is titled:Mysecretformulatoruletheworld, you select the base website:http://www.mycoolsharepointsite/default.aspxClick publish and wait anywhere from seconds to an hour depending on theamount of data and you'll getwww.mycoolsharepointsite/.../mysecretformulatoruletheworld.aspx or something like that.
I've got to try this - always did it from the SharePoint interface, and myanswer to the original questions would have been 1) yes, and 2) no, only 1sheet instead of the entire workbook!
You can buy List Bulk Import Web Part from Bamboo Solutions.