Extract data from excel file to sharepoint list once uploaded in library

Question

We have a requirement that when an excel file will be uploaded into SharePoint document library, all its data should be captured and should be moved to separate lists accordingly.

for example: if we have two fields called "user" and "user access" in excel then after uploading of excel file into SharePoint library, "users" field values should be created in a separate "users" list and "user access" field values should be created in access list of SharePoint. How to extract those details? Is workflow can do that or any other way?

below is the sample input of excel file to be uploaded:-

Answer 1

Here are steps for your reference:

Step1: Format the excel file as table refer to this article, the result looks like this:

Step2:Create a flow to list rows present in a table, apply to each to cycle the table and create new item in different lists using differnent column name.