Apr 17 2023 06:22 AM
Apr 17 2023 07:16 AM
When creating a Microsoft list in SharePoint Online, you can save time by importing an existing Excel spreadsheet.
This method converts the table headings to columns in the list, and the rest of the data is imported as list items.
However, this method only allows you to import one sheet at a time.
If you have multiple sheets in your Excel file that you want to import into a single SharePoint list, you will need to combine the data from all sheets into a single sheet before importing it into SharePoint.
Alternatively, you could use Power Automate to automate the process of importing data from multiple sheets in an Excel file into a SharePoint list.
I hope that I could help with that!
Apr 17 2023 07:31 AM
@Sonyat810 I don't think you will be able to import all tabs in a single list using SharePoint out of the box capabilities.
You will have to combine the data from all the tabs into single tab/sheet table and then import it into SharePoint. OR you will have to use custom solution using SPFx or PowerShell or Power Automate.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs