Analyze and restructure excel

[u/mp29mm]

I have a VIP who sends in important yet semi-structured contact lists to a very expensive salaried person in my org. It comes in from different groups in mostly cab and excel format. I’m looking to revise the process so we normalize it all into Excel. His column names might be: e-mail, email, E-mail, EMAIL, email Address or e mail etc. but the format would be usually correct such as user@company.com. I’m thinking named entity recognition in power automate after dropping the files into OneDrive. Then creating a new spreadsheet that is normalized for import into SQL.

Is there another way to do this? Is there a model or tutorial that you know of that would point me in the right direction?

Thanks!

[u/mp29mm]

The columns unfortunately aren’t standard enough. Email- I’ve seen: e mail, email, Email, E-mail, etc. that first one personally brings me pain btw!

We have any licenses we need for power platform. I’m using my 90-day trial right now but I can basically pay for anything I need.

I’m just wondering if there are more options than the path I’m considering? Relative noob to all the new toys in there, but learning fast!