P

[foodd]

Power BI isn't an automation suite, I'd consider Power Automate, VBA or Python. One option would be to use Power Query in Excel, where the result loads to a table in a worksheet, and then save the workbook as a CSV.  

[aswanth]

Ok I will post in Power query platform

[foodd]

The point is not to move the post to the Power Query Forum.  It is that you need to build out the business logic on which tools you will use, and how they will be used.   Recommend you explore your options and once you have a sense of a direction, do your best to produce an inventory of Excel files, where stored, and add more information to your transformation requirements.    This is a small project, and as such you and your company will need to scope out how the company data assets are impacted, and any risks identified.   Then, if you need assistance feel free turn back to one or more of the Community Forums, and if possible post in a 'one question' -> 'one answer' approach.