Import all of multi-sheet Excel spreadsheet into List?

Question

_{Tuesday, April 21, 2015 5:52 PM}

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

All replies (1)

_{Wednesday, April 22, 2015 6:24 AM ✅Answered}

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

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].