Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Import Excel Spreadsheet

  Asked By: Chaim    Date: Aug 20    Category: Sharepoint    Views: 2583

Is it possible to import an excel spreadsheet into Windows SharePoint Services
v2 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 sheets
with data? Will this data all get loaded into one list or create multiple lists

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Kerri Steele     Answered On: Aug 20

Well, you can publish an excel  list to sharepoint  and create  a list, not
sure about "importing" so much as "publish" and there is a difference. I
believe it allows you to set the parameters so that it will publish a sheet
or the entire workbook. Look for the checkbox in the dialogue when you do
it.

We do this from Quickbooks to Excel to Sharepoint all the time (Although I
wish 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 the
list name you want to create. So that if your excel workbook is titled:

Mysecretformulatoruletheworld, you select the base website:



http://www.mycoolsharepointsite/default.aspx



Click publish and wait anywhere from seconds to an hour depending on the
amount of data  and you'll get

www.mycoolsharepointsite/.../mysecretformulatoruletheworl
d.aspx or something like that.

 
Answer #2    Answered By: Alisha Itagi     Answered On: Aug 20

I've got to try this - always did it from the SharePoint interface, and my
answer to the original questions would have been 1) yes, and 2) no, only 1
sheet instead of the entire workbook!

 
Answer #3    Answered By: Octavio Dotson     Answered On: Aug 20

You can buy List Bulk Import Web Part from Bamboo Solutions.

 
Didn't find what you were looking for? Find more on Import Excel Spreadsheet Or get search suggestion and latest updates.




Tagged: