Migrating Large Data Set from Excel to SharePoint


I have an Excel workbook with twelve sheets (one for each month of the year), each sheet has at least 50,000 line items. More than 500,000 line items.

Anyone have any recommendations or cautionary tales about using Power Automate 'Create item' to migrate this data and create SP List(s).

Should I create multiple lists, one for each sheet. Can I even, should I even try to, get all the data on one list?

Recommendations on how to access and view the data on the SharePoint side?

Thanks for any kind words!

0 Replies