How to export files to SharePoint document library with metadata

Hi jcgonzalezmartin, It does not work in this way.

We have M-Files application. This application stores all files and then categorize them by metadata.

When I export the files from the M-Files, it gives me two files. 1-An excel that shows all metadata. 2-Folder that shows all Files/documents.

To upload all documents in a SharePoint document library is easy.

But then I have to g into the document library and create each metadata that is in the excel files and then go through 10.0000 files and assign them to each metadata based on the excel file.

However, I think there must be a solution such as:

1-Create SharePoint document library (I can do it manually) 

2-Create all metadata that is in excel sheet(which I got it when I export files from the M-Files application) (I can do it manually ) 

3-Uplaod all files.(I can do it manually or PowerShell) 

So far so good. I need a help from here on...

4-I need a PowerShell script that can upload my excel sheet(from my computer) which has all metadata to the SharePoint document library (created at step-1) and can map/assign those metadata to the relevant files that I upload at step 3.

Hope that is clear.

Thanks