Forum Discussion
Importing Excel with multiple tabs as a list
I have a excel sheet with multiple tabs. I want to import all the tabs in my list. Is there a way to do this?
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!