Through the enterprise version of excel I can pull via "Excel Exchange Online" all E-Mails within my company. Due to privacy reasons, I need to remove all names mentioned in the body of the emails.
At the moment I'm saving the excel and then using python to transform the excel file to an csv and then use some custom functions and pandas to transform the data as I need it.
Is there a way to load the data into excel, push it into somewhere (blob storage, on premise or cloud?), apply python code to the data so that all the names are removed (azure functions?) and load it into a sql table and delete the excel file after everything is done? The best case scenario would be it updates every 6 months.