How to sync data from excel to multiple sharepoint lists and adding new columns etc?

[someonerandom]

Hi,

I have a rather large skills matrix database that contains the name of people and the courses they have done each with an expiry date,

This list has around 400 courses and 40 or so names each course that is completed by the employee has the courses expiry dates,

Currently they are split up into 15 seperate sharepoint online lists and a powerbi dashboard reads the data from them,

My problem is inputing new data, i could build a massive powerbi or teach the admin sharepoint, however to build a powerapp that large is problematic across many lists and the amount of data (do able but its just not convient to enter the data) it is far quicker and convient to use an excel file,

My questions are

can i use one excel file to sync to multiple sharepoint databases,

and how do go about when a new course or employee is added?

Could anyone help me out with what you have done to solve this problem im not sure the best way to solve this and i would love some advice

[AllisonKennedy]

Can you provide some sample of how the data looks? What is the column structure?

Is it safe to assume that you have tried the Quick Edit/Data Sheet view in SharePoint which converts it into an Excel type view?

Power Automate can probably help you with this as well?

[someonerandom]

---

@AllisonKennedy wrote:
Can you provide some sample of how the data looks? What is the column structure?

Is it safe to assume that you have tried the Quick Edit/Data Sheet view in SharePoint which converts it into an Excel type view?

Power Automate can probably help you with this as well?

---

Hi,

My excel file looks like this (sample the data is sensitive)

The sharepoint sites that i made online are