How to Import Data from Multiple Excel Sheets into Microsoft Lists

Open your Excel workbook. Go to each worksheet, select your data range, and press Ctrl+T (or go to Insert > Table) to format the data as an official Excel Table.

Create a new blank worksheet in your workbook. Copy the data rows from each of your existing tables and paste them successively under the same column headers in the new master sheet.

Select the newly combined dataset in your master sheet and format it as a Table (Ctrl+T). Save the Excel file to your computer or cloud storage.

Open Microsoft Lists, click 'New list', select 'From Excel', upload your saved workbook, and choose the newly created master table to import all your combined data.

Verify that all worksheets have their data formatted as Tables and that the Excel workbook is saved in an accessible cloud location like OneDrive or SharePoint.

Log into Power Automate and create a new automated or instant cloud flow. Add the action 'List rows present in a table' for each specific Excel worksheet.

Add an 'Apply to each' control to loop through the retrieved rows. Inside this loop, add the 'Create item' action designated for SharePoint or Microsoft Lists.

Map the dynamic content variables from your Excel rows to the corresponding columns in your Microsoft List, save the flow, and test it.