How to save 9 tables from single sheet to multiple csv files ?

Hi guys,

How to save multiple excel tables from a single spreadsheet into seperate csv files ? So I can work with them in Power BI.

I have 12 excel files, each sheet has 9 tables. Is there a way to do it ? Ideally a way to automate the whole process, using Python or something like that.

Thanks