Import all of multi-sheet Excel spreadsheet into List?

I need to import a multi-sheet xls into a SharePoint list. Is this doable? I'm at the "Import to Windows SharePoint Services list" and trying to select a range, but really what I want is all non-null rows and columns of all pages of the xls imported.

Thanks,

Scott

April 21st, 2015 1:53pm

Hi scogordo,

From your description, my understanding is that you want to import a multi-sheet xls into a SharePoint list.

By default, when we import data from an excel file into a SharePoint, we just can import data from a spreadsheet, not multi-sheets. As a workaround, you can try to insert data from multiple spreadsheets into one main spreadsheet, then import the main spreadsheet into a SharePoint list.

About how to insert data from multiple spreadsheets into one spreadsheet, you can refer to:

http://smallbusiness.chron.com/insert-data-multiple-excel-spreadsheets-one-excel-spreadsheet-75667.html

If you just want to display the data of multi-sheet file in SharePoint, you can also upload the file into a library, then use Excel Web Access web part to display the data from the file.

Best Regards,

Wendy

Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 2:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics