How would you approach this project? Need some expertise

Hello everyone,

My boss just quit the company and his project dropped on my lap, and I'm a bit hesitant on how to approach it. Maybe someone can point me in the right direction here..

The premise is this: we have a book of customers who own multiple properties (sometimes in the thousands per customer). Each month, they send us excel/csv spreadsheets with a list of all existing properties,their corresponding addresses and a bunch of other data for us to review. As you can expect, many customers have different formats (how columns are ordered, "location" instead of "address", "building #" vs "building number", number of columns etc etc).

What we are trying to do here is create a database with all these properties, which we will be updating monthly as new data come in. The plan is to use Azure SQL database to store this data.

The question is, what are my options to get all that data normalized and brought to a single format so I can feed it into the database? The way I see it, I would need to create some sort of a profile for each customer in order to parse their spreadsheets correctly and have their data rearranged to fit my database. Not really sure. Has anyone here worked on something similar?

Really need your expertise here! Thanks a lot in advance